how to restrict to show only 3 Quarters on chart

[NavinReddy]

Hello All,

On based on Current selection i want to display data on bar chart 3 quarters,

i have tried i am not able to resolve the issue .

Please help me, i have attached the sample data.

Thanks in Advance

Niranjan

[andrey_krylov]

If 3 last quarters try this

[NavinReddy]

Hi Andrey,

But on expression its not working for me, i can see 96 open issues but im getting current Quarter total 1 count.

please suggest me if any changes on expression.

Thanks in Advance

Niranjan

[andrey_krylov · Accepted solution]

Maybe this

[NavinReddy]

Thank you very much for your help

Could please help me with logic

[andrey_krylov]

Hi Niranjan. I've slightly corrected  the variables

vLast3Qarter        =QuarterStart(Max(Date), -2)

vYourMaxDate     =Max(Date)

If you need 3 last quarters relative to today then change Max(Date) with Today()