Community Forums

Discover best practices and find answers to your questions with advice from fellow Domo users.

Recent Discussions

Calendar date to be aligned with other filters
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
MagicETL Transform Settings: Timestamp to Date
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…
Filtering and Adjusting Cross-Month Records in MagicETL
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…
Number of business days in the month
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…
Is it possible to fill in missing dates at the card level | Fill Missing Dates button isn't working
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 corresponding values on almost all of my bar charts. My dates are all weekly and there's weeks with no data on every card. I don't…
Create a "Latest Available Date" selection for page level and card level filters.
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 page level, it requires a rank and window in a dataflow. Both of these work arounds break any smart text that would refer to…
Additional Functionality when charting by Week
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 Tuesday of the Year? The Tuesday that includes the 1st day of the year? Is it simply whichever date is the 1st day of the year?…
Date Filter to Omit Last 45 Days
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 set of data we have so I would want to look at July 5th and earlier. I know I could use the "Between" filter to just go…
YTD, YOY, M-1
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?
Period over Period Beast Mode
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(CURDATE() - INTERVAL 1 WEEK) AND YEAR(Date) = YEAR(CURDATE() - INTERVAL 1 WEEK) AND DAYOFWEEK(Date) <= DAYOFWEEK(CURDATE()) THEN…

Welcome!

It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.