Forum Discussion
Weekly Comparison vs Previous Year into KPI Visual
What do you mean by fictitious results? Are they higher or lower than you expect? Are you using the built in KPI visual or something else?
So in brief, figures for Week 18 and Week 19 are out.
Week 18 is -£40k Approx, and Week 19 is +£427K out from where they should be, however every other value matches up to what I am expecting. This is being viewed in a Matrix showing Week of Year and Total Profit by Years 2019 and 2020.
However, when converting the Matrix to a Month View (Month of Year) then the values I would expect to see are generated.
My frustration is coming from the exact sale DateAdd Field and Total Profit Measure, but visualising them into a week format seems to be causing the issue.
Sorry, this isn't as easy as first thought.
Its mainly frustrating as I can't even visualise this as a Matrix, as the values are incorrect. Any help would be appreciated!