Variable Dates (User Defined) and Status Determination
Hoping to find a solution to an issue I am trying to solve.
I have a series of time entry compliance dashboards. Data is pulled into Domo via the timesheet app connector.
My dashboards highlight compliance, based on 7 hours a work day, categorizing into "Full" or "Partial" or "Zero"
The solution I have works great currently, where we are only looking at the current month.
I create a new data set, and use a Group By. I create the following new fields:
CASE WHEN ifnull((SUM(`timeSpentSeconds`)/3600),0) = 0 THEN 'Zero' WHEN ifnull((SUM(`timeSpentSeconds`)/3600),0) < (DATE_WORKING_DIFF(TODAY()-1,(today()-DAYOFMONTH(today())))*7) THEN 'Partial' ELSE 'Full' END
As our dashboards are getting more and more use, we want to enhance them.
We want to add the ability to select date ranges. Weekly, monthly, quarterly, custom.
I have those filters fine, but I want to know how to achieve the Zero/Partial/Full based on the dates the user selects on the dashboard. Right now, it's built into the table.
Here is some example data to make it easier. The reason is that there could be several rows for the same person for the same day (if they are working multiple projects).
The data on the left is what my data looks like. The data on the right is how it looks in my current process, but having user adjustable dates removes the ability for there to be a separate grouping table.
Any thoughts? I tried searching, but didn't see anything out there. Could be that I just don't know how to phrase it all.
Thanks in advance.
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board