-
Can you filter data from input dataset in a MySQL Flow
Hello, I have a dataset that has data for the past 20 fiscal years. I use it in a flow that only looks at the last two fiscal years and when the flow runs it takes a good 10-20 minutes just to read the data in the dataset and then start transforming it. I was thinking of expediting the loading process by pre-filtering the…
-
Writing Beast mode with Data label of Measures
Hi All, I have three measures - Open qty, onhandunits and openpoqty... When they are brought into the table in visualizer they are brought in as sum(Open qty) , sum(onhandunits ) and sum(openpoqty) and then given different data label names Now I am trying to create a filter using the condition case when sum(open qty)>…
-
Group By -- all additional columns
I have a data set that looks something like this: Rep Name --- Department --- Month 1 --- Month 2 --- Month 3 etc. I want to do a 'group by' as some reps appear on multiple rows and I want to sum the Month total for those reps. That part is easy. Is there a way to automate that all future months added also get that…
-
Can someone help me calculate employee turnover in Domo?
I'm relatively new to Domo and wanted to reach out to you about calculating Employee Turnover rate. I saw a previous thread (https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Turnover-Calculation-Beast-Mode-Help/td-p/31638) but wanted to see if someone could give me some tips on this specifically. I'm looking to get our…
-
Combining Row Data
Hi everyone! I've asked this question before and was advised to use a pivot table to combine two rows into one, but that would create new columns which I don't want so I'm going to see if anyone else has a solution. I have a dataset that I built that tracks activity by students at a University and I need to combine two…
-
Information missing after Join Data
I have a report just under 3,000 rows. (Left Table) I have a master list with just over 20,000 rows. (Right Table) I'm applying a filter to narrow down the master list and then using Left Outer Join Data to pull matching criteria using an email address as my join key. Unfortunately I'm not getting all data from the master…
-
PDP Settings - Is there a limit to the number of columns associated with one policy?
I'm working with a weird dataset/conditions, and wanted to associate 18 different columns and their values to one pdp policy. I made these policies using the standalone GUI utility https://domohelp.domo.com/hc/en-us/articles/360043439353-PDP-Policy-Autocreation. However, I'm getting weird errors. The PDP policy just isn't…
-
OR statements in card filtering
Hi folks - We have a dataset where users can have datapointA and datapointB. We want to build a card where an end user can have a filter that asks for any user has datapointA = 'green' OR 'databpointB = 'circle'. When we put those two datasets in a dataflow/card and add the datapoints as Quick Filters, it automatically…
-
Date_Format Fiscal week number and Year
Hi All, I am using the Graph by capability in DOMO Visualize and I want to get a filter to display WEEK 24 -2020 , WEEK 25- 2020 ......WEEK 17 -2022 in descending order I tried this DATE_FORMAT(`SHIP_DATE`,'%Y-%w') ....But its not correct..Can you please let me know how to go about this.. Thanks, ozarkram
-
Performing Calculations on Timestamps
Scenario: I need to calculate how much working hours time has passed between a creation date and a completion date. Parameter Exception: Item can be submitted after hours, but obviously that time wouldn't be counted until 7am the next day. Example timestamp: 2019-12-10T16:24:48Z Working hours: 7am to 8pm Working days: M-F…
-
Max number of columns in a dataset?
Hi, What is the maximum count of columns for a dataset? Thanks!
-
How to build a sales by state US Heat Map DOMO CARD Drillable into different vendors (US MAP)
Hi everyone, Just wanted to check if there is an article that will help build a sales by state heatmap for US States (on US MAP) drillable into vendors... Thanks, Arun
-
Beast Mode to remove values based on card selection?
Good afternoon, Is there a Beast Mode that can be written to exclude certain values from the broader data set based upon the option an end user selects on a page? Example: users can either choose AM or PM on my dashboard., which then alters the data on the rest of the page based on which they selected (the default is no…
-
Beast mode to show only one month
Have a dataset for fire drills we have several locations that run them every month i want to create a beast mode to only show me one month so i can duplicate it for each month to show one column per month to see who didn't run their drills month to month this is what i have but it is not working i will show you an idea of…
-
How do Dataflows impact Dataset Certification?
I'm exploring the option of implementing Card/Dataset Certification for our company. I need a better understanding of how a DF can impact the certification of a Dataset (DS). My basic understanding of DS Certification is that the certification will expire on the DS if there is a schema change (i.e. Columns deleted,…
-
Beast mode for count distinct by concatenating two columns
Hi All, I am trying to do the following beast mode operation: COUNT(DISTINCT (CASE when `ord_date` < CURDATE()-1 then CONCAT(`sales_no`,`part_no`) end )) The expectation is the distinct combination of sales_no and part_no ..But I am not getting that..Can you please help me here.. Thanks, Arun
-
Day of week Beast Mode Code
Hi All, I am trying to do the following calculation in Beast mode but I am getting some errors.. Can you please help me with this.. Case when Plant ='Celes' and dayofweek(orderdate) in (2,3,4,5) then '50' when Plant ='menes' and dayofweek(orderdate) in (2,3,4,5) then '90' end Would appreciate your input! Thanks, Arun
-
Generate Date Range Column from Two Date Columns
Hi all ! Im trying to generate a date column with a range of dates from two columns: Table I have (date format (mm/dd/yyyy) ) Id start_date end_date field1 1 01/01/2019 07/01/2019 text1 1 07/01/2019 12/01/2019 text2 2 01/01/2019 02/01/2019 text3 The idea is to generate a list of dates between start and end date with an…
-
String to Date
Hi I'm trying to convert a string to a date where the string shows "day Month", ie "30 Aug" or "23 Jul" (double quotes not included in the string). The string to date statement doesn't seem to work. Any ideas? Thx John
-
Domo Python error
i am using the python tile in domo magic etl i am trying to cast a column to a category but when i try and read the dataframe to the write_dataframe i get an error # Import the domomagic package into the script from domomagic import * # read data from inputs into a data frame raw = read_dataframe('Source 2') #print('Before…
-
DOMO acting SLOW!!!!!!!!!!!!!!!!!!
Is DOMO acting slow for anyone else? This morning, it has been crawling.... and I can barely get any of my dashboards to even load. And worse, I have a big training session later today to introduce over 50 people in my organization to DOMO. THIS IS NOT GOOD!
-
Python Tile Typecasting while Reading Data
A quick question in the magic ETL python Tile API method read_dataframe can you include the dtype parameter and use a datatype dictionary eg import pandas as pd import gc dtype_dic = {'%Account_Plan_Key':'category'} # Import the domomagic package into the script from domomagic import * pd.options.mode.chained_assignment =…
-
Deduplicating a table based on the content of certain columns
I have a dataset that has about 20 columns in it. The first column contains ID numbers and a lot of the ID numbers are duplicated multiple times. All the other data in the columns are also duplicated multiple times except one column named last_updated. The last_updated column lists a date. I would like to de-dupe this…
-
Help with Formula/ Beast mode to concat values based on unique key
Hi All, I am trying to write a beast mode formula from the input table below: to the output table Basically I am trying to group by pickno and then group the code R into the column Reason and the code S into the column shipinstruction (combining the names and the reason or shipping instruction).. Can you please help me…
-
Replacing single quote/apostrophe with nothing
I am trying to replace a single quote with nothing using the formula tile in Magic ETL, but it is giving me a syntax error. According to MySQL, you should be able to use a backslash as an escape character so that it will process correctly, but Domo is giving me an error. Any ideas?
-
Domo CLI - Return Limit for List-Dataflow Command?
when running list-dataflow --filename filename.json, I believe that the returned payload only contains 100 dataflows as a hard limit. There aren't args to pass that allow me to offset the object index. Has anybody encountered this problem and/or have a way to get all dataflows from Domo CLI
-
Calculated Field
Hi there - I am trying to add another constraint to a layered case statement but it does not seem to be working. The below calculated field sums total payment volume correctly - when I then add a filter onto my table for Payment Service = manual it sums the correct amount of manual payments. Sum(CASE when `type` =…
-
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…