Legend is Not Visible

[mhmmd_srf]

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

[prat1507]

Hi

PFA the app.

Regards
Pratyush !

[kaushiknsolanki]

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

[Anil_Babu_Samineni]

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)

[mhmmd_srf]

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

[kaushiknsolanki]

You can use the example given by prat1507‌

Regards,

Kaushik Solanki

[mhmmd_srf]

Hi Anil,

This is not showing correct result. It is showing a Straight Line on 0 value.

[mhmmd_srf]

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

[Frank_Hartmann]

try this expression:

linest_m(total aggr(sum(ActualDollars),CstFiscalPeriod), CstFiscalPeriod)*CstFiscalPeriod + linest_b(total aggr(sum(ActualDollars),CstFiscalPeriod),CstFiscalPeriod)

hope this helps

[Anil_Babu_Samineni]

May be this?

=linest_m(total aggr(sum(ActualDollars),CstFiscalPeriod),CstFiscalPeriod) * CstFiscalPeriod + linest_b(total aggr(sum(ActualDollars),CstFiscalPeriod),CstFiscalPeriod)