How to filter based on a selection?

Hi @1460052414 

Can you please elaborate a bit more?

Because if you want to calculate avg days or throughput time then you need to give two activities.

If you want to make it dynamic, means if you want to find the time difference between the start and end of the process whenever you pick any activity then you need to use variables in the formula.

AVG (CALC_THROUGHPUT(FIRST_OCCURRENCE[<Act_1%>] TO LAST_OCCURRENCE[<%=Act_2%>], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES"."EVENTTIME", <%=unit%>)))

Here Act_1 and Act_2 are the variables that can be selected from the activity dropdown and then you can have days between those activities.

Even the First and Last Occurrences can be made dynamic by using variables.

Hope it helps.

Happy Learning

Hi @1460069850 

thanks for replying.

If we use your example, I basically would want ACT_1 to always be the start of the process, and then ACT_2 to be any activity I pick. So, I was wondering if there is a more generic variable that I could use that would substitute itself with an activity that I select in the dashboard.

AVG(CALC_THROUGHPUT(CASE_START TO LAST_OCCURRENCE['ANY_ACTIVITY.Select'], REMAP_TIMESTAMPS("DATA_csv"."START_DATE", DAYS)))

something like this where ANY_ACTIVITY would automatically be replaced with a task, and ultimately allow me to calculate the days it takes to get from the start of the process, to "said" activity.

Thanks,

Terence

Hi Terence,

Create a variable (name it Activity ) and a button dropdown component. In the dropdown component you can select the right activity and write this to the variable.

AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[''Process Start''] TO FIRST_OCCURRENCE['<%= Activity %>'], REMAP_TIMESTAMPS("DATA_csv"."START_DATE", DAYS)))

Maybe this helps?

Best,

Jasper

Hi Jasper,

Just a few questions about yours...How do I create a new variable?

I currently have a button dropdown component in my dashboard which is something I actually wanted so that's good news. However, I'm not sure how I would go about linking the selection I make, to the newly created "variable"?

Thanks,

Terence

Hi Jasper,

Just wanted to let you know that your method has worked really well - I was able to figure it out.

However, just one question. Is there a way to filter a table too, based on a selection made in the button dropdown?

Thanks,

Terence

Hi Terence,

good to hear!

Yes, you can also filter a table with a variable. Set a component filter (right click on the component) like:

FILTER "your_tabel"."your_column" = <%= your_variable %>;

Or if you have multiple values;

FILTER "your_tabel"."your_column" IN (<%= your_variable %>);

In this case the values in the variable needs to be seperated with a comma (,). You can easily do that with selecting the "Allo multiple selections options in the Button dropdown component and set the seperator value as comma ( , ).

Also set the start and end wrapping characters wit a single quote ( ' ).

Best,

Jasper