Date

Hi, I am working with a Pivot Table card. The underlying dataset contains records through August 4, 2026, However, when the card date range is set to All Time, the date selector displays: Jul 31, 2024 - Aug 3, 2026 I expected the All Time range to end on August 4, 2026, since records exist for that date. I have confirmed…

Hi all, I’m building a Domo table (company-level) with YTD + MoM + YoY, where MoM/YoY must dynamically adjust to the user-selected date range. Expected logic: Jan–Mar → MoM = Mar vs Feb Jan–Apr → MoM = Apr vs Mar YoY = latest selected month vs same month last year Setup: Grain: company + month Visual: company-level…

A recent question posted hours clocked using a bar chart. Just as I was reading their question, I had a similar need. I thought possibly others might benefit from the way I choose to handle this. We were counting hours a doctor was working vs hours the staff was working to identify whether we had areas over staffed. In…

I have a YTD Performance card that includes the following metrics: Actual Budget Projected EOY Accruals Variance (Actual vs. Budget) On the dashboard, there is a Month slicer that allows users to select values such as Jan 2026, Dec 2025, Nov 2025, Jun 2025, etc. Requirement The requirement is to display Year-to-Date (YTD)…

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 day when the UTC date and your company time zone's dates are unaligned. For instance, say you have a Beast Mode that uses…

Hi, I have a dashboard that uses the calendar date selector filter. When I select dates, my data does not get filtered. The selection does not even appear in the filter bar at the top of the page. I noticed that editing a dashboard looks a bit different, almost like editing an App, and the card titles have a new font. Did…

When you first create a new card a seemingly random date field is chosen by the card's date selector. At our company it chooses a deprecated field that was populated years ago but is no longer populated. This means that whenever someone applies a date filter such as 'This year' the card shows no data. I am constantly…

hi All, Want to use the following: CASE WHEN 'Next Cycle Count:' (basically this is a date coming up in the next few months) only want to show the items that appear for next 30 days only

Requesting CURRENT_DATE function in beastmode to be reflective of our company time zone instead of UTC. At 6pm daily (Central Time), our reporting is off as the UTC current date shifts to the next day. We were originally told this was a bug but after four months waiting for the fix, Support has come back saying this is…

I have a dashboard with 3 tables in it: current week, previous week, and historical week. The historical week is controlled by a 'week #' slicer. I am trying to display the week number and date range in each card title. for example the table titles should show "Current week # 19, 5/4/25 - 5/10/25", "Previous week # 18,…

Hi, I recently utilised the Week of Year function for a date column. I'm unsure if this is incrementing from 0, but the value for the 12th of Feb 2024 returns 6. I would expect it to return 7. https://www.epochconverter.com/weeks/2024. Can someone confirm if this is intended? It looks to use Sunday as the start of the week…

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. Each of these is a dedicated column in the dataset so it's just a SUM(2025), SUM(2024), and SUM(2023) for each series. The…

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 date and Death Penalty Date). They are all derived from a number of different fields with different conditions and then I…

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 know Domo has built-in filters for "Last 7 Days" and "Today," but I can't find a way to combine them in a single filter within…

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 Go, Next 2 Months, Year to Go, etc. I considered using a Beast Mode, but "Week to Go" would not be included in "Month to Go"…

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.

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 that when any period gets selected Current Month Headcount calculation becomes Zero. My dataset is very complex and massive…

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 create YoY differences. I will also note that I'm looking for a solution that should be able to transcend filters i.e. you…

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 trying to create a filter or a button to do same functions Period to Date: WTD, MTD, QTD, YTD without clicking on Date…

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 first week of 2025. I would ideally not like to use week numbers over actual dates on the x-axis. Has anyone else experienced…

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 show Headcount based on various dimensions like - Geo, Region, Country, Gender, Leader, Job Role, etc, etc. Currently 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 - This field tracks the date and time that a given record was added to a list. created_date_string - This field within Five9…

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 an "Exclude" last 'X" months option. (see first screenshot below) Problem: Needing to do date centered visualizations with…

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 chased month, not the current month

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 timezone settings are converting it to USA\Eastern Time. This is working as expected. Using this as an input dataset in…

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 across two different months (i.e., RSD and RED fall in different months or years). My objective is to filter out these…

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 these rules: Sun: 0, Mon: 0.5, Tues-Fri: 1, Sat: 0.5 I can't seem to figure out how to loop through to do this calculation so…