Forum Discussion

JoWingsGSE's avatar
JoWingsGSE
Frequent Visitor
2 years ago
Solved

Data visualisation issue

Hi again,   I think I may have been spending too long staring at the same thing.  Per the attached, I have set the data to show October 2023, however the figure shown is YTD figures. Where have I g...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I think there can only be a few possible explanations:

    1. It actually shows you the correct sum and you confuse it with showing the sum of the year since the x-axis tells you so (you have to go down 1 step in the hierachy for the x-axis to show you the month as well)

    2. Relation between the collection.. table & Invoiced_Jobs.. table is not proper

    3. Not sure but if "Nett Sales" is actually some weird measure e.g. incl. ALL() function there might be your issue as well

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I think there can only be a few possible explanations:

1. It actually shows you the correct sum and you confuse it with showing the sum of the year since the x-axis tells you so (you have to go down 1 step in the hierachy for the x-axis to show you the month as well)

2. Relation between the collection.. table & Invoiced_Jobs.. table is not proper

3. Not sure but if "Nett Sales" is actually some weird measure e.g. incl. ALL() function there might be your issue as well

JoWingsGSE's avatar
JoWingsGSE
Frequent Visitor
2 years ago

Thank you - I shall do some digging as a similar data set worked perfectly last week - I have working on this data set for hours today so might need a break and to come back to it with fresh eyes.  I will update once I have gone through your suggestions 🙂