-
Date Filter in Embedded Dashboards
The date filter in DOMO's native site is very powerful. I can group date variables by day, week, month, filter on Between dates, a single date, last month, year…etc. However, when I embed a dashboard, all of that capability goes away and I have to create filter cards which are cumbersome and not nearly as dynamic. Please…
-
Date Columns is Returning Mixture of Date and Text Formats in the CSV Attachment in Scheduled Report
ISSUE: The date Columns is Returning Mixture of Date and Text Formats in the CSV Attachment in DOMO scheduled Reports. I need them in text format and the correct should be the (e.g. 11-14-2023 10:00:00). Some are appearing correctly but some are giving me in date format in the same column (see screenshot). Is this a known…
-
Can you convert Date to Text in DOMO?
Trying to find online but could not. Main purpose is that when the csv attachment in schedule reports get sent, I want the report to have no "T" stamp. Current: 2023-11-27T00:00:00 Change to: 2023-11-27 00:00:00 If you guys have other alternatives, please let me know. Thank you.
-
Is there a way to craft a variable to group by Month/Quarter/etc. and still display YoY data?
I'm currently trying to accomplish this, but it's not allowing me to select comparison data since the Beast Mode output isn't a date field.
-
Group by N Weeks option to graphs
Hi all, Recently, we have been building a lot of graphics for Agile Sprint Planning. One thing that has been quite frustrating is the lack of customisation when grouping by date objects. It would be brilliant if the option to group by "N" weeks, instead of grouping by weeks or grouping by months as our Scrum Teams work in…
-
Beast Mode: How to aggregate a value for 1yr and remainder of the yr from a date?
Hi - I am trying to figure out how to aggregate values from a run date thru the end of the year as well as aggregating from that same date as_of_date for 1 year out. Essentially if the date is 5/31/23 it'll aggregate a value from that date through the end of the year (12/31/YY). Separately, from that same as of date…
-
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?