user02830

Discussions

Creating custom date ranges for display
I would like to display my cards with a custom date range that doesn't exist. I need financial year to date for Australia. Our financial year runs from 1 July to 30 June and so all our clients here would like their data displayed that way. How can I do this? There isn't an option in the date range field to do this. Domo…
CURRENT DATE Issue
I have an issue with the CURDATE() function. I have the following beast mode: CASE WHEN `Closing Date` < CURDATE() THEN 'Past' ELSE 'Current' END I use this beast mode to not sure the incomplete data from the current day (so I filter on Current). However, the data for the previous day doesn't update until 11am. Our…