Forum Discussion
Y axis aggregation
I can't see your dataset, but maybe your problem is solved when you add another value to 'value'.
It is like when you sell radios and tvs. On the X-axis the amount products sold is displayed and the Y-axis shows the profit. When you only put amount and profit to the scatterplot, you will see one dot and it's the total of all radios and tvs together. If you add product to value then you will see two dots.
Probably you should do something like this with your data.
I can't see your dataset, but maybe your problem is solved when you add another value to 'value'.
It is like when you sell radios and tvs. On the X-axis the amount products sold is displayed and the Y-axis shows the profit. When you only put amount and profit to the scatterplot, you will see one dot and it's the total of all radios and tvs together. If you add product to value then you will see two dots.
Probably you should do something like this with your data.
Thank you, that seemed to have the same effect as the don't summarize.
I simply added the date column to the value field.
Still getting used to bi, came from using excel.