Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have 3 different measures representing my data and I am looking am looking for an expression to add different colors to my bar chart through an expression. Any help would be appreciated.
I have sales data from 2015-2018 and wanted to add growth rates over the years as a KPI. How can this be achieved through an expression? Please advice.
Regards,
Rony
hi
if you find the solution then close the thread .
As a Measure (format it as %)
(sum({<Year={"$(=max(Year))"}>}YourMeasure)
-
sum({<Year={"$(=max(Year)-1)"}>}YourMeasure))
/
sum({<Year={"$(=max(Year)-1)"}>}YourMeasure)
As a label:
='Growth from '&(max(Year)-1)&' to '&(max(Year))
With that when you select 2017 for example; u'll have the growth from 2016 to 2017 and so on.
Omar,
Will the above formula work only for 2 years or more? I have data from 2015-2018.
Regards,
Rony
What do u mean?
In ur KPI object, what do you want to have?
Exactly?
I want the kpi to show growth rate for 2016 over 2015, 2017 over 2016, 2018 over 2017 as and when the selections are applied.
this is 3 separate measures; u can't have all 3 of them in the KPI object.
Instead;
use a bar/line/combined chart; as a dimension: Year
as a measure;the measure I've already given you.
try it and see what happens
OKay. Thanks Omar.
Hi Omar,
Which one should I be taking here?
Rony
u're talking of this?
(sum({<Year={"$(=max(Year))"}>}YourMeasure)
-
sum({<Year={"$(=max(Year)-1)"}>}YourMeasure))
/
sum({<Year={"$(=max(Year)-1)"}>}YourMeasure)
As a label:
='Growth from '&(max(Year)-1)&' to '&(max(Year))