-
Aggregating Rows
I have a dataset that breaks everything everything out by rows. any time there is a rental, or vacate it adds a value in to a new row with a siteID for a store. the data refreshes on a daily basis, so it site 3196 has 4 rentals in a day it would repeat site 3196 on 4 different rows with a value of 1 in the rental column…
-
Export very large dataset (million or row) in CSV as chunks
Is it possible in DOMO using python or postman to export whole dataset but break files(CSV/Excel) so we can have 5 million rows in each exported file.
-
Is it possible to use while/do loops in MySQL in Domo Dataflows?
I have data that has varying rows of data for each identifier, from one row to 26. For each identifier, I have four different columns that change with the various rows. For each new identifier, I want to loop through the rows that follow that have the same identifier and build the row out with the unique values in these…
-
Joining or Appending Data Help
I have a dataset (dataset 1) with individual rows as a specific job (with an identifier key) with details including year and country of operations. I have created cards to show the total number of jobs per year. I have another dataset (dataset 2) which shows historical revenue by Year and Country but it is not specific to…
-
Unique Values Pulling Through twice
I've used an excel upload method and I'm tidying up the dataset using Magic ETL. On one of my columns there is a value labelled "Test". For some reason it is pulling through as two unique values when it should only be one. I have tried to use 'replace text' but whatever I replace it with it pulls through again as two…
-
How can we use similar function as Vlookup??
I would like to offer a volume discount price for each company A, B, C and calculate total biil. There are 2 datasets like the below. When we sell 250 of Products to Company A in 2021 Feb (Dataset B), I would like to apply Price 4 USD on the price list for Company A (Dataset A). Then the total bill will be 1000 USD. If…
-
How to implement commands from the Command Line Interface Tool in Python, specifically api requests
Question: Is it possible to execute command line interface tool operations within Python, specifically the 'list-dataflow' command? Elaboration: The 'list-dataflow' command in the command line interface tool returns JSON structured metadata for a dataflow. My guess is that this command is just making a GET request to a…
-
Avoid BeasMode Duplication in Bulk Switching cards
Hello everyone I want to try Switching all cards powered by a DataSet in Domo. This dataset is a really important one which has around 5000 cards, and many of our important reports and beastmodes are there. So I don't want to mess it up!. I created an identical dataset with same column names and I read in Domo Knowledge…
-
Is there away to pull the Ticket updates dataset in Zendesk using any othe the Domo connectors?
I've been working with the Domo Zendesk Support and Zendesk Support Upsert connector with almost not problem to the the data I need with exception of the Ticket updates dateset (https://support.zendesk.com/hc/en-us/articles/360022182114-Metrics-and-attributes-for-Zendesk-Support#topic_sq4_mhq_4y). Has anyone had any luck…
-
General question on data from different datasets on the same card.
I have a card that is on a finished page. There is another metric that I want to add to a specific card that already has data displayed from a single dataset. This new metric is in a completely different different dataset that isn't attached to this page at all. Is there a way to pull in this metric to this card without…
-
How can I create a new column with extracted numbers in SQL or ETL
I have a column called 'description' which can contain multiple elements. One of them is 'Order #1234567890' (or other digits). I want to create a new column that just extracts the numbers in SQL or Magic ETL (so that I can do Beast Modes etc. on it afterwards). How can I create this column? Numbers may exist in other…
-
Exporting a dataset using script.
I want to connect to a dataset in my instance and download a dataset using a python script, how do I do it?
-
Import multiple files into single Dataset
Every day a new Excel file is dropped into a shared network folder. Every file is in the same format, and each file contains one day's data. Is there a way, using Workbench or any other method, to transport all Excel files from one local folder into a single Domo DataSet? Since a new file is added every day, every file…
-
Data Labels Font Color
I have some bar/column graphs that I would like to apply data labels with white font, instead of the default text color, for better visibility. Is there any way to do this? Thanks! Jamie H.
-
Magic ETL trigger timing - input datasets of varied size
I think I just discovered that if a magic ETL is configured to run "only when datasets are updated", and has multiple input datasets, it will start running as soon as the smallest/quicket input dataset has been updated. If a larger/slower input dataset finishes updating before the ETL finishes running, the ETL will not run…
-
Add a PoP % change data label to a Period over Period Chart?
Good afternoon, Is there a way to add the Year over Year percentage change to the data label in a Bar Line Period over Period chart? For example, in the screenshot below is there a way to add a second line so the data label reads something like:0 This year: 2020-Apr: 8,710,963 +71% Thanks!
-
YouTube Basic User Activity Date Inputs
For most Domo connectors, you have the choice of entering in relative dates (today-2) or a specific date (1/1/2020). For YouTube's Basic User Activity, it appears you can only enter in numbers of days ago. Does anyone have a solution for entering in static parameters? In my screenshot example, Videos Published After (Days…
-
Alert for Dataset - who triggered it
I am using alerts to track row addition, row updates and row deletions in a dataset. Works really well and an example of my alert is below. It accurately triggers and show that for the person Nunya, plan month January the column CVCNT was changed from 60 to 55 and CVDollar was unchanged. The alert does not say who…
-
Change Column Name in a Dataset
Hi Guys, Is there a way to change the column name in a dataset? I'm using Informatica to load in my datasets into Domo. I know you can create an ETL flow but the dilemma I'm facing is: I have a dataset (Dataset_A1) which had 4 columns, account | record | id | amount_given I created a dataflow to edit the column names &…
-
Dataset jobs not running on set schedule
I've been running into issues where Workbench is scheduled to run a job every morning at 6 AM, but when I open Workbench at 9 or 10 AM the job hasn't run and the status under the job name just shows "Next run scheduled for 6:00 AM". Has anyone run into this?