I have a filter with years 2017,2018,2019. For example when I select year 2018, I want to be able to compute the count(ID) of the previous year (2017) as well.
Any idea on how to achieve this?
Solved! Go to Solution.
Thank you for your reply.
I have modified it to the following:
But results shows 30/12/1899 no matter what I select. Any ideas?
you can use chart Function that named Above() , if you set year As dimension, and in Expression write Above(count(ID)), it calculate the previous count (ID) according to value of dimension that you set.
fist of all I suggest you to try it in the straight chart with year as dimension and 2 Expression
and check and see does it work well for you or not.
I will be using the dates as a filter. This is what it will look like
Year(T_Date) as T_Year;
Load * inline
Filter box : T_Date
The second expression always gives a value of '0'. Any solutions?