Displaying only last three period's trend in a minichart

[#1]

Hi,

Can anyone let me know how i can restict the period display to last three perid(Q7,Q6,Q5) in the minichart of my application.

PFA

[Gysbert_Wassenaar]

Change the expression to Sum({<Qtr={'Q7','Q6','Q5'}>}Amt).

If you want to be able to make a selection in the Qtr field and show the last three quarters of that selection then you'll have to create a numeric quarters field. You can then use something like Sum({<QtrNo={'>=$(=max(QtrNo)-2)'}>}Amt).

[#3]

Hi,

If you always want to display these specific quarters then you can hard code them in your set analysis:

sum(${<Qtr = {'Q5', 'Q6', 'Q7'}>} amt)

If you want to display the last three quarters based on your selections, you can assign a number field for the quarters, QtrNum, where it would be 1 when Qtr is Q1, etc...

Your minichart expression would look like this:

sum ({$<QtrNum = {">=$(=Max(QtrNum)-2) <=$(=Max(QtrNum))"}>} Amt)

Hope this helps you.

[#4]

Incase I have to display the last six months (text field)in the trend how can I achieve it

Thanks & Regards,

Anushree Shetty

[jagan]

Hi,

If you have a datefield in your datamodel then use below expression

=Sum({<DateFieldName={'>=$(=MonthStart(max(DateFieldName)-5))<=$(=Max(DateFieldName))'}>}Amt)

If above expression not works then check the formats of DateFieldName and Today() are same.

Hope this helps you.

Regards,

Jagan.