Forum Discussion
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 gone wrong and why is it showing the total amount billed year to date instead of just the month of October?
Thank you in advance!
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
5 Replies
Good morning!
Having had some time away, I have looked with fresh eyes and it was as simple as your first option.
Thank you
Thank you for taking the time to reply.
Nett Sale is just on the Y axis, I was adding and removing it when taking the screen shot.
X = Date, Y = Nett Sale
The Collection & table is related to the Invoiced Jobs table correctly with the same reference.
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
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 🙂
