user03841 Member

The users may want to query on multiple start and stop dates in a session. Do you mean DOMO Card user or Employees that are contained in the dataset?

The time period would be whatever the user inputs in the Date Range Between Start Date and End Date fields on the DOMO card (e.g. 10/6/2016 - 11/18/2016; 08/08/2017 - 3/5/2018; 12/10/2017 - 12/20/2017) . It wouldn't be limited to a current or previous week, month, quarter or year. 

How would you create a dataflow to identify employees who were active in a previous time period, where the time period is input by the DOMO card User? This could include employees who are currently active.

Do you identify an employee as Active or Inactive if the start and stop dates can change? In other words, how do you identify the Date Range field Start Date and Stop Date in the dataflow?

We are not applying a date grain to the card since users of this card may wish to enter any start date and stop date. 

Thanks for the reply. I was looking to not hardcode the date selection since others will be using this card for multiple date ranges.

When I tried to use the beast mode you suggested with MAX and MIN in a filter, DOMO would not allow it to be used as a filter. The message was: "Aggregations are not supported in filters." Using HireDate as the Date range field, and '2017-08-01' through '2017-10-15' as the date filter range, would a DOMO card pick up an…

Yes I could aggregate the data. My biggest challenge is determining which employees are active during a selection period (i.e. start and stop dates) that can vary according to input that the card user selects (via DOMO Date Range Between fields).

I would like to create a dataflow that would determine if an employee is active based on start and stop dates that can change. For example, it should be able to count the number of employees active between '01/12/2014' and '03/15/2016' as well as between '4/6/2017' and '7/7/2017'.

We already have a flag for employees who are currently active: it checks if the termdate is active. How would you create a dataflow that would accept selection stop dates and start dates from a DOMO card to compare that with both the Hire dates and End dates? I can create the SQL statement to compare the hire and term…

@PodiumMason : If I select on HireDate, only Employees hired during that time are selected. If TermDate is used, then employees terminated during that date range will be selected. The users of this card will probably try different combinations of start and stop dates so the calculation of active employees needs to be…

I am using hiredate in the date range grain field and am still having trouble with using the beast mode calculation in the filter. If I use hiredate in the date range grain field, only employees hired during that range will be selected. I am looking for all Active employees during that time. If I select Oct 13, 2017 as the…

Domo reports that "Aggregations are not supported in filters."

The dataset contains two date fields: HireDate and TermDate. I created a beast mode calculation against the Hiredate field and tried to filter on this field but DOMO won't allow it. Says "An Issue has occurred during processing. We are unable to comlete the request at this time."

I can't hardcode the start date and end date values since the dates will vary. I am creating the card for individuals who will not have the knowledge of editing DOMO cards.

I will not know ahead of time what the selection begin date and end date will be. I am looking at a range of dates (from start date to end date). I would like to use the DOMO "Between" start and stop dates. Is there a way to do this? What is the `your_date_field` for the DOMO Between 'Start Date' and 'End Date' fields?