line chart and data points plotted using variable date v using max(date)

Sa_Rah — Mon, 18 Sep 2023 12:33:11 GMT

I'm puzzled by the below and need some help.

If I use the following expression the associated line graph plots a data point for every month, irrespective of whether the cumulative value I'm calculating changes. The variable vUnderwayDate = '27/03/23' i.e. a fixed date in the past.

Expression 1:

if( MonthYearDate <= monthstart($(vUnderwayDate)) ,

aggr(rangesum(

above( Count( distinct {<Table = {"SIP"}, Attended? = {"Attended","Booked","In Progress"}>} ENo)

+0*Count(distinct {$+1<MonthYearDate ={">=$(=Min(MonthYearDate ))<=$(=Max(MonthYearDate ))"}>}ENo),

0,rowno()))

,MonthYearDate ))

Graph 1:

However if I amend the first line as follows and replace the variable with a max(date) formula, it only plots data points where the cumulative value changed:

Expression 2:

if( MonthYearDate <= monthstart(max({<Attended? = {"Attended"}>}Date) ),

aggr(rangesum(

above( Count( distinct {<Table = {"SIP"}, Attended? = {"Attended","Booked","In Progress"}>} ENo)

+0*Count(distinct {$+1<MonthYearDate ={">=$(=Min(MonthYearDate ))<=$(=Max(MonthYearDate ))"}>}ENo),

0,rowno())),

MonthYearDate ))

Graph 2:

Can someone help me to amend Expression 2 so that it plots data points for each month, irrespective of whether the cumulative value changes?

Thanks

Sarah

topic line chart and data points plotted using variable date v using max(date) in App Development

line chart and data points plotted using variable date v using max(date)