-
Hide default "Choose Date" filter in App Studio
I have pages in my App that use individual dates instead of a date range. To work around this, I created a filter where the user can select an individual calendar date. However, since you can't hide/disable the default "Choose Date" filter, users are confused on which filter to use.
-
Filter Views for Mobile App Studio
Filter views do not exist for mobile as they do for desktop. When using their phone or tablet, my users will reach out thinking the data is wrong or the app is broken because it doesn't look like the desktop version. They then manually add filters individually, which is challenging for our non-technical user base. In our…
-
Average Count Distinct across Date Range
I am working on Turnover metrics and need to capture the average unique headcount of employees over a user selected date range. Here is what I've tried, but Domo keeps giving errors: COUNT_DISTINCT(CASE WHEN (Team Member status = 'Active' OR Team Member status = 'Unpaid Leave') AND Date BETWEEN 'start_date' AND 'end_date'…
-
Turnover Beast Mode: Avg Distinct Count / Days in date range
I am attempting to create a Turnover Rate beast mode that would take the Average Distinct Count of employee IDs, then divide it by the number of days in the user selected date range. I've tried the following syntax, but I receive an error: Raw syntax: AVG(COUNT(DISTINCT CASE WHEN Team Member status = 'Active' OR Team…
