-
Color Code a Beast mode column in the table
Hi All, I have a beast mode column by the name ( % Aloc on 3yr sale) which I have renamed in the table as (%3yrsale) and I have to highlight the values in the table to be orange or mild red...Can you please let me know how to go about the beast mode for the same..
-
Automatically export Dataset from Domo
Hello Domo comunity, We are looking for automatic dataset export from Domo to email. Is there an easy way to do that on a daily basis and what would be your suggestion to do that? Thank you in advance!
-
Is there a way to track who changed a dataflow?
I'm looking through the various DOMO - Dataflow datasets and I cannot find any field that indicates who last changed a dataflow. I know that you can look at the Versions Tab and see who modified it last but I'm trying to create a card that will display who and when a dataflow was last modified so I can look at all of my…
-
ETL Option to blank field
Im trying to get a field that has blank values to get data from another field is there another way of saying this formula? case when `company_name` = '' then `group_name` else `company_name` END somehow this is not working any other way of saying blank value in domo?
-
Help with Beast code to do color coding on the data..
Hi All, I am trying to do a color coding on two columns in my card (1 yr change % and 3 year change %) like below as in excel...Higher the percentage towards 100 and greater than 100 the brighter the red color and the lesser it is the lower the red shade and it should do it across two columns ...Can you please help me…
-
Formula cannot be added
Hello, I am a a beginner user on Domo (used before on Alteryx). I have tired to add formula the the canvas on Magic ETL , but it looks very funny and does not allow me to write a formula. It seems very silly thing, can you advice what I am missing here ? Please see the screenshot attached. Many thanks, Matan
-
Is there a way to auto-delete the data after a certain period of time?
-
Help with Magic ETL to find the status of SKU items manufactured
I have a delay table (as below) where a SKU is identified by the combination of mmodel and srno and the snapdate.. A SKU present on a specific snapdate indicates the SKU was delayed on that date Delay Table mmodel Srno Snapdate MX201 C12341 3/21/2021 NM213 L1234 3/21/2021 JK1231 K1561 3/21/2021 KL1234 MJ1234 3/21/2021…
-
Historic Timesheet Analysis
I'm working on an analysis of our historic timesheet data and trying to calculate our employee utilization (actual hours per day/8), so that we have a historic benchmark and can compare to projections for future utilization. The challenge I'm running into is actually cleaning the data. It's generally well-structured - in…
-
Case using Between with Text
Hello, I am trying to use the statement: CASE WHEN `START_ZONE` BETWEEN 'A' AND 'Z' THEN `PICKUP_TERMINAL` ELSE LEFT(`START_ZONE`,5) END However, it is not validating for me, what am I missing on this?
-
Dynamic Target Based on Current Date
Hello all, I am currently utilizing a gauge card with a target metric. What I would like to do is have the target be dynamic based on a date. For example, we have a different target for each quarter in our fiscal calendar. Depending on which quarter we are currently in, I would like the target to reflect the correct data.…
-
Help with Magic ETL to calculate the distinct count of pickup numbers by plant
Hi All, I am trying to get the distinct count of pickup numbers by plant and pickupmonth year..Please find my input table below...Can you please help me with the Magic ETL for the same...I am also attaching the excel file data.. Input pickdate picknumber Plant 1/3/2022 L009803 Seattle 1/3/2022 L009803 Seattle 1/3/2022…
-
Forecast monthly expense
I'm trying to create a formula within ETL that will help budget owners understand how their expenses will be accrued over time. Ex: There's one Purchase Order that has $10,000 left to invoice, and the PO end date is July 31,2022. Our accounting team would expense them evenly for $2,500 for April - July. So I'd need to…
-
Moving one column under another
I have a table with 5 columns: column 1 is an ID, columns 2 and 4 are codes, and 3 and 5 are corresponding names. I need all the codes in one column, and all the names in one column. These means each ID will now have 2 rows, one for each code/name. How would I go about moving data from one column to another in Magic ETL?
-
Sorting Year date Filter in Ascending order
Hi All, I have a beast mode created as CONCAT(YEAR(`pickupDATE`),'-',MONTHNAME(`pickupDATE`)) which in turn returns values such as 2020-April, 2020-june and so on...When I try to display this as a quick filter I get the values displayed in the quick filter in my card in random order -such as 2020-April 2020-August…
-
Magic ETL - Group By Tile - Sum Multiple Integer Columns
Hi all, I have a Magic ETL flow going currently where I have three input datasets that I am appending into one dataset. All three datasets have the similar fields and columns, but one of the datasets I need to manually SUM three individual columns across each row to get the "Total" count that exists in the other two…
-
Is it possible to calculate 6 months of data for a metric?
I am trying to collect Customer data Month over Month data for a metric that uses data from the past 6 months. For example - January 2022 would include customer data from July 2021 to January 2022 February 2022 would include customer data from August 2021 to February 2022 and so on.. Any help is appreciated! Thanks! Vik
-
Is there a way to share multiple datasets with someone at once?
In stead of doing it one by one?
-
CRM Sales Formula Help
Hi, I need help in creating a formula to write referral data to a new column. In the Dataset we have Columns A:C and I need to create a new Column D (Referred By) based on this logic: Where there are common engagement ID's (In this case 1234 or 5678) if 'inherited Sale' = True then set Referred By to Full Name. Thank you…
-
How can I get the data from several feeder cards to populate a master card?
Hello. I have built a page in DOMO that has several cards. Most of the cards are filter cards, but some display the data in tables based on the filters from their associated filter cards. There is also 1 master card that is supposed to accumulate all the data from the different table cards on the same page. I can get any…
-
How do I parse column data into separate row for each unique sets of values?
I have a Jira Dataset using the Jira Connector. The Sprint column contains a string of data like below. If a Jira story carries over from one sprint to another, the new sprint details are appended to the data string. Currently I am identifying stories in an 'Active' sprint by including records with %ACTIVE%. I would like…
-
How do I return a string column value from the MAX() of another column value?
Let's say I have the following: I want to group by the invoice # by dropping the SKU, returning the Product_Description of the MAX Product_Weight, and the SUM of the Product_Weight. With my given example I should return the following: I have tried in both Beast Mode and an ETL, but my Product_Description is never accurate.…
-
Dividing two integer columns that contain 0 values causing incorrect percentage value display (CTR)
Hi all, I've run into an "issue" where I can't seem to get Average/AVG values to calculate correctly when using a custom beast mode. My issue sounds similar to this issue here, where some rows contain a "0" or Null value that messes with the aggregation. When I try to replicate that solution I get another confusing /…
-
Calculating the count of entries not present in the future date in comparison to the previous date
Hi All, Hope you are doing well!...I am trying to build a magic etl for getting the number of entries (combination of sno and mmodel) that are not present in the current date of reference in comparison to the immediate previous date of reference...This will help understand the count of the number of entries that have gone…
-
Filling in blanks, based on next value
I have a dataset in which a User ID will be identified during a session.... and then later change User IDs... and in between, there are rows of data in which the User ID is not identified - but I want to fill in those gaps with the next User ID that is identified during that session... Row -- Session ID -- User ID --…
-
ETL or beast mode for Dynamic assignment of month based on current date
Hi All, Hope you are doing well..I am trying to convert a plan table as below into the table below based on the current date and the reference table Reference table: So I need to basically map the column names (FC1,FC2,FC3...input table) to fiscal month based on the current date and looking up the reference table for the…
-
Looking up values from secondary data source but for multiple columns in primary data source
So I'm having some trouble wrapping my head around a solution for this scenario in Magic ETL: -I have a primary data source with multiple columns where values are stored in shorthand like "hc_res" but I want to display reports with pretty names like "Healthcare Resources". The mapping of "hc_res" to "Healthcare Resource"…
-
How can i write this sql statement in domo?
where a.Customer NOT IN(select distinct Customer from CustomerSalesData where InvoiceDate < '2020-07-01') Statement below is a column I use for an sql query.. ROW_NUMBER() over(partition by a.Customer order by MIN(a.InvoiceDate)) as OrderNum I am getting an error while trying to convert this statement. I am not sure how to…
-
Variable Dates (User Defined) and Status Determination
Hello there. Hoping to find a solution to an issue I am trying to solve. Summary I have a series of time entry compliance dashboards. Data is pulled into Domo via the timesheet app connector. My dashboards highlight compliance, based on 7 hours a work day, categorizing into "Full" or "Partial" or "Zero" The solution I have…
-
Can Magic ETL calculate a sum over an entire column?
I hope I am missing something here. I want to simply run the equivalent of SELECT SUM(columnA) from TableB in Magic ETL. However, it seems the only way to do this sum is: 1) add a columnC to TableB where every row in columnC is the same value, and 2) do a Group By aggregating on columnC. Is there a better way in Magic ETL?