Forum Discussion

TomBurke's avatar
TomBurke
Regular Visitor
6 years ago

Weekly Comparison vs Previous Year into KPI Visual

Hello there community,   I'm here today seeking your help with time inteligence and creating a KPI Visual with the results. Currently, I have two KPI's, one for Monthly Profit MTD and Weekly Profi...
Need Help
TomBurke's avatar
TomBurke
Regular Visitor
6 years ago

Hi Allison,

 

Thanks very much for your reply.

I had previosuly tried all 3 versions, but I went back and it seems that DATEADD works fine.
However, I am getting fictisious results for Week 18 & 19.
(Unable to post images due to Data Protection).

 

I have been trouble-shooting in my data and have explored it in Excel and the figures shown using DateAdd are incorrect.

Is there anything you can suggest that might cause an issue with 2 of 19 results?
Seems very strange.


Many thanks,

 

 

 

AllisonKennedy's avatar
AllisonKennedy
Community Champion
6 years ago

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?

  • TomBurke's avatar
    TomBurke
    Regular Visitor
    6 years ago

    AllisonKennedy ,

     

    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!