Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
SRG
Partner - Contributor II
Partner - Contributor II

Display sums by date dimension

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 

 

DateCount
6/1/20191
6/2/20192
6/3/20193
6/4/20194
6/5/20195
6/6/20196
6/7/20197
6/8/20198
6/9/20199
6/10/201910
6/11/201911
6/12/201912
6/13/201913
6/14/201914
6/15/201915
6/16/201916
6/17/201917
6/18/201918

 

My Expected result is

DateCnt-CurrentCount To Date
6/18/201918171

 

Any suggestions would be highly appreciated.

0 Replies