-
Comparing WTD Sales upto the current time for last 3 week
Hi, I want to compare WTD Sales up-to the same point in time for the past 3-4 weeks. The Period over Period chart only compares WTD sales at the end of the day instead of up-to the current point in time. How to achieve this in Beast Mode or Dataflow level? Thanks, Prajwal
-
Recreating Excel's Pivot Chart "Show values as % Running Total In"
I'm trying to recreate this Excel Pivot Table in Domo (Currently as a Heat Map but if someone has a better suggestion I'm all ears). (See "Domo - Pivot 1.JPG) The good or bad thing is I can select the data from the database however I want so I'm free to do calculations before the data gets to Domo but the basics that make…
-
Dynamically Uncollapse Columns for Tabular Output
Hi, I'm trying to create a stored procedure like in the link below and while its not erroring out, its also not uncollapsing columns like it says it would. I'm not great at SQL and I've tried this in ETL but I can't get it to work there either. https://knowledge.domo.com/@api/deki/files/5209/Dynamic_Pivot.sql?revision=1…
-
Getting DateDiff to show decimal places
We're using two date fields in a card and are trying to show a difference between the two. The source data shows these w/decimal places (screenshot) but our card didn't, couldn't understand why but when viewing the data table at the bottom of the card, it seemed it might be caused by the PickupDate being YYYY-MMM only,…
-
User defined functions for Beast Mode?
Is it possible to create user defined functions that can be called in Beast Mode? I'm creating Beast Modes for summaries in the top left of a visual, and it's getting ridiculous & unwieldy pretty quickly. In order for it to look reasonable, I need to format and abbreviate the numbers, similar to how it's described in this…
-
Remove Duplicates - Keep Most Current Instance?
I have a table of Opportunities from Salesforce that I am pulling into Domo, and Appending on a regular basis, for any Opportunities that were modified by a User or Automated Process in the last day. The purpose would be to have the most current records of all fields, for every Opportunity. What I'm finding is that I most…
-
Adding an email address to table
I'm trying to add a clickable email link to a table. From reading through other posts, I know it has to be some form the CONCAT below. When I try to use what I've written, it doesn't do anything, doesn't open an email message, nothing. What am I missing? CONCAT('<a href="mailto:',`Email`,'">','Send Mail','</a>') In the…
-
Round Down In Beast Mode
How do I round down to the nearest thousands. For example, 17,692 should be 17,000...not rounded up.
-
Can you use REGEX in a Beast Mode?
Easy question for a Monday morning. Can you use REGEX in a Beast Mode? I have found references to REGEX in ETL but nothing about it in a Beast Mode. Thanks and enjoy the softball.
-
Joining two datasets in ETL using SQL
Hi, I am using ETL magic transform sql function. Input: Dataset Transform: SQL query let's call it table A Output: Select * from table A It is a really simple sql query which should take a maximum of 10 seconds to compute. However, when I save and run the dataflow it is currently on the 10 minute mark. Any idea why this is…
-
Case statement with multiple field conditions
Hi - I'm looking for a Case statement that will provide multiple conditions and multiple "then" statements but keep getting an error. I've tried multiple versions but none have worked. Examples below: CASE(`Impact Rank`) WHEN <(`BDS Rank TW`)THEN CONCAT('<span style="background-color: #00A86B">','OUTPERFORMING') WHEN…
-
How to create a beast mode calculation that can do a count and then sum
I’m currently working on an issue dealing with conducting a filter than an aggregate in beast mode. (I will say at this point that I have a feeling that this may not be done in Beast Mode.) I have my data that looks something like this: Col A Col B Col C (What I need to create) B 2 0.2 G 4 0.4 H 4 0.4 The total of Col B is…
-
Join twice on a different column (only 2 input datasets)
I've looked but unable to find anything to indicate it's been asked or that it's ever been addressed but we're looking to join an input dataset 2x (same column) to the other input dataset but on a different column each time; is this possible? Example: Table 1: Conversation Assignee and Conversation Rating Assignee (Dataset…
-
Last 4 weeks accumulated beast mode
Hello, I'm trying to write a beast modes that shows the last 4 weeks as Last Week, the previous 4 weeks before that as Previous Week, and the last 4 weeks prior year as Prior Year. The reason why I will create 3 beast modes is because only want 3 columns showing for these accumulated week periods, versus showing 52 columns…
-
is it possible to create generic transforms available to all datasets/dataflows?
I know this has been asked before, in different ways and different contexts, but I am hoping to create a general (ie object-oriented) framework that standardizes common ETL tasks across multiple datasets. I know I can create a Magic ETL dataflow which applies a common transform across multiple inputs and gives multiple…
-
Using DataFlow, what is the difference between adding Transforms and adding Output DataSets?
I am new to MySQL DataFLow in Domo. Can someone explain the difference between Transforms and Output DataSets, and when to use each one? Thanks!
-
Adding missing day rows
Hi, I am trying to get data for everyday in a particular date range even if there is no data for that day. For example, Item Location Date Count A USA Jan 3, 2018 5 A USA Feb 10, 2018 12 A USA Feb 25, 2018 13 A Canada Jan 7, 2018 14 A Canada Feb 10, 2018 10 A Canada Mar 3, 2018 5 Desired O/P: Item Location Date Count A USA…
-
Beastmode Between Specific Dates
How can I write a beastmode to return data between two dates? For example CASE WHEN 'Date' >= 10/01/2016 and <= 09/30/2017 then 'value' else 0 end Thanks! Sarah
-
Converting currency
I have some data which contains revenue but in USD, because the data vendor is US-based, but all our other numbers are GBP. Any ideas on a way to convert tjhis into GBP? Perhaps pull some public currency data into a table and then I can do a currency calculation in beast mode or a tranform? Mainly interested in where and…
-
CSS in my beast mode calculation appears as a text instead of corresponding to actual value.... CONC
I've this in my bease mode calc and when I use this under "Guages"... it displays "the css code itself like '<div style="font-size: 20px;">'"... CONCAT ( '<div style="font-size: 20px;">' ,CONCAT ('Total Daily Unique Visitors:', round(((sum((CASE WHEN `scenario` = 'AC_TY' THEN `daily_unique_visitors_scenario` ELSE 0 END )))…
-
Ignore filter on a calculated field
Hello, I'm wondering if it's possible to create a BeastMode that ignores date filtering... I have a dataset that contains the following information ID# CUSTOMERNAME STATE FullDate Logins Errors % The card I'm building should only display the data from yesterday BUT, I want to add a field that calculates how many times the…
-
Using LIKE operator in Beast Mode
I am tryign to sum values based on two criteria. This is what I have come up with but it says there is a syntax error. I am not to sure how to use the LIKE and IN operator as I could not find much info on them. SUM(DISTINCT CASE WHEN `Travel Location` like 'Domestic' and 'International' THEN `Entered Hours` END) Thanks!
-
Trying to combine two different case statements
Hey everyone, I am currently trying to combine two case statements. I have written this statement: CASE WHEN DATEDIFF(`actual_ship_date`,`release_date`) < 2 THEN 'A' WHEN DATEDIFF(`actual_ship_date`,`release_date`) <= 3 THEN 'B' WHEN DATEDIFF(`actual_ship_date`,`release_date`) <= 4 THEN 'C' When…
-
Hover Results on stacked bar Graph
Hello, Is there a way to have all of the results show for the corresponding Bars when hovering over a specific result? Example: When I hover of the "F" Category in my card it highlights all of the other "F" categories within the card as well. But it does not display the results in all of them, it only displays the results…
-
Updating data in a dataset based on date
Hi Everyone. Long time lurker first time poster (please be gentle) I have a dataset that contains a lot of customer data (not to brag or anything) and I'm trying to update the customerID column for one specific customer from 123 to 456 only when another column "event date and time" is before 8/1/18. Essentially, I want all…
-
nested case for arithmetic operators
Hi, I've been having troubles with MySQL dataflow trying to write a code basically doing something like this: (CASE WHEN week = 1 THEN (a/b) END) - (c/d) * e i tried writing it down like this: (CASE WHEN `Week` = "1" THEN SUM((CASE WHEN `8Q` = "POR" AND `Fiscal_Year` = "FY19" THEN(`8Q_Price`*`Tons`) END)) / SUM((CASE WHEN…
-
Adding a new date column which is based on another Date column
Hi, I am trying to build a card that shows the items and the date it goes out of stock and the date it comes back on stock. I have the following dataset: Item Country Date In_stock In_stock_previous_week A USA Sep 17 0 1 A USA Sep 24 0 0 A USA Oct 1 0 0 A USA Oct 8 1 0 A USA Oct 15 0 1 A USA Oct 22 0 0 A USA Oct 29 0 0…
-
Beast Mode Embedded True/False
Hi There, I'd like to create a beast mode so that my pie chart can create all the options. I currently have a beast mode that has a true/false statement indicating which cells have been updated/not updated. I want to return the count of all the not updated as well as options A, B, and C. I'm not sure who to return all of…
-
Finding Average Depending on Warehouse
Hey Everyone, I am trying to make a card that finds the average of each warehouse depending on how quickly they unload a container. Then I will be giving them a "Grade" (A,B, C, D, F) depending on there average for the Year, Quarter, Month, and week. The thing that I am struggling to figure out is how can I have domo do an…
-
Return the value based on the most recent matching the criaterion
Hi all, please help to resolve the following issue. I Have a very huge dataset showing the following and I need to fill the column "Currency 2/ USD" with values: # Time; Cur 1; Cur 2; Pair; Price; Currency 2/USD 1 2:00 pm EUR ; USD; EUR/USD 1,165 1 2 5:00 pm EUR ; USD; EUR/USD 1,167 1 3 5:01 pm UAH ; EUR; UAH/EUR 0,032…