-
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?
-
Display last dataset update datetime on a Story Page
I have a story page that I have given a limited view of for a specific user. This user uses the page for quick information and I'd like to let them know when the dataset was last updated without them having to go find the dataset and check the history. Does anyone know a quick way I can display that on the page? Maybe a…
-
GDPR - Search and Clean Datasets
Was wondering if anyone has come up with a good plan for handling GDPR in Domo? If requested, you may need to search and remove out the name of someone whom has requested the cleasne to be performed. Trying to plan for this in Domo, and wanted to see what others may have done? Thanks!
-
Is there a way to search multiple datasets to see if any are feeding specific data?
I want to see if any of my company's existing datasets include specific data that I would like to start tracking. I know when you open the dataset, you can see what columns of data are feeding, but is there a faster way to check multiple datasets rather than opening each one individually?
-
How to change the data labels in the legend and chart
I don't want the percent values on my pie chart and legend to have any decimals. In "General" I changed the Value Decimal Places and Percent Value Decimal Places to "None" but that only changed the hover labels. Is there a way to change the auto-generated percentages to only display whole numbers?