Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have a problem with missing dates in a line chart because no results are matches with them.
Say I have an athlete, but he only has dates linked to him when he has had a result on that date (persons were joined to dates via results, so no result for an athlete on a specific date means that athlete has no record for that date either). So when you make a line chart of his performance the x-axis is missing a lot of dates there (I know you can show them with the continous axis option, but the athlete still has no record for those dates). So f.e. the accumulate option in the expressions tab works incorrectly as well.
F.e. if I want YearMonth on the x-axis, and accumulate over the past year, it will accumulate over the past 12 months where the athlete has results, while it should also take account of months where the athlete has no results.
Is there any way of taking account of the missing dates without having to join person on dates? (that would be waaay too large).
You would need a Master Calendar. There are a lot of resources on the Community forum that contain the script to create one.