Looker Calculate Number of Days in a Dashboard Date Filter

I have a dashboard for my team full of graphs/looks that are all controlled by one dashboard date filter. It defaults to 30 days but is changed frequency by the team, usually for 30, 45, 60, 90, 180, and 365 days. This works fine for most of the graphs, but there are two graphs that rank some team products by data aggregated by the date range of those date filters. The most important one is DAU, and Im ordering our products by cumulative DAU (add up all the DAU in the date range of the date filter), but our director wants average DAU as that's more standardized.

How do I count the number of days that the date filter is set to and put that into a column so I can divide the cumulative DAU column by the number of days in date filter column? I do have access to the LookML as a developer user. I do see some similar answers for Look Studio but it doesn't translation well over to Looker LookML solution. Thanks for the help!

2 3 1,235
3 REPLIES 3
Top Labels in this Space
Top Solution Authors