Hey there,
I have a published dashboard in analytics that I share with my teammates to plan production of a product.
In there is a chart with a weekly overview of planned production and deliveries that we use to check if we have to make changes. Below the chart my teammates can make entries into a embedded Zoho Creator form to enter new production data and new deliveries. From Zoho Creator the data is populated into a Zoho Analytics table via a deluge script from a workflow.
Our problem is: it takes ages to see the entered information appear in the chart.
To see where the performance problems appear I checked each information-processing step:
- It takes millisecond to get the information from Creator into the Analytics Table and the following Query-Table
- it takes seconds to see the change in the chart
- it takes a few seconds more to see the changes in the dashboard where the chart is embedded
- it takes several minutes (sometimes 5, sometimes 20 or more) to see the changes in the published report
This is quite annoying, as we always have to wait to see if our entries were entered correctly and if we need to adjust our production plan because of the new information.
Is there anything I can do to speed things up? Or should I use other tools to build my production-planning dashboard?
Thanks in advance!