Help me in displaying latest 10 values in barchart.

[durgabhavani]

Hi All,

Please help me in displaying the latest 10 values in bar chart. please find the sample attachment application and detail description in it

This is higly appreciable. please help me to resolve this.

Thanks,

Durga

[sasikanth]

Please Provide Your Excel File

[settu_periasamy]

Hi,

The same expression working for me. check the attachment.

[durgabhavani]

sasi,

sorry for delay. please find the attachment.

[durgabhavani]

Hi Settu,

sorry i missed you in discussion.

Everything working fine but when i click on stacked bar on barchart, it is showing 'No data to display'.

Can you please look into and help me to resolve this.

thanks,

durga

[settu_periasamy]

How do you want the action, when you click on the stacked bar?

i believe when you click on Stack bar chart, it will select the Particular Date/Week Value. (you can check this in listbox). then the expression won't applied (recent 10 date value)

[durgabhavani]

yes settu, I need to drill down when i click on bar in barchart as well as drill down symbol in chart. Here drill down symbol is working but when i click on bar it is showing no data to display.

My client is looking to drill down to chart as well. can you advice.

thanks for response.

Durga

[settu_periasamy]

Not sure, But, I think, you need to look on 'On Select Field Trigger'.

[PradeepReddy]

see the attachment.. it might be helpful..

[Anonymous]

Hi..

Create a rowno() corresponding to your dimension in the back end and write a calculate dimension with max(rowno()) to max(rowno())-10.

This will work.

HTH

[HirisH_V7]

Hi durga ,

Can you tell your exact requirement is it last 10 months and last 4 weeks .

For your last 10 months you can use this flag in your calendar Like this,

At back end

    If(Date>= AddMonths(Today(), -10), 1)as Last10MonthFlag

At front end

Last10MonthFlag={1}

You can use like this for last 10 months requirement,

&

At back end

    If(Date>= AddMonths(Today(), -1), 1)as LastweekFlag

At front end

LastweekFlag={1}

any way you can use conditional expressions for the Cyclic approach.

Regards,

hirish