Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one chart Dollar by Period. I have one Linear also in the chart.Which I have implemented with Trendline section.
But I am not able to enable Legend for those.
I am attaching my sample App.
Could you please help on this.
Thanks,
Sarif
Hi
PFA the app.
Regards
Pratyush !
Hi,
The Legend will be enabled when you have more than one expression or dimension. It will not enabled when you have one dimension and one expression.
Regards,
Kaushik Solanki
OR, You can use expression for 2nd one rather than Enable option called Linear for your 1st expression
linest_m(total aggr(CstFiscalPeriod,CstFiscalPeriod), CstFiscalPeriod)*CstFiscalPeriod + linest_b(total aggr(CstFiscalPeriod,CstFiscalPeriod),CstFiscalPeriod)
Ok..this is new learning for me. Thanks a lot dear.
But How to make Legend for Linear?
I want a legend for Linear like:
Total Dollar (Linear).
Please help on this.
Thanks,
Sarif
You can use the example given by prat1507
Regards,
Kaushik Solanki
Hi Anil,
This is not showing correct result. It is showing a Straight Line on 0 value.
Hi Pratyush,
I got this. But what to do on Liner? I want a Legend on Linear also with Different Color.
Please help.
Thanks,
Sarif
try this expression:
linest_m(total aggr(sum(ActualDollars),CstFiscalPeriod), CstFiscalPeriod)*CstFiscalPeriod + linest_b(total aggr(sum(ActualDollars),CstFiscalPeriod),CstFiscalPeriod)
hope this helps
May be this?
=linest_m(total aggr(sum(ActualDollars),CstFiscalPeriod),CstFiscalPeriod) * CstFiscalPeriod + linest_b(total aggr(sum(ActualDollars),CstFiscalPeriod),CstFiscalPeriod)