Working with Dashboard-selected date range

Get Help
1

I have a SQL table giving quantity on hand and inventory value by day. Over time this will grow to a fair number of records. A dashboard allows a user to select a date range. Is it possible to derive the number of days in the range the user selected, then use that number to divide by, so as to get the average quantity on hand and inventory value based on the time selected? Metabase 0.45.3.

Thanks!

2

You can have 2 filters, a date start and a date end. Then build a sql query that does a datediff and then calculate the metric you need in sql.