Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have chart displays last 8 quarters data. It works well with single quarter selection but when we select more than one quarter it displays as "No data to Display" in chart.
The requirement is to display last 8 quarter based on maximum value from multiple selections of quarter.
Formula in Chart expression:
Sum({<Year=,Quarter=,Month=, Week=,DateType={'Transaction'}, CanonicalDate={">=$(=QuarterStart($(vQtr),-8))<=$(=QuarterEnd($(vQtr)))"}>}NumberofPolicies)
Where vQtr -
If(QuarterNo=1,makedate(Year),If(QuarterNo=2,makedate(Year,04),If(QuarterNo=3,makedate(Year,07),If(QuarterNo=4,makedate(Year,10)))))
Please suggest me how to get the maximum quarter based on multiple value selection.
Regards
Neha
You will have to modify your variable value.
Try below.
If(Max(QuarterNo)=1,makedate(Year),If(Max(QuarterNo)=2,makedate(Year,04),If(Max(QuarterNo)=3,makedate(Year,07),If(Max(QuarterNo)=4,makedate(Year,10)))))
Regards,
Kaushik Solanki
You will have to modify your variable value.
Try below.
If(Max(QuarterNo)=1,makedate(Year),If(Max(QuarterNo)=2,makedate(Year,04),If(Max(QuarterNo)=3,makedate(Year,07),If(Max(QuarterNo)=4,makedate(Year,10)))))
Regards,
Kaushik Solanki
Or try this
vQtr = MakeDate(Year, (3*Max(QuarterNo))-2)
Thanks Kaushik, It worked, I didnt knew it was so simple