Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm creating a scatter plot where on the Y axis I have 'transfer value (£)' and on X I have the 'start date'. I want to limit the dimension where the transfer value '>0' (nice and easy). However, when I go to limit the dimension it says 'Calculated on Dimension: Start Date' and I have no option to change it to use the other measure.
If I swap the measures around, I can limit it by the transfer value but it makes the graph confusing to read.
My question is, can I put a limit on the transfer value while keeping it on the Y axis?
Change YourSecondMeasure:
from:
sum(YourSecondMeasure)
to:
if(sum(YourSecondMeasure)>0,sum(YourSecondMeasure))
Change YourSecondMeasure:
from:
sum(YourSecondMeasure)
to:
if(sum(YourSecondMeasure)>0,sum(YourSecondMeasure))
Always helps to have a fresh pair of eyes look at something! Thank you so much!