Hi experts, I'm trying to create a toggle that allows users to view Month to Date or Year to Date data. Current state is a bar graph with years represented by different bars - 2025, 2024, and 2023. Ea…
Hi there, I have created 5 calculated columns in DOMO analyser that get me the max date in each of the fields (Let's call them- Reconsideration date, Complied Date, Status last updated date, Appeal da…
Hi everyone, I’m trying to implement a date range in Domo (using `Reservation Start Date`) that includes both Today AND the Last 7 Days at the same time. This will be for a weekly scheduled send. I kn…
Hi, I have an App Studio app that I would like to add a quick future date filter to. This is similar to the presets in the Date Slicer Filter, but I want to allow users to select Week to Go, Month to …
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/d…
I have a situation where I am trying to show how the Headcount moved by comparing Current Month Headcount with any of the historical Month which the user will select. The problem that I am facing is t…
I’m trying to create a row which shows the “Prior Year” value against a field for comparison, simply a 12 month offset of the data as shown below with the "Value" field. This would later enable me to …
As you know Domo has a selection Date Range, Period to Date, and if I click on Week to Date, my 3 cards will update the date dimension to current Week to Date, Month to Date, and Quarter to Date. I'm …
The card pictured below is filtered to 2025 - however, Domo's default week starts the prior Sunday which still lands in the month of December. I would like it to show a January date instead for the fi…
Hello Everyone, I have been breaking my head over last 2 weeks looking for a probable solution to a scenario that I have. I tried ChatGPT as well but nothing worked. So, I have a Headcount App where I…
The dynamic date and time functions—such as CURRENT_DATE() and NOW()—are represented in UTC, regardless of the Company Time Zone in your Admin Settings. This creates a problem during the hours of the …
I am using the Domo Five9 connector to pull a report containing list data into Domo and am encountering challenges relating to datetime fields. The two fields I am having issues with are: Timestamp - …
Idea: Allow either the 'between' date range filter for charts to also allow selection of 'X months ago' to '2 months ago' (see second screenshot for current version), or have the 'Last' filter allow a…
we have seen an issue when we created date filters, Date calendar is not cooperating. The expectation is that when a stakeholder select the fiscal year and month the calendar date is showing the chase…
I can't seem to find a clear answer as to what is happening here, so I'm turning to the community. I have a dataset with a timestamp field, createdAt The dataset arrives to Domo in UTC, and my company…
Hey Domo Dojo Community, I'm working with a dataset containing reservation start (RSD) and end (RED) dates in the format of MM/DD/YYYY. I need to identify all records where the reservation spans acros…
I am trying to write a beast mode that given a date can tell me the number of business days there are in that month. My company's hours are a little different so I want it to count days according to t…
I read the article linked above… Is there a way to do this sort of thing at the card level? The Fill Missing Dates option is not working. I'm having an issue with it dropping dates that have no corres…
I have a Bar Chart with the last FY worth of data up to 30 June 2021. I'd like the chart to show the last 12 months of data, however, it is only showing the last 11. There is no data in July 2020, whi…
I know I can do a max (`datefield`) over () in a beastmode, but this only works for card level filtering and not page level filtering due to the fact that this is an aggregation beast mode. For the pa…
Hi, I have a filter card (dropdown selector) to display all dates available and I would like to have pre-selected the latest date. Is this possible? Right now I added it by manually typing the latest …
When charting by week it would be nice to have the following additional options: Ability to choose the method that determines 'Week 1'. For example, is it the first Monday of the year? The first Tuesd…
Does anyone know if there's a way to set the date range filter to exclude the last 45 days but still give YTD numbers? For example, today is 8/19/2024 and the last 45 days is irrelevant to a certain s…
I have the following Beast Mode working for a comparison table (Period over Period is the name of the variable: CASE WHEN Period Over Period = 'Week over Week' THEN (CASE WHEN WEEK(Date) = WEEK(CURDAT…
Hi All, I want to create a column for YTD, YOY comparison by month and M-1. Example output is below: I have datetime in a format at yyyy-mm-dd Can someone show a use case for this?
Hi I want to create a table where user can select the date comparisons between two periods. Just want them to pick the date comparison and the data reflect in the tables accordingly. And how to create…
I'm working with a dataset that contains daily level data, including a date column. I've created a calculated field based on this date column. However, when I try to aggregate the data by 'week' using…
I have the multi-value PoP gauge on my dashboard showing a comparison to the previous year. The default date period is set to previous month. But, altering the global date on the dashboard removes the…
I have two data sets one with employee pay information that is bi-weekly. And one that has information about the employee's work services they provided The one with employee work data has dates that s…
