-
Beast mode to generate Batch Date?
Is there a Beast mode that can generate Batch dates? A colleague of mine has a dataset that updates monthly, but does not include a date column. The internal clients who view the report would now like to see a breakdown by date. Is there a way to use a beast mode, or some other tool, to create a batch date calculated…
-
How do I alter Date (in Text format : 01.09.2023) to Date format?
How do I alter Date (in Text format : 01.09.2023) to Date format? I need it to be in a Date format such as 2023-09-01 instead of 01.09.2023
-
Date format Changes
Hi @GrantSmith , This is the date format I have in the dataset : I wanted to remove the C and have it in text to alter it as Date : Thus I used this formula on the formula tile (RIGHT(Date, 10)) and got it in : However I tried using the Alter tile and Formula tile (STR_TO_DATE(Date, '%Y-%m-%d')) which did not work, giving…
-
Hide the date filter from the card details
Hello, I have created the custom date filters based on variables and beast mode which I am using on the report and dashboard levels and do not want to give the report user the ability to use any other date filters including the date range filter located on the top of card in card details view (please see the attached…
-
Extract Quarter Value from Date Field and Return First Date of that Quarter
Hello, I need to extract the quarter from a date so it returns that quarter it falls into (example: 01/01/2023 falls into Q1. Instead of Q1 I want it to return the first day of that quarter. Example: DATE 01/05/2023 QTR DATE 01/01/2023 To note I am making a beast mode to do this in a view. I have already tried to use DATE…
-
Variables limitation: Date filter is not working on the trend cards
When I select the date filter in domo dashboard, all the cards are updating based on the date filter except the M/M Trend card. Screen shot 1: When I select the current Month (Oct 2023), the M/M Trend card is showing the date range from 2022 Oct to 2023 Oct which is expected. Screen shot 2: When I select 2023-July, the M/M…
-
How do you build a filter for a date range?
I need to build out a forcasting dashboard for my purchasing team. They need to look at the last 3 months sales for some items and I was able to get a filter to give me that range in my ETL. However, the other metric they use for some items is a term called "forward 3 months". This means that they need the next three…
-
Average Length of Stay in Beastmode
I am trying to get the average length of stay using our admission date till our discharge date. I tried using the datediff function and got an error when validating, "Calculation error: whoops! something went wrong." I have flipped the discharge date and the admission date and the same error comes up. I feel like I am…
-
Date Picker & Period Over Period Chart Enhancements
We have end users who want to set a date range and see the change compared to the corresponding previous period. Currently, in PoP cards, you can: Set a comparison period on the cards that overrides the dashboard date picker OR Use variables and Beast Modes to create current and previous period calculations and add the…
-
How can I convert an Excel date code into a normal M/D/Y formatted date?
Hi All, I have some data that I link to DOMO via the Google Analytics connector. It's provided by a 3rd party and contains dates in Excel codes in their 4** format. Is there a recommended Beast Mode or other way to fix the date formatting? Due to IT policy, I can't access google sheets to change it manually. Plus, I would…
-
Sorting Beast mode
Hello! I'm trying to sort my beast mode where I'm normalizing my data to trend performance by the first month it's published and trending for a year since all my rows of data will have different dates in which they are published. The issue I'm running into is I can't sort the beast mode in order of Month 1, Month 2, etc.…
-
Can I use a workflow to change the default date on a dashboard once a month?
Our sales dashboards by default show the current month, except on the 1st of every month. When a user gets to the dashboard it's all blank because we don't have data for the 1st yet. I want to find a way via a workflow to change the default date to the previous month on select dashboards on the first of the month, and then…
-
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…