Line Chart issue

[amayuresh]

Hi Team,

I am having Trend Line chart showing Month on axis and Number on Y-axis with below details,

Dimensions:

Month, Calculated dimension

Calculated dimension in uses RANK and AGGR function

This is used to filter out top X Supplier names from table on the basis of variance of last year and Current year Spend

Expression: Current Year Spend

Sort Calculated Dimension on variance by Descending order

This is taking time to refresh the chart, is there any alternative to show the same result.

Like using dimension limit, which works faster than this.

[sunny_talwar]

May be, but just by description itself it would be hard to suggest anything. Is it possible to share a sample?

[Chanty4u]

u can create a flags for years in backend and use those flags in chart.

[#4]

Calculated dimension with Aggr and Rank takes time based on the volume of the records.

What is the volume of records you have? Else use the order by and recno() function in script to calculate the ranking,

[amayuresh]

Sure. Let me post sample document.

[sunny_talwar]

Thank you. that would be very helpful.

Best,

Sunny