Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a measure where i am trying to compare a list of ID's in a previous months report against a current month report and if there are any that do not appear in the current report then i want to flag it with 1. This is to be dynamic, so it needs to be done in the chart.
I have this measure working when i have the ID as a dimension. I don't want the ID showing in the chart, so i need to use the AGGR function to see the total (a sum of all the 1's) but I can't get it to work.
I have attached a sample, any help would be appreciated.
I have 2 measures, both give the same result, they are just written in a different way - I was trying different methods to try and get it working. If you select Aug-2023, I am looking for 9 to be the total. You will see 9 rows flagged with 1, I just want to sum those rows - but can't use the SUM in the totals function in the properties as this won't work when the ID is not in the chart.
Accepted Solutions
Hey @hopkinsc ,
Sorry for the late response. I have been busy for past 4-5 days and couldn't find time to take a look at your issue.
Hope you have found the solution by now. If not, please find below solution I applied to get total count of null IDs which were present in past month but not current month on the basis of OPCO field.
Expression used:
count({<ReportingYearPaymentFilter_Flag = {1},DailyRatesMonthYear={'$(vLastMonth)','$(vSelectedMonth)'}>}distinct GroundLeaseID)
-
count({<ReportingYearPaymentFilter_Flag = {1},DailyRatesMonthYear={'$(vSelectedMonth)'}>}distinct GroundLeaseID)
Output:
Hope this helps.
Regards,
Aditya
