Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Our qvd has one record per customer, per subscription. I'm trying to make a bar chart that represents the number of unique customers active at the end of each month/year (i.e. the max date in the group).
I can get a distinct count by month. I'm able to calculate the correct end date for each year via aggr(NODISTINCT max([Period Date]),[Fiscal Year]) , however that calculation is not working in the bar chart expression that drills down from fiscal year to period date. In the example, I want the value for Fiscal Year 2015-2016 to equal 43,167. Instead, it shows 56,543.
Here's the expression I've been working with/on, but I could really use some help:
count({<[Period Date]={'=aggr(NODISTINCT max([Period Date]),[Fiscal Year])'}>}distinct [Customer ID])
=Count({$<[Period Date]={"=MonthEnd(Today() ,0)"}>} distinct CustomerID)==end of current month