Calculate the Average for the indicator as on the pivot with the filter
Learn how to accurately calculate the average value for your indicator widget using the AVG formula. This guide highlights how to achieve consistent results, even when applying filters for Marks. Discover the correct formula— avg([student], [Average mark]) —to ensure you get the expected outcomes, with [student] representing all items and [Average mark] reflecting the average of Mark values. Perfect for data analysts seeking reliable insights!Having difficulty with Dashboard performance
Struggling with slow-loading dashboards? Optimize performance by reducing widget count to 6-8 per dashboard, utilizing plugins like Jump to Dashboard and Switchable Dimensions, and minimizing data load through filters and pre-aggregation. Avoid heavy pivot tables and complex graph functions, and streamline data models by joining on integers and applying data security in a single location. For detailed guidance, check out our performance troubleshooting and optimization resources.
