Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm struggling to write an expression in a line graph to show the previous week's information. I'd also like a Year to Date average to show as a separate line.
Count({$<(=Week(DateCreated))={$((=Week(DateCreated))-1)>},if(type = 'SHIPMENT',type))
Can someone explain where I am going wrong and the reason for it not working?
Try without =
Count({$<(Week(DateCreated))={$((=Week(DateCreated))-1)>},if(type = 'SHIPMENT',type))
Doesn't make a difference unfortunately - it appears to just be plotting the current week selection and not the week-1
Check out this explanatory post on grabbing prior periods.
the above() function may help you grab previous week data in a chart.
Calculating rolling n-period totals, averages or other aggregations
I also saw what you saw, either.