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!
