Hi Navneet,
I would suggest you to do following things for getting the count and sure your performance will be much much better.
assume following is your code.
load Field From XYZ;
you are using the count(Field) in your chart. But try below to overcome the problem.
Load Field,'1' as Flag From XYZ;
now use the below expression.
sum(Flag) to get the count.
Hope the idea is clear.
The Count function is resource intensive, where as Sum is not. So whenever you need count of field, use the above logic to improve the performance and reduce the load on chart as well as application.
Regards,
Kaushik Solanki
Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
