I'm trying to create a bubble chart with
x-axis --> payment term
y-axis --> Discount
Bubble size (number of suppliers)
So far so good.
hoever the payment term for instance 17 days does nog exists it jumps from 14 to 21 without anything in between on the x-axis.
Same for discount. I do no have all the variants in my dataset so it jumps from available value to available value.
I think I would have to create an extra dimension with the values in there or something
Appreciate the help,
It sounds as if you're using a grid chart, when you probably should use a scatter chart. In a scatter chart, two expressions are used as graphical dimensions. See Recipe for a Scatter Chart
thanks for trying to help me out.
the thing with the scatter is that I have no need for a dimension and I have to fill one out
I just want to know how many supplier have which combinations of factors, all these three are expressions in the scatter, I do not understand what to plot as the dimension
For scatter chart, the dimension is what separates the datapoints from each other. Because the axes are expressions, it's possible - theoretically and quite often in practice - to have two datapoints exactly on top of each other.
In your case it's of course not possible because what specifies your datapoint is the same thing you have in expressions - payment term & discount. So I'd try to use exactly that as the dimension, try using a calculated dimension to see if it works at all.
another solution could be to calculate an ID in the script like:
LOAD [payment term],
AutonumberHash128([payment term], Discount) as PaymTermDiscID,
and to use this PaymTermDiscID as dimension.
hope this helps