-
Issue with dates in ETL
Hello everyone! So we use filters similar to this in Domo and noticed that for some reason all results are being returned. What is happening below is we apply a filter on the rule to only look at 'Y' results that should be only applications hired this year, but instead we receive everything. We are working through it on…
-
Is this doable? Seeing percent of total day sales by hour using Timestamp column.
Hello! I have a problem that needs to be visualized and it was phrased to me like this: I need to see what percentage of sales each hour had for the total day last year then I need that percentage multiplied by the daily goal to get an hourly goal for today. So we have this chart right now: this show us net sales today,…
-
Group Sales Data by Hour by Day
Hi! I have a dataset that has a timestamp as the date column. I need to sum the sales by hour for each day. I need this done in Magic ETL so I can do another part of my problem before putting it into a card. Is there a way to do this? I have been playing with 'Group By' tile and 'Rank & Window' tile but can't seem to…
-
use fields from different tables group by date to calculate percentage
Hi, I am trying to calculate a percentage using two fields from two different tables in SQL Magic Transformation. Table a looks like this: Date All Revenue 09/01/21 100 09/02/21 200 Table b looks like this: Date HDM Revenue 09/01/21 90 09/02/21 170 I need to build a table that would calculate the percentage of HDM Revenue,…
-
Previous day values - Following Day Values Restart Calculation Each Month
Hey guys, I have a dataset that appends each day to include the daily downloads, and resets the calculation on the 1st of every month. This issue is, it's cumulative totals, so if yesterday we had 40 downloads and the following day we had 15 downloads, the total for the following day would come in as 55 total downloads.…
-
Custom Month Filter for building cards
Hello! I am currently building simple gauge cards that show sales for today, week, and month vs our goal for each of those. (see screenshot) Is there a way for the 'This Month' card to have a custom date range each month and have that automated so I don't have to change all the cards each month to a new date range? I work…
-
Weird/Random Question about the date filter.
I have a card that is a POP trendline and is comparing current year to the previous 2 years aggregating by month You can see that in the current month (September) there is a drop off from August because it is an incomplete month. Is there a way to show the card in this same view but just not display an incomplete current…
-
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.