https://community.databricks.com/t5/warehousing-analytics/calculated-field-in-dashboards/m-p/48041#M997 <P>Is there a way to create a calculated field in a dashboard from the data that has been put into it?</P><P>I have an aggregated dataset that goes into a dashboard, but using an average in the calculation will only work if I display the average by the grouped variables. e.g. Avg(Thing), grouped by X,Y will only be useful if I display it by X and Y at the same time.</P><P>If instead of average, I could use count() and sum() that could be used to calculate an average field in the dashboard, then I could use any filters on that dashboard and still get correct results. Is there an easy way to do this? And if not, how do I go about doing a feature request!</P> Wed, 04 Oct 2023 10:18:34 GMT SimonMcCor 2023-10-04T10:18:34Z https://community.databricks.com/t5/warehousing-analytics/calculated-field-in-dashboards/m-p/48041#M997 <P>Is there a way to create a calculated field in a dashboard from the data that has been put into it?</P><P>I have an aggregated dataset that goes into a dashboard, but using an average in the calculation will only work if I display the average by the grouped variables. e.g. Avg(Thing), grouped by X,Y will only be useful if I display it by X and Y at the same time.</P><P>If instead of average, I could use count() and sum() that could be used to calculate an average field in the dashboard, then I could use any filters on that dashboard and still get correct results. Is there an easy way to do this? And if not, how do I go about doing a feature request!</P> Wed, 04 Oct 2023 10:18:34 GMT https://community.databricks.com/t5/warehousing-analytics/calculated-field-in-dashboards/m-p/48041#M997 SimonMcCor 2023-10-04T10:18:34Z https://community.databricks.com/t5/warehousing-analytics/calculated-field-in-dashboards/m-p/48345#M1002 <P>Hi Kaniz,<BR />For SQL dashboards how would you approach this? Given the example above every 'new calculation' added would require computation across the dataset again which re-runs the query (which can take a few minutes for some of the datasets we have). Is there a better approach than this?&nbsp;</P> Thu, 05 Oct 2023 10:07:40 GMT https://community.databricks.com/t5/warehousing-analytics/calculated-field-in-dashboards/m-p/48345#M1002 117074 2023-10-05T10:07:40Z