Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to have 2 trellis gauge charts to show last years figures(on the 1 gauge) compared to this years(on the other gauge).
The problem is it shows both gauges but only one gauge has an indicator. Please find my code below:
=Sum({$<Fiscal_Year1={$(=Only(Fiscal_Year1))}>}PO_Spend)/
Sum({$<Fiscal_Year1={$(=Only(Fiscal_Year1))}>}Total_Spend)
=Sum({$<Fiscal_Year1={$(=Only(Fiscal_Year1)-1)}>}PO_Spend)/
Sum({$<Fiscal_Year1={$(=Only(Fiscal_Year1)-1)}>}Total_Spend)
Regards,
Nhlanhla
Nhlanhla,
If you calculate previous to selected period you should use {1} instead of {$} as previous period might be out of current selection. So in your case right expression for second gauge should be:
=Sum({1<Fiscal_Year1={$(=Only(Fiscal_Year1)-1)}>}PO_Spend)/
Sum({1<Fiscal_Year1={$(=Only(Fiscal_Year1)-1)}>}Total_Spend)
Hi Nhlanhla,
if i understand ur problem and if u want to use trellis, u have to use only 1 expression and use "Fiscal_Year1" as trellis dimension.
Look at my example.
C u ,
Stefano.
Nhlanhla,
If you calculate previous to selected period you should use {1} instead of {$} as previous period might be out of current selection. So in your case right expression for second gauge should be:
=Sum({1<Fiscal_Year1={$(=Only(Fiscal_Year1)-1)}>}PO_Spend)/
Sum({1<Fiscal_Year1={$(=Only(Fiscal_Year1)-1)}>}Total_Spend)
Hi,
tray this,
let me know.
Thanks guys it works...Much Appreciated