Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be, but just by description itself it would be hard to suggest anything. Is it possible to share a sample?
u can create a flags for years in backend and use those flags in chart.
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,
Sure. Let me post sample document.
Thank you. that would be very helpful.
Best,
Sunny