-
Creating a date range in Beast Mode
Hi Community So I have 6 months data, which i need to present in weekly using bar graph. When i do so its giving me as Week 1, Week 2 ..etc , but we need with a date range like from 1 Jan to 7 Jan Can anyone please help me to create a beast mode to fix this issue
-
STR_TO_DATE throwing Parsing error in ETL
I am facing a error while converting string to date. This process is done in the ETL Date column has value - Jun 11, 2024 @ 14:33:22.000 Formula - STR_TO_DATE(@timestamp, '%M %e, %Y @ %H:%i:%S.000') The error showing is as attached below Note : We receive data using email connector. Please let me know where it is going…
-
Inherit date range from parent dashboard
We have a parent dashboard with 20+ sub-dashboards where the users would like to set the date range in the parent dashboard and have all the sub-dashboards default to that range as they open each sub-dashboard.
-
Can a date range set on a dashboard be applied to sub-dashboards?
We have a parent dashboard with multiple sub-dashboards. The primary end user for that set of dashboards wants to know if there is a way to set a date range in the parent dashboard that would then be applied to all the sub-dashboards? Alternatively, is there a way to sync date range selections across multiple dashboards…
-
Last X Periods to Date
I would like to add to the date filters on the to right corner of charts the following options: Life to Date Last [X] [Period] to Date I have a dataset where a number exists for 'Max Business Date' each day. As the days pass, the number gets bigger until it reaches the total number of business days at the end of the month.…
-
Calculation of previous dated values
I am trying to calculate trailing period (previous period) calc. I have year(variable selector), month(dropdown selector chart using column from table) If i select Year = 2024 and Month = Feb, I should get the data for 2024-JAN. Tried this formula but failing to get the correct figure. RecordDate(date format col) is…
-
ETL - How to spread a Budget over two dates within a variable date range.
I have various start and end dates for campaigns. I know how to calculate the # of days between any get set of dates. But, what I am trying to set up in the etl is this - if I have a budget amount, start date and end date, what is the easiest way for me to have the etl calculate the division of the budget over the given…
-
Need help with Date Range/ Period to Date
As you can see top right, Domo has a selection Date Range, Period to Date, and if I click on Week to Date, my 3 cards will update date dimension to current Week to Date, Month to Date, Quarter to Date. I'm trying to create a filter or a button to do same functions Period to Date: WTD, MTD, QTD, YTD without clicking on Date…
-
Period over Period with Non-Time X Axis
First time poster!! Thanks for all the help you've contributed thus far Domo Community. I'm trying to create a year over year comparison graph with our locations on the X Axis, instead of the required time period on the x axis. The period over period comparisons are only available when Time is used on the x axis, so I…
-
Data Structure Issue
Short version: how do I check if a field is a valid date? Long version: Using the NetSuite connector, our data has a field called Period. The connector does not allow me to define the data structure. I tried admin » toolkit » schema management. It doesn't hold. If I force the dataset field to a string, the next run it puts…
-
Assign date range field on a per column basis
I have a single table that some columns or calculations use one date field and other columns use another date field. However domo only allows you to associate a single date field to the entire chart/table. This is extremely frustrating. For example the red columns use TransactionDate but the green columns use…
-
Custom Date & Timestamp Formatting in Analyzer View of Cards
Hello Domo users! As a relative newcomer to this fantastic platform, I am thrilled to share my first discussion post with the greater Domo Community. I've been working with Domo for nearly a year at this point, and it has been a wonderful experience and I truly admire the insightful analytics and operational abilities this…
-
is there anyway to change default time in Domo?
Seems like date/time format always defaults to 12:00am. Is there anyway I can change this universally so that it always just defaults to 11:59pm when no time is specified in date/time format?
-
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…