Forum Discussion
Data visualisation issue
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 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 🙂