Here I am facing problem with heavy transactional data. Here we planned to reduce the file size/ increase the performance of app by moving potential calculations from UI level to script level. Can anyone suggest/ help me to move the potential aggregations to the script level, basically i am having a trouble to identify/ implement them.
Please find the attached work file for script/ object expression reference.
Firstly, you need to identify fact tables and apply the aggregation on time dimension. For example if you have the fact table transactions on low data granular level (transaction time), then you can aggregate transactions to date , week or month level to reduce the fact rows size. Along the aggregation you can add some flags to enhance the UI expressions.
Thanks for the reply, the complex expressions which are present in Charts are (Unit, Sales, Transactions, Units per transactions, Units per 1000, Avg check), All expressions are being calculated with transaction data from GuestCheckList table. Here the above mentioned expressions need to move to back end, by aggregating at site ID level . So that chat calculation time will be reduced.