Is there a way to create a calculated field in a dashboard from the data that has been put into it?
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.
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!
