Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart which dynamically should update based on the dimension chosen.
I have filter drop down which dynamically changes the dimension on the bar chart ( By Product, By Country, By Customer). I am using pick function : =Pick (DNO, Product, Country , Name) .
It changes the chart dimensions but the performance is super slow. It takes a minute to render the chart. For users, this is too slow. How can I fix this? Please suggest.
Thanks
Prashant
You could try @Kushal_Chawda suggestion, but I suspect that the slow rendering is not caused by your pick - match function. I suspect your slow rendering is caused by a large data set and many rows to calculate before presenting the new table.
If so, then you should focus oncoptimzing your expression /data model or increase your system resources in order to speed up your table rendering.
Good luck solving your issue.
@PrashantRupani why don't you just add single dimension and rest of the dimension as alternative dimension instead of pick match?
You could try @Kushal_Chawda suggestion, but I suspect that the slow rendering is not caused by your pick - match function. I suspect your slow rendering is caused by a large data set and many rows to calculate before presenting the new table.
If so, then you should focus oncoptimzing your expression /data model or increase your system resources in order to speed up your table rendering.
Good luck solving your issue.
You are right @Vegar . It was due to large data set. We ended up using Master chart Items and a filter to display those conditionally. Thanks for the suggestion.
Oh that was a good solution. I tried it. But the performance was slow.
It was due to large data set. We ended up using Master chart Items and a filter to display those conditionally. Thanks for the suggestion.