HI,
I have a requirement to display countsfor last 10 days. For example my date dimension would be currentdate through currenrtdate-10. I created a variable saying date dimension between currentdate and currentdate-10 and used the same in the set expression which is working fine. I need to create another measure showing MonthTo date for the same 10 days. I created a variable with date dimension between Monthstart of currentdate and currentdate and used in the set expression. However my date dimension values are not limiting to 10 meaning date dimension are populating from 1st day of the month to currentdate. Is there a way to still limit the dimension values to 10 days in the charts. For example
Date | Count |
6/1/2019 | 1 |
6/2/2019 | 2 |
6/3/2019 | 3 |
6/4/2019 | 4 |
6/5/2019 | 5 |
6/6/2019 | 6 |
6/7/2019 | 7 |
6/8/2019 | 8 |
6/9/2019 | 9 |
6/10/2019 | 10 |
6/11/2019 | 11 |
6/12/2019 | 12 |
6/13/2019 | 13 |
6/14/2019 | 14 |
6/15/2019 | 15 |
6/16/2019 | 16 |
6/17/2019 | 17 |
6/18/2019 | 18 |
My Expected result is
Date | Cnt-Current | Count To Date |
6/18/2019 | 18 | 171 |
Any suggestions would be highly appreciated.