-
Dynamic Date within Beast Mode
I have a Beast Mode that is grouping transactions based on their date: CASE WHEN OrderHeaderLocalDate >= '02/27/2024' THEN 'Since Changes CY' WHEN OrderHeaderLocalDate >= '08/01/2023' AND OrderHeaderLocalDate <= '02/26/2024' THEN 'Prior YTD CY' WHEN OrderHeaderLocalDate >= '02/27/2023' AND OrderHeaderLocalDate <=…
-
Previous Month Last Year
I'm trying to make some companion comparison cards so that I can display, for example, on one card the top 10 PDFs downloaded last month this year versus another card with the same month last year. I have the data by month already, and I need to have this for each month, moving forward. Is there an easy way to set some…
-
Issues with Average Function
I have detailed biweekly pay data where I am looking for the average hours worked in every region per week (using a basic calculated field). This functioned well for 6 months but became an issue at the start of the year. Rather than finding my typical averages, suddenly the data is showing me trillions of hours in every…
-
Calculating Time Diff (in hours) over Multiple Days
Hello 😊 I am trying to write a beast mode that will calculate the time difference in hours (sometimes over a multiple day period). For instance, if the start time is 4/1/24 at 1:00pm and the end time is 4/2/24 at 9:30am I would like the beast mode to calculate 20.5 hours. Any help is appreciated! Thanks!
-
WEEKOFYEAR is not aligning to ISO-8601, is this correct?
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. . Can someone confirm if this is intended? It looks to use Sunday as the start of the week in this function. Best, Sam
-
Date Type capabilities
I'm trying to do something again, but I forgot how I did it. Coming from a PowerBI background when you choose the Date type it allows you for some dynamic presentation. Below I did it once, now it doesn't work any more where my columns are showing it by date. Compared to this How do I get it in the format to show…
-
Date Formatting in Tables/Charts
Hello, I am new to domo so hoping this is pretty basic to update. My date columns come in the following format "Jan 23, 2024" in my raw data. When I pick my date fields in any cards it only shows the year 2024. In some cases I will want columns or rows to be months or possibly days or weeks. How am I able to pull other…
-
Joining and getting all dates between start and end date
Im doing a join on billing ID's. Each billing ID has a start date and an end date. Im trying to return all dates between start and end date for each billing ID. I tried adding this formula to join. dt BETWEEN Service Start Date and Service End Date It isn't working as expected. Im just getting one date for each billing ID
-
Have a row displayed with 0/NULL when filtering by date when there's no data
Tried my best to summarize in the question... I have a data set of Google Adwords Data. I'm putting the data into a Pivot table and have campaigns as a Row. I'd like to have every campaign show in the table even when it has no data to report for the selected time frame. It essentially would the the row for the campaign and…
-
Trying to convert Month of the Year into Date with Magic ETL
Basically the title. I am using a dataset that pulls Month of the Year instead of Date, as the User count with the Date metric isn't accurate. However I have run into issues trying to convert Month of the Year into a date format. Here is the original format: As you can see, each month is numbered from 1-12. I used Value…
-
Getting value of previous quarter and comparison
Hello Team, I have a date column named 'Fiscal quarter start date' and another Beast mode with calculated value for 'Customer Survey' I want to create a beast mode in which I will compare the Customer survey of the Current Quarter with the second last quarter. I tried to create a Case statement but unable to get results…
-
30 Day Interval
Hello! I am looking to create a beastmode that sums video views and revenue separately in the 30-days after the asset is published. While the beastmode is validating and looks to be calculating accurately, the QA is very off. In the screenshot example, I manually filtered the time frame for 30-days after the published date…
-
Date Conversion
I need a formula for taking just the month name from this format - Thu, 29 Feb 2024 11:59 PM. I need it in a date formatted column though. I can take the Month Name using MONTHNAME('my date column') but i cant get the column to be date. Its always text. Any advice? Thanks
-
No Idea why I can't get string to datetime
Input into formula tool is 2019-01-02 07:30:00 AM, formula is STR_TO_DATE(TimeIn1,'%Y-%m-%d %h:%i:%S %p'). Validate formula checks out, but error is Failed to parse date/time: Error at or near character 11 in string /2019-01-15 7:30:00 AM
-
Domo Embed - reporting with a date range issue
I have an embedded dashboard that has programmatic filtering which includes a date range. This functions fine although i am now hitting a challenge in testing for the following reasons. I have records in the db table for when a product is available and another date for when its not available. I want a count of records that…
-
Multiple singe day events grouped as single consecutive day events
I am trying to figure out a way, in Magic ETL, to take multiple single day events and group them when there is break in consecutive days. Example, if the results show the 1st, 2nd, 3rd, 5th, 6th, 9th, 10th and 11th, I need three results, not 8. I want to see begin and end dates of 1st-3rd, 5th-6th, and 9th-11th. Any…
-
Creating a Beast Mode to calculate field sums for remainder of year
Hi - I am trying to write a beast mode calculation that sums a field from an as of date until the end of the year. The variable is indexed across the year and want to count how many are left depending on what date is entered. For instance if 1/22/24 was the date it would count all the values indexed for the variable until…
-
Beast Mode for same date check
I have a list of companies and their create date. I want to create a beast mode that checks if a list of companies has the same create date. Any help here? Would this need to be done in Magic ETL?
-
Date Reference Exclusion/Inclusion
I'm attempting to write a beast mode that checks a static date with a dynamic minimum date. If the static date is greater than the dynamic minimum date it would be classified as 'No' and vise versa. The beast mode formula: CASE WHEN Onboarding Date <= (MIN(MIN(Report_Date)) OVER()) THEN 'Yes' ELSE 'No' END When I use the…
-
Min(Date) Question
I'm having issues getting my beast mode to show the earliest displayed date. In the attached screenshot I would like the "Test - Min(Report_Date) column to all be the same date (2023-01-01) I've tried the "Min()" function and it appears to only check for the earliest date in each row, not displayed date on the card. Any…
-
Create A Beastmode filter that Shows Prior Year Sales in January, then switches to YTD starting Feb
Hi - I'm looking to create a beastmode that is a filter - what that filter would do is display 2023 sales in January 2024 (excluding January), then starting February 2024 would switch to YTD. This stems from our YTD cards going blank at the beginning of the year. It is important to keep the cards YTD and to only display 12…
-
Difference of values between 2 months
I have a value column named 'Value' and a month column named 'Month'. I want to create a beast mode to calculate the difference between values of the last two months. So if we have two months in the dataset - Nov 23 and Oct 23. I will want to calculate the difference in value between both months. It is a month-to-month…
-
Calculation inconsistently disconnecting from Date field
Howdy y'all! What I imagine would be a simple Beast Mode formula is confusing me and my team. In advertising data from Facebook, we are making a new field called 'Test Facebook Engagements' that is the sum of reactions, shares, and comments. Here is the formula: SUM(ActionsPost)+SUM(ActionsPostReaction)+SUM(ActionsComment)…
-
Subtracting Hours from Date time values
I have a dataset in which i have two columns of date timestamp values in format YYYY-MM-DD HH:MM:SS 1- Date created 2- Date Closed I have subtracted this with a beast mode to get the days and hours minutes: Beast mode name : Test01 CONCAT( DATEDIFF(Date Closed,Date Created),' ','days',' ',TIMEDIFF(Date Closed,Date Created)…
-
Date Selector Filter - settings
I would love to see an enhancement to chart properties on Date Selector, specifically for the PRESETS menu. Our data is not live, it runs nightly. So any filter for "TODAY" will always yield no results. The Chart Properties > Presets View has options to exclude Week, Month, and Year options - please add the option to hide…
-
Date Format formula
Need a date format formula to take this date from 24-hour format to 12-hour format so my date and time goes from 11/02/2023 15:53 PM to 11/02/2023 3:53 PM. Thanks
-
How can I display amounts for different months in a table in Domo?
I want each row to contain the amount for the previous month as well as the amount for each of the 5 months prior to that. What is the best way to do this in Domo with a Table chart type?
-
Date filter
I have data that has reporting data for every day. I need help creating a quick filter on dashboard when i select it and see last 7 days
-
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…