Hi I need to show a line graph with only the values for dates where the month is a quarter - but I don't want to sum each quarter in the data point.
Dimension: =IF([ROLLING_DATA.Date.autoCalendar.Date]>='12/1/2016',AS_OF)
Measures:
sum({$<[CTO Grouping-Grouping]-={'Total Markel','ERROR CATCH','State National','CATCo','Noninsurance Division'}>}distinct[Personnel_LTM])
I'm thinking there needs to be somethingn different with the way I'm summing my measure - to just show for the distinct date - but I can't figure it out.
Thank you!