Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table that a user can select which dimensions and metrics will be shown in the straight table. The totals are by the expression. The user would like to switch between a sum and an avg depending on which metrics they choose. Is there an easy way to let them do this since they will not be able to access chart properties? Perhaps a quick toggle?
I ended up having to create another expression so the original is SUM() the new one is AVG(). There is not a way to group it based on my other requirements so unfortunately they are listed separately. This would be a great feature in a new release - to allow the user to specify and switch between different aggregations.
switch the total (sum / avg) or switch the expression?
Hi,
maybe using expression grouping to switch between different expressions using a button in the chart header?:
hope this helps
regards
Marco
Both
This is a great idea and would work except I cannot change the properties of the group itself including adding a conditional statement which I have on the expressions but would like to have for the group too. For some reason those options get grayed out.
Hi Mary,
Please close the thread by selecting Correct Answer and Helpful Answer if you get the solution.
Thank you.
Yes, I will when do. Thanks.
I ended up having to create another expression so the original is SUM() the new one is AVG(). There is not a way to group it based on my other requirements so unfortunately they are listed separately. This would be a great feature in a new release - to allow the user to specify and switch between different aggregations.
PFA
You could as well use the same show condition on all grouped expressions to turn the group on/off:
hope this helps
regards
Marco