flexible Calculated field in Dashboard changing with filters used

[a_d]

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

[Ashwin_DSA]

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,

[a_d]

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.

[Ashwin_DSA · Accepted solution]

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.

[a_d]

Hi @Ashwin_DSA ,

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