Forum Discussion
4 week average calculation having missing values on bar chart because of lack of events in 1 week
This may be a confusing issue seeing it's quite specific so apologies in advance. I have a calculation that tracks the 4 week average of an event's occurance, grouped by weeks. This event only oc...
This option doesn't change anything, and if I use the "+0" trick (return (_EventsInSpan/_Duration)+0) at the end of the calculation we can see that the calculation is returning blanks when it shouldn't:
The 4 week average for week 5 is (1+3+1+0)/4 = 1.25 for the values of week 2, 3, 4, 5 respectively. However because week 5 had 0 incidents the calculation is returning a blank.
I'm suspicious that the issue is the date logic (aka the weeks being recorded in _CalculationPeriod) is being filtered by the location slicer as there are no values connect these 3: site -> data -> date. If I figure out the issue I'll reply to this and mark my method as a solution but otherwise I would appreciate any help.