Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
could anyone give a suggestion or guidance regarding how could I use expressions in the line chart to change the shape of the line.
I attached the sample data here.
In the data, I want to use the Date as the dimension of the line chart and use adjust1 as the measure.
I set a (vStart) and (vlength) for controlling the start date for how long the function will last.
Sum(
If(Datum.autoCalendar.Date>=Date($(vStart)) and Datum.autoCalendar.Date<Date($(vStart)+$(vLength)),
If($(vCampaign)=1,Baseline, If($(vCampaign)=2,(function(Adjust1))))
)
) *
if i place single Adjust1 here the expression works fine
But I want to able to create some function like. (here the x = Adjust1)
1/(1-e^x), Cube Root of x, or tan(x) (tangent x)
how could i do that? is that possible ?
Thank you!
Yes you could make the expression like this:
So you should be able to embed these expressions directly in your main expression like you have bolded out in your question....
Check these links and use those functions in required areas of your expression:
=pow(1000,1/3)
Check this:
For cube root negative values:
sign(x)*pow(fabs(x),1/3)