Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I need help, I want to display a year over year bar chart.
When we select any year, it should should display a year over year for the selection and for the previous year.
The expression should be based on the number of "Low" Consumers or on the number of "High" Consumers
Thanks in Advance
Expression 1
Count({< Year={$(=max(Year))}>} Consumers)
Expression 2
Count({< Year={$(=max(Year)-1)}>} Consumers)
Expression 1
Count({< Year={$(=max(Year))}>} Consumers)
Expression 2
Count({< Year={$(=max(Year)-1)}>} Consumers)
Hi,
add a calculated dimension for year like this
=if(Year=$(=Max(Year)) or Year=$(=Max(Year)-1),Year)
and in expression give
=count(Consumers)