Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Chart 1 is good. Because only 1 expression & expression is very shot , it can plot 2 line. Expression as below :-
Sum(
{<Year={'>$(=year(today())-2)'}>}
sales)
Chart 2 is working fine too , but i like it present like chart 1 format. So that i can easily compare with LY trend. Chart 2 Expression as below :-
sum({<rEVENUE={"rEVENUE"}>}Amount)
My imagine of the final expression ( chart 3 )as below :-
Sum(
{<Year={'>$(=year(today())-2)'}>}
{<rEVENUE={"rEVENUE"}>}Amount
)
How to make chart 3 display format same as chart 1 ? by not display 2014 line ? ( Take note that Chart 1 only display 2015 and 2016 line )
Paul
Are you looking for this?
Are you looking for this?
Hi Sunny
Thank you finally my chart now look perfect.
Paul
Hi Sunny
Can you sharing with me , why after you remove the below , the chart look fine ?
,>}{<
Paul
Remove? What did I remove?
Hi Sunny
My Org imagine code not working :-
Sum(
{<Year={'>$(=year(today())-2)'}>}
{<rEVENUE={"rEVENUE"}>}Amount
)
why your code is working :-
Sum(
{<Year={'>$(=year(today())-2)'}, rEVENUE={'rEVENUE'}>}Amount
)
Because you remove below away , and it work.
,>}{<
I like to know why ?
Paul
Because the one you used was incorrect syntax for set analysis. Set Analysis conditions are separated by comma -> {<Field1 = {'SomeValue'}, Field2 = {'AnotherValue'}>}
Hi Sunny
Thank you very much for your explanation.
Paul