-
Are bulk uploads possible into a table section in form builder?
If you create a form with a table section, you still have the option to select bulk upload, but when you download the template it is blank. I considered creating my own template by finding the section IDs, Item IDs, section Names, and question Names in the output dataset of the form. I Realized a column would have to exist…
-
best way to replace a subset of data
I have a large historical dataset to which I append records at the end of each day. I have been asked to correct the distribution of values for a small subset of the data over the past nine months. I can use the data repair tool feature to remove all of the data imports for that time, but this would force me to destroy and…
-
'Year Over Year' Card Ahead of Available Data
Hello, I am pulling in sales data on a 4 day lag. I would like to plot data with year over year comparisons, but want the comparison period to match the data I have in the system, not the current date. Right now, my charts are comparing Sales Totals through May 8th (today) last year to only through May 4th this year (last…
-
Has anyone tried to create a Google Analytics path exploration chart in Domo?
Hi, I understand the Sankey chart can be used to depict flows. I'm curious if it's possible to replicate the path exploration report that's available in Google Analytics Exploration in Domo? I tried the one in Domo but am only able to map one from/to flow. It doesn't look like the Domo Sankey chart can drill down into more…
-
Certification with Group Ownership
Does anyone else notice an issue when you request something to be certified and it is owned by a group? I requested a dataset be certified and I am in the group that owns it. When I go to the certification center it shows I submitted the certification but gives me an error and does not give me the option to choose which…
-
Is there a way to mass update sharing settings for mutliple dataset?
Hi, I need to remove user & group access from 100+ datasets in Domo. Is there a way to do this en masse without clicking on the detail view for each dataset and managing sharing settings individually? Any tips would be much appreciated! On a separate note, I'm not sure why certain users & groups suddenly gain access to a…
-
GLOBAL on success/failure notification rather than each individual dataset
Just wanted to ask if there was a way to set a GLOBAL on failure notification in workbench? Rather than having to check off the box for the specific email on each individual dataset in workbench.
-
Retention period of the Activity Log
It looks like the Activity Log retains a rolling 12 months of data. Often for auditor requests we need to go back 18 months. Is it possible to increase the retention time within the audit log? Or is there a dataset that contains sharing activities? In our situation, auditors are looking at who gave access to information to…
-
Dataset refresh failure notifications
Is there a way to send the failure notifications to a group or group email? Currently Domo only allows to send the notifications to the owner. Is there an alternate solution to send the notifications to a group?
-
Card that will show if a Dataset has been updated
Hello DOMO - Good Day! I would like to know if it is possible to create a card that will show if a dataset has been updated? also, if it has been updated automatically or manually basically, a card that shows the dataset name, the date it ran, and if it is automatic or Manually ran. Thanks
-
how to remove duplications in data sets
We have data that gets appended to the data flow for historical purposes. How do we removed the duplication of the data due to appending. The column that would initiate the data remaining is "Date Uploaded". HELP. SPM
-
How would I pull the highest rate over the last 12 months in a beastmode?
In an effort to create a comparitive gauge chart looking at the current month's rate compared to the avg monthly rate over the last 12 months, the highest rate over the last 12 months and the lowest rate over the last 12 months. This is the beastmode I'm currently working with to attemp to get the max rate:…
-
How to purge data from an existing dataset via API?
Hello Domo experts, We are trying to find a way to use the API, or other non-UI approach, to purge all the data from any existing Domo dataset. A little background may help... Our company (Anonomatic) provides an add-on to Domo called PII Vault. What it enables is for Domo customers to get full Domo functionality but never…
-
Changing the email login for a user in SSO
I didn't see this anywhere but if so, just delete and please accept my apologies. If you have enabled SSO and run across a user that you've previously set up in Domo but in the idp they use a different email they won't sync to Domo. They'll come over as a new user vs just an authenticated user that you've already set up.
-
Creating drill down visuals without having to create a new data view
Hi, I am trying to create a drill-down visual for a bar graph in my dashboard but the fields I need to create the drill-down visual are in another table and when I either join the tables or replace the table for the drill-down visual when I hit save and close it asks me if I would like to create a new view. Wondering if…
-
Parsing Data Using Regex to Return Desired Values
I need to parse rows of data to extract a 3-4 letter code which is in all caps and create a new column containing those codes (RHL in this example) Inv RHL - Earn/Loss I can't use left/right functions because each account will have a different # of characters on each side of the code. Regex in replace text only allows you…
-
SUM(MAX() over (partition by))
For this dataset used, I have a list of appointments scheduled, there are closers tied to individual appointments and the closer's weekly scheduled appointment limit. So, where the user is showing for multiple appointments, their weekly scheduled appointment limit is repeated on those lines. The card I'm trying to create…
-
Removing banner from email
Hi Folks, Is it possible to remove the banner from the options when sending a dashboard via email? For example removing these details: All responses appreciated, Kind regards
-
How to calculate API usage by Salesforce Connector
If I bring in say one million rows of leads daily with 10 columns, how many API calls would it be?
-
Why does dataset views count as storage?
I've had this topic come up a lot but most recently with a a large renewal for this month. Client is asking for the technical reasons as to why dataset views count as part of their data row count - what is the response on this?
-
Why is a field not allowing me to exclude it?
I recently built a new field for my dataset in Excel that added certain employees into specific groups. Most employees are not in these groups, so when I joined that field to the rest of my dataset most of the fields are blank. This should be fine. However, when I add this field as a filter into any dashboards or charts,…
-
Lineage of a field
Hi in domo can you find the lineage of a field , as in all the data flows or data sets a field appears in .
-
How to calculate a % of line value from the grand total inside a table in domo card
I am trying to find the percentage of the cost of sales from the total cost of sales. I have used the following calculation in beast mode. (`Cost of Sales` / (SUM(`Cost of Sales`)) However, this calculation is not returning accurate values the lower cost of sales values have a higher percentage than the higher cost of…
-
Grouping data by month in table
Can someone advise on how I can create a table which groups the data so it is one month for each row? I tried Group by and it just formats the date column fields to the month-year. But continues to track each individual date separately.
-
Splitting up multiple-value fields into multiple rows
Hello, I have a dataset like this: ID Num 1 10 2 20, 30 3 40, 50, 60 I want to use Magic ETL to break these out so each row has one "Num": ID Num 1 10 2 20 2 30 3 40 3 50 3 60 Thank you
-
Views of Federated Snowflake Datasets
Last week, I created a federated connection to a table in Snowflake. I created a view off of that data set so that I could use it in Magic ETL etc. When I look back now, the view says last updated 7 days ago. There is no update button or update frequency for me to change. I want the view to be updated consistently as the…
-
Previous Months work
I'm running into an issue where I can get the amount of done work for last month but I need it to be shown this current month as previous months work to be able to calculate run rate. I have the correct code to get last months data. I'm using current date as a reference point so it's going backwards to look at last months…
-
I am trying to remove duplicates so that I only count the result of the last batch run
Hi can anyone tell me how to write the forumla for this? I tried to add a formula to the ETL but did not know what formula I would need as I wasnt successful with any I tried and I'm a novice! 😪
-
Reporting on a dataset e.g. duplicates, null values and data types
I was wondering if someone could help? I have a dataset containing 196 columns, I would like to know which of the columns are entirely null, which contains data, what level of duplication the field has and what type of data is in the field. There is a similar question here, but this is more about removing as opposed to…
-
How to get the time difference between completed and originated on 8 hour shift minus weekends