Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Line chart, trying to add two measures, 1 measure works perfect on its own, but if I try to add two of them together, I'm not getting all the fields from the Dimension that I'm using.
This is the 1st measure
avg(cost)/avg(weight)
This is 2nd measure
avg(cost_new)/avg(weight_new)
They work alone, but when I do this
avg(cost)/avg(weight) + avg(cost_new)/avg(weight_new)
I'm only getting the Dimension fields from one of the measure, not both.
I hope someone can resolve this.
Thanks
Could it be that one of the sides of the is trying to divide by zero and causing a null which then knocks out the other side of the expression?
try this - rangesum(avg(cost)/avg(weight),avg(cost_new)/avg(weight_new))?
HI @D19PAL
Try like below
(avg(cost)/avg(weight)) + (avg(cost_new)/avg(weight_new))
if not, can you give sample file
Thanks
But I tried that too, doesn't work
Anyone? please lol
Could it be that one of the sides of the is trying to divide by zero and causing a null which then knocks out the other side of the expression?
try this - rangesum(avg(cost)/avg(weight),avg(cost_new)/avg(weight_new))?
Worked a treat.
Thanks