-
Option to show date range on dashboard cards
I'm working on a dashboard that has some cards with one date range, and others with another date range (e.g., last 5 quarters vs. last 12 weeks). It's not clear from looking at the cards what the date ranges are because the cards aren't all configured to include the date in the chart. It would be helpful if my dashboard…
-
Null Date Values in Card Filters
Hi! I know this question has been asked a few times in the forums over the years (see "Best Practice for Date fields" and "How do you Filter on Date that is Null") so apologies for the redundancy. I'm asking the question again because these posts seem to miss an element that is crucial to my use case: calculations and…
-
How to edit DATEDIFF to calculate beyond calendar year
Hi, I have an argument where I am attempting to calculate how many consecutive days have occurred since the last specific event (See pic below). But when the 'Year' filter is applied to the dashboard and also filtered by a 'Region' and the event occurred in the prior year, I get a "no data in filtered range". Is there a…
-
Pivot Table Week over Week % Change
I want to show the WoW % change for my data but not really sure how to go about it. My raw data is daily and I grouped it into weeks in the pivot table. I want to add a column to my table where it will show the % change of sales from the previous week.
-
How do you change a date to a digit to get a sum?
I have a column that has the completion date. I'd like to change that to a number 1, so I can calculate how many have been completed. If completion date equals 6/12/2023, 6/13/2023, 6/14/2023, 6/15/2023, or 6/16/2023 then change each of those values to the number 1
-
Ability to set Acceptable Time Granularity Settings on Cards
I work a lot with monthly datasets. Our Granularity options will still allow our users to select daily or weekly which is confusing. On the Page Filter section for Date Range and Graph By, are we able to make sure some cards will not respond to Granularity they do not support.
-
Best way to have months show as individual columns in a table
What I am wanting to do is list the months this year Jan, Feb, March, etc.. in a table. I assumed that the date filter for a table would allow me to graph 'This year, by month' in the same way it would for a bar/line chart but that doesn't seem to be the case. Is there an easy way to do this with tools in the analyzer or…
-
Date format question
Hello all, I have a snowflake i/p data source. One of a column is a date field and it showing up as floating decimal in Domo. This field has value -3 (even in data source) if it is a null else it is a date.. As this is floating decimal type in domo, under configuration I changed to Date type. When I try to join with…
-
Caculate percentage in same month when using two date columns in same data table
Hello Domo Community, I am trying to count the number of distinct product id’s that had a field issue during a month and compare that with the count of sales units in that same month. The data looks like this: Unit id Sales Date Service Date 1 1-Jan 2 2-Jan 2-Feb 3 1-Feb 4 2-Feb 2-Apr 5 1-Mar 6 2-Mar 7 1-Apr 8 2-Apr 2-Apr…
-
Issue with Sales Data Tracking and Date Transformation
Hello, I'm encountering an issue with tracking sales data in from our CRM. The problem arises from the fact that the table card relies on the 'Date Created' column for capturing engagements. Although this successfully captures most sales data, it fails to include engagements that were created in the previous year but…
-
Why doesn't the Date Settings feature in Magic ETL update my dates?
When I navigate to Settings and change the Timezone to America/Los Angeles, it doesn't change any of the values for my date columns. However, when I navigate to my input dataset in the ETL and change the time zone on an individual date field, it works as expected. Am I doing something wrong?
-
Option to label the date range on a card
I often hide the date range on card details because there is no way to indicate what the range is for. Launch date? Expiration date? Data upload date? Would LOVE to see a text box perhaps here (yellow highlight below) that would allow me to write text before the date range. In the example above, I would write "Activity…
-
Is the data restricted for drill downs?
I am building a drill-down but seem not to have the same options as I would building a separate card. Example: I have a stacked bar overview where I am demonstrating the cutomer base by volume over months and by customer types. I am trying to create a drill down where I am showing in a pivot table view where I want to show…
-
How do I set up the append option for updating data correctly?
Use case: I have callrail data that begins in 1/1/2021. Currently the dataset is updating everyday and has REPLACE as an update method. The dataset is now taking at least 1-3 hours to update. I thought about changing the update method to append but when I did, I had duplicate data from 2021. How can I change the update…
-
Update Date Selector "Chart Type" to Match Global Date Range Selector
<Please direct me to an existing feature request if exists, the closest I could fine was a 'need help' linked below> We are currently using Domo Everyone embed and are limited with our date filter options. The current date selector is clunky and limited. I have to use a ton of dashboard space to get it to look just OK. The…
-
Option to show an alternate date range when it's a new month/week
Many of my datasets pull in yesterday's data on a daily basis. On charts that are defaulted to show "This month" or "this week", they will blank out at the beginning of the month/week. I would like an option, when selecting a "current" date range default, to show the full prior month/week on these days (or when there's no…
-
Query Based on a Value Between Two Date Columns
I've got a data set that includes job tickets with create_date and last_update columns. If the date range for a card is set to include a date in between the create_date and last_update, the ticket should be considered "open" at that point in time, and any tickets outside of the date range should be considered "closed" at…
-
Creating an Artificial downtime for maintenance for only week and work hours
I am trying to calculate downtime within DOMO. The downtime we have currenlty coming from the other system does not put in the factors of weekends and holidays as well as after hours. How can I calculate a correct amount of time between the starttime to endtime while only subtracting within the window. For example if A…
-
ダイナミック日付範囲フィルターに何の単位を選択してるかをBeastmodeで判定したい
皆さん お疲れ様です。 Domoのダッシュボード上の右上のダイナミック日付範囲フィルターにて単位を四半期とかヶ月に選択してるかをBeastmodeで見て判定でコントロールしたいですが、方法はございますでしょうか。 よろしくお願いいたします。
-
How to compare last 28 days with prior 28 days?
Hello, I'm trying to compare the number of sessions in the last 28 days with the number of sessions in the 28 days prior to that. How do I accomplish this with a period-over-period multi-value chart? This seems fairly straightforward in google data studio But it seems like I'd have to create BM in Domo based on some of the…
-
Can you turn a date range into each individual date in the range?
I have a start date and end date with a total sum of hours to work. These are each 10 days with an average of 3.2 hours and 2.8 hours respectivelivy. Is there a way i can display each indiviudual day of the date range with the work per day? Something like this?
-
Cards - BeastModes Need to Know the Dates that are selected by the user (card/dashboard level)
I am always trying to find a way to detect what the user has either selected for a date on the card or the dashboard when building my BeastModes. Can Domo not find a way to pass this in as say a Macro or something. And I am saying Macros for both the card and dashboard level date selections
-
Creating a Heat Map Based on Start and End Times
I have a data source that includes one row each for scheduled activities, with a column with the start date/time and end date/time (i.e. 2022-09-06T09:00:00 and 2022-09-06T13:00:00). What I need to produce is a heat map showing blocked out times in hour or half hour increments on a heat map, with the days of the week as…
-
Fixed to Flex Date selection
Hiya, does anyone out there know best practice (if possible?) to set more dynamic date ranges? Say I want to display “campaign to date” e.g. launch was on 2/4/2023 and I want my dashboard/cards to display data from that fixed point through [today] (variable) — how is this achieved? The only options I can see are either…
-
Using date filter as input for Beastmode calculated field
Hi, I have a Beast mode calculated field where I use MAX('Sales_Date') to keep the calculations fresh automatically (as we are getting the data with 1-2 months lag so I can't use current date). Problem is when users start changing the date range filter in the dashboard to a range not including the MAX('Sales_Date') in the…
-
Filtering data automatically for a specific Monday in a Domo dataset
Hi Everyone. I have a Domo dataset that updates daily but I need to create a chart that is essentially a snapshot in time showing WoW as of every Monday. I am not coming up with any way to do something easily in BeastMode that would work for me. Any help is greatly appreciated. Thanks!
-
Calculate time between two dates during business hours, excluding holidays & Sat/Sun
Need to calculate the elapsed time/minutes between Start Date and End Date, using business hours of 9:00AM to 5:00PM, excluding Saturday/Sunday & holidays. Anyone able to help? either in Magic ETL or Beast Mode.
-
How do I change my week to Mon - Sun and fix this report?
I have an auto weekly report that shows the dates of a week and the corresponding data. The report goes out on Monday and I need it to show the previous two weeks (Mon - Sun), not including the current Monday data. Right now I have manually typed the dates (if 1.2.23, 1.3.23..then week = 1/2 - 1/8) and select the next week…