-
Is there an easy way to calculate the days left in the month to insert in a Beast Mode equation?
I'm working on a Beast Mode where I have a given an amount of production that I want to divide by the remaining days of the month. The method I have below doesn't function the way I want it to. My code segment is below. Is there any easier way to go about doing this? Thanks in advance. (SUM(`Goal`) - SUM(`Production`)) /…
-
Beastmode for Week starting Monday
I have a colleague whose reporting week starts on Monday but our Domo instance starts our weeks on Sunday (and needs to stay that way). Most of their reporting is looking at the previous week's data and they are not the only person using the dataset so I can't adjust the dataset. Is there a way to write and a beastmode as…
-
How to find the difference between 2 dates?
My dataset aggregate value totals on a monthly basis. Each row represents an individual site and value for numerous metrics. What I am trying to do would be how to find the change between 2 months like between Oct 1 , and Nov 1, as shown above for the values in the column to the right. But I am not sure how to write the…
-
How to delete portion of text in a column in the ETL?
I have a date column that is in this format: The format of the date is fine, but what I am trying to do is get rid of everything including the 'T' and to the right, so that all that is left would be 2021-06-27. If a solution within the ETL is possible that would be great.
-
Adobe Analytics OAuth 1.4 connector - Update a dataset hourly
-
How can I compare YOY data with an offset of a couple of days?
Hello, I'm 100% new to DOMO and I'm looking for some assistance. I'm trying to compare data from 2021 against data from 2020 using DOMO with a dataset connected combining data from multiple Adobe Analytics sources, and other accounts. Specifically I need to compare promotional revenue data for a Memorial Day promotion. I…
-
Ranking x axis by year then month with a series sort by alpha
I am trying to get an x axis to display in date order over multiple years while also sorting by a series. It is not working. I have tried beast mode following several suggestions on dojo, but nothing works.
-
Convert DATETIME (UTC) to specific timezone
Hello, Domosapiens! I have an interesting quandry. I have a data flow (using MagicETL - should I be using something else?) that I am trying to build and convert a date that my MySQL data connector is bringing over. The datetime column comes from an orders table and is called posted_date and it brings the data over as UTC…
-
Adding an "Activity_Date" to a nightly refresh dataset.
I just set up a connection for a dataset that doesn't have any fixed 'date' column. The only date column it will have will be the batch_last_run date. On a nightly basis this dataset will append and start to build history. How can I add a new date column in a format such as 'Jul 1, 2021', so that the new data and old data…
-
I am trying to get the timecards created this quarter for last quarter
I am trying to get the timecards created this quarter (Q2) but for last quarter (Q1) the reference dates are created date(current quarter) and end date(previous quarter) so, I have this created in beastmode>>> (case When `TC: Created Date` >= '4/1/2021' and `TC: End Date`< '3/31/2021' then 1 else 0 end) how can I make the…
-
Creating a static column that doesn't interact with the date filter.
I am working with Google Ads Campaign data. I want my 'Campaign' column to display all the campaign names and not remove any names when the filter is adjusted. other metrics such as 'click through rate' I do want to be able to interact with the date filter. How can I take my 'Campaign' column and make it static, so it will…
-
Formula/Beast Mode Help
Hello, I'm stuck with how to write a Beast Mode/Formula that looks at two different dates. Here's the example: Employee 1: First Date Field = 12/02/2020 And their Email Date Field = 12/06/2020 Employee 2: First Date Field = 12/02/2020 And their Email Date Field= 12/23/2020 I want the Beast Mode to return 'True' if the…
-
Business days between date function
I use the datediff for business days function in a number of mysql data flows and it works great. However, I'm getting some very strange results on the latest flow that I'm working on and I can't figure out what's going wrong. I have a start date which I'm looking to compare to the current date. However, the code I'm using…
-
How to create a card with data from the calendar month before last
Hi, does anyone have any thoughts on how to create a card that contains rolling data for a calendar month that was 2 months ago? Example 1, If today's date is June 15th, card should show data for the whole month of April Example 2, If today's date is November 30th, card should show data for the whole month of September…
-
104 Weeks as option in Multi-Value card
With so many industries moving to a 2-year CAGR in addition to their regular YoY comparison numbers, it would be great if the Multi-Value card allowed for a 104-week option as a quick way to build the change value.
-
2 Different Date Data Sets
I have a problem where I need to match up 2 different data sets to show funnel. Create Date & Demo Date. I need to show this data by week number. A demo date can be weeks after the create date. Here is my example: Data set 1 Week Create Count 1 10 2 20 Data Set 2 Week Demo Count 1 3 2 8 How can I merge these data sets do I…
-
DOMO SQL MAX(date) not working
hello, hope someone could help on my SQL: I just created a simple SQL under DOMO MySQL to select some fields and the MIN and MAX of a date, like: SELECT `id`, `name`, min(`a_date`) as 'oldest date', max(`a_date`) as 'latest date' FROM`data_1` GROUP BY `id`, `name` but nothing is returned in the 2 date fields, original…
-
Create a dynamic date range with a beast mode
Hi, I want to create a dynamic date range to capture the following period: 100 days ago excluding the last 4 weeks (28 days). The date I want to use is signup_date. Is this possible with a beast mode?
-
Diferent date ranges on a Dashboard
Im building a dashboard and some cards have diferent date ranges, some have yesterday as default and some have this month, at this point dashboard works fine, but if we try to modify date ranges from the dashboard lets say lat month its no working, will show blanks. am i missing a configuration? thanks in advance.
-
Get Data Based on Comparison of 2 Dates
Hi, I have a Dataset with 2 dates open_date,closed_date for a category(has 2 values open,closed). I want to build a weekly bar chart with a count of category where the date range is selected for the column open_date but the date range should also be applied to closed_date as well. For Ex:- Open DateClosed…
-
Date Range Buckets
Hello, I am trying to create a way to look at upcoming estimated shipping dates but I keep getting an "error during processing" . I have made buckets for WIP based off days in shop field and basic case formulas in the past with no issues (See attached). I think I am having issues with my approach due to this being dates…
-
SQL Data Troubleshooting: Neither Date Filter Nor Conversion Rate DataFlow Calculation Working
Hello DOMO Community, Questions: 1. Can you tell me why person_created_date is not filtering >= 01-01-2019 results? -As you can see in the screenshot, the person_created_date is returning results prior to 2019. 2. Can you tell me why my SQL is not grouping the data by lead_marketing_channel in Domo Analyzer? -As you can…
-
Show data of last 10 weeks
Hi, I have a dataset that shows data year to date. And I am using an HTML card to get a table view. Is there a filter or setting that can be set, to always show the last 10 weeks of data as time goes by? I have week column and to not overload the table, I always only want the last 10 weeks data.
-
Rearrange values on X axis
Hi, I am creating a view where I want to observe volumes base on a time of the day bucket. So have a variable: time_of_the day that I created using a timestamp variable. When I put the variable on the x axis, it starts with 10-11 AM first and and with the earliest value, 9-10 AM. I would like to organize the values in a…
-
How to create a Beast Mode calculation for fiscal year using a date field?
Hi All, I have a unique dilemma. I need to create a beast mode calculation to calculate our revenue for the latest fiscal year. I know I can just manually add the date filter criteria into the calculation or add a filter but the thing is the data is updated every day and we need the date filter criteria to be dynamic &…
-
Finding "earliest" date when one of them might be NULL
I have a dataset with a key field (loan number) and a series of dates. Within the ETL, I have to calculate several "Earliest Of" dates. So if the dataset has the following fields: Loan Number Date A Date B Date C Date D Date E I might need to create a new field called "Earliest of Date A and B". I am able to use the…
-
increase - date to date
Hello, Maybe somebody can assists how to write the formula for the next issue (ex): date1 = amount1 date2 = amount2 date 3 = amount3 p.s. amounts are not on daily basis on the chart (line + grouped bar), I want to show - for the date2 - amount2 (bar) and sales increase (amount2-amount1)(line) - for the date3 - amount3…
-
Adding year value to MM/DD date field.
I have a free text note field that we preface each note with a MM/DD format date. I am trying to add the year to this field so that Domo can chronologize this field and compare this free text date with things like system driven dates. I am currently using the following beast mode to extract the date from our text field,…
-
Creating custom date ranges for display
I would like to display my cards with a custom date range that doesn't exist. I need financial year to date for Australia. Our financial year runs from 1 July to 30 June and so all our clients here would like their data displayed that way. How can I do this? There isn't an option in the date range field to do this. Domo…