topic Re: flexible Calculated field in Dashboard changing with filters used in Warehousing & Analytics

flexible Calculated field in Dashboard changing with filters used

a_d — Tue, 03 Mar 2026 15:13:41 GMT

Hi guys,

I am making a Dashboard where I want to show the AOV per Brand with a date filter to change the days used in the calculation.

AOV = sales / orders

I have sales and orders per day and would like to have the AOV dependant on the Days selected.

The only way I found to display the AOV is to calculate it per day and then put an avg() over it in the widget, but this doesn´t show the the true number (avg of avg). Ideally it would be sth similar to what you can do in excel with pivot calulated fields.

I am using sql

Re: flexible Calculated field in Dashboard changing with filters used

Ashwin_DSA — Wed, 04 Mar 2026 09:03:41 GMT

Hi @a_d,

Could you please confirm that you are referring to dashboards in Databricks and not another reporting tool?

And, when you mention a flexible calculated field, do you mean a Custom Calculation? If not, have you considered using a custom calculated measure?

If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.

Regards,

Re: flexible Calculated field in Dashboard changing with filters used

a_d — Wed, 04 Mar 2026 11:54:19 GMT

Hi @Ashwin_DSA ,

yes I´m referring to Dashboards in Databricks.

Can you explain how I could create a calculated measure? I think this would solve my problem.

I want the user to be able to change the daterange on the datepicker and then the AOV would be calculated based on the sales for the dates filtered.

Re: flexible Calculated field in Dashboard changing with filters used

Ashwin_DSA — Wed, 04 Mar 2026 12:51:38 GMT

Hi @a_d - Thanks for confirming.

Here is a good example.

I've also tested it and given some snapshots below if it helps. My data looks something like the below.

You can see above the results (on the right side) an option to create a custom calculation. In the editor, add the formula. SUM(sales) / SUM(orders)

You can then build the visualisation and choose the custom measure you have created.

Hope that helps!

If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.

Re: flexible Calculated field in Dashboard changing with filters used

a_d — Wed, 04 Mar 2026 13:52:12 GMT

Hi @Ashwin_DSA ,

thank you so much, that´s excactly what I wanted 🙂