-
ETL error: "failed to convert value 'Infinity' from type 'Floating Decimal' to type 'Fixed Decimal'"
Hi, I have a magic ETL dataflow. It has 2 input sources. There's a formula tile where we calculate a pacing percentage. (`Delivered Impressions` / (`Campaign Flight` - `Days Remaining`)) / (`Total Goal` / `Campaign Flight`) We've been using this dataflow and formula without any issue for months and now we're getting this…
-
Recover a deleted dataflow
Hi, I was doing some cleanup and deleted some datasets that resulted in the deletion of a dataflow. Is there a way to recover deleted dataflows? I noticed a deleted dataflow could be recovered if you find a link to it: —but I can't find a link to the dataflow I need. Thanks.
-
Combining two datasets based on two potential fields
Hi, I have two datasets. One has pacing data, the other has monthly data. All rows have unique IDs, however the pacing data may have either an ID from the old system (legacy ID) or the new system (new ID). Pacing: ID 1 2 3 4 11 Monthly: New ID Legacy ID 10 1 11 12 13 2 14 3 15 How would I go about joining these two…
-
Removing duplicates
Hi, I need help coming up with logic for this problem. I have a dataset that looks like this: ID Source 1 A 1 A 1 B 1 B 2 A 3 B I want to only remove rows from source A IF that same row is also in source B. Otherwise I want to keep rows unique to source A and unique to source B. The output should look like this: ID Source…
-
Making variable values the same as another column
Hi, I have a table full of hundreds of advertiser names. I would like to select an advertiser name in a dropdown control, and in the pivot table below, censor all the advertiser names to 'xx' and only show the advertiser name that's selected. I have created a beast mode that does this but I have 2 issues: How can I make…
-
Display table card in multiple "columns"
Hi, I have a table card with lots of rows. I'd like to be able to display ALL of the data in the table neatly when exported to Powerpoint. Is there any way to get a single table card to display in multiple "columns" like below? Slide 1: Slide 2, 3…N would be the same format, displaying the rest of the data. Is this…
-
Display active filters in excel/csv export
Hi, when you apply filters to a dashboard and export as PDF/PPT, the selected filters will be displayed on the export. Is there any way to do this for exporting as excel/csv? For example I have a table that I filter by date using a calendar filter card. When I export the table I'd like a cell, header, or tab name to…
-
Drill down into table
Hi, I have a table and I'd like the ability to click on a field and open a new view that shows a more granular table. My table looks like this: Account | Dollars If a user clicks on an account in the table, it will drill down into a new table: Account | Media Outlet | Dollars How can I achieve this? Thank you.
-
See dashboard/card insights?
Hi, I want to be able to see stats and insights on who in our organization is accessing dashboards and interacting with cards. What's the easiest method, and can I set up some kind of dashboard that allows us to see these stats? Thank you.
-
Pivot table show only certain value under specific column
Hi, I have a pivot table with different media types as columns, and 2 types of values, instances and revenue. I only want to show sum of revenue under TV media type, and only sum of instances under Internet media type. Is this possible with one chart?
-
Filtering on multiple datasets / changing default dataset
Hi, I have a dashboard with multiple cards. Each of these cards pull from different datasets, however they share many common fields. This is helpful when using global filters. When adding a filter, I select the relevant field, and then select all datasets so all the cards will be affected by this filter. However, then when…
-
Joining 3 different datasets to match zip codes
Hi, I have 3 datasets each with a column containing zip codes. I want to use ETL to create a new dataset with 3 columns, all containing the zip codes from each input lined up. Input: Dataset 1 Dataset 2 Dataset 3 1 2 1 2 3 3 3 5 4 4 6 5 Output: D1 D2 D3 1 1 2 2 3 3 3 4 4 5 5 6 Thank you
-
ZIP code leading zeros being removed
I'm adding a dataset with a column for zip codes. The leading zeros are being removed when the data is uploaded, is there a way to prevent this/change the formatting for that column?
-
Disable Variable Control under certain condition?
Hi, I have a dataset that contains Final data and Preliminary data. Final data contains both 1st party and 3rd party delivery, but Prelim only has 1st party. We have a dashboard that visualizes this data with a single select slicer that filters by either Final or Prelim. I have a variable control on our dashboard that lets…
-
"Jump" button that scrolls to section of dashboard
Hello, I have a dashboard that has a hefty amount of cards that are organized into sections marked by headers/borders. Is there a feature in Domo that allows me to add a button that users can click to automatically scroll down to a section? And in the same vein, perhaps a "back to top of page" button? This would make…
-
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
-
Card filtering in analyzer
Hi, I have a table with null values in some columns. I want to show only the null values. When I filter in the null values in analyzer nothing shows up. Beast mode also doesn't work. Any ideas?
-
Toggle series in bar chart
Hi, I have a bar chart that has a goal as the y axis and then a current total as the series (as well as the difference between goal and total. We also have another field in the data that has a different calculation of the total. I was wondering if it is possible to have a card on the dashboard that allows us to toggle…
-
Roll up rows in table chart with similar fields
I have a dataset of brands and corresponding data. I would like to have any rows with the same ID and device to be summed up and in one row. I don't want to use ETL for this because there is another column that distinguishes these rows so they may need to be filtered separately at times. Thanks
-
Dropdown selector filter card not displaying all values
It's not that many, not sure why there not all populating. Thanks.
-
Converting string to date
Hi, I know there's a STR_TO_DATE function but maybe I could use more insight because it's not working. I have a date field that looks like this: 8-1-22 I want to convert this to a date. How can I achieve this with a ETL formula tile? Thank you.
-
Numbers disappearing on bar charts with small bars
Hi, I have a dashboard with a Grouped and Stacked bar chart. Oftentimes when one of the bars is very small, the data label disappears and only shows when hovering over the bar or legend. Default: Hover: Ideally the data labels need to appear by default. No matter how much fiddling around with the chart properties I do I…
-
Customize dashboard export?
Hi, is there any way to customize my PDF or PPT exports of my dashboard? I would like to remove the title of the dashboard from the top of every slide, as well as the filters at the bottom. Also, if there's any way to customize the first title slide that would be great. Thank you.
-
Formula for rounding time to nearest minute
Hi, I need to round times to the nearest minute. Not rounding up or down, but nearest minute. Any ideas on how to use formula ETL tile for this? Thanks!
-
Find greatest value for each specific ID
Hi, I have a dataset like this: ID Value 1 5 1 6 1 7 2 23 2 24 2 25 I want to write a ETL formula that creates a third column saying the greatest value for each ID is: ID Value Greatest 1 5 7 1 6 7 1 7 7 2 23 25 2 24 25 2 25 25 Thank you
-
Hide/filter out cards on dashboard display
Hi, I was wondering if there was a way to hide cards from a dashboard under certain circumstances. For example if the data being filtered was a certain value, a specific card would disappear. This will be for clients to export dashboards to PPT and not need to clean up superfluous elements. In a similar vein, I'm also…
-
Only show unique values of a column in table
Is there a way, in analyzer or ETL, where we can only display one row for each unique value of a column corresponding to a key column? For example, I would want this: ID Num 1 4 1 4 1 5 2 4 2 5 2 6 3 6 3 7 3 7 to become this: ID Num 1 4 1 5 2 4 2 5 2 6 3 6 3 7
-
Finding the sum of values based on a common column, excluding duplicates
I have a dataset with rows with IDs, start dates, end dates, and interval lengths. I want to find the sum of all the intervals for each ID, excluding duplicate intervals. There can be 2 rows with the same start and end dates so they can't be counted twice when summing (but I also cannot remove the duplicates). For example…
-
Using ETL formula for finding between dates
Hi, I have a dataset and every row has a date. I want to add a column using ETL that indicates what week that is (starting mondays). So for a row with 3/28/2022, the new column would have "week of 3/28" and for a row with 4/1/2022 it would also say "week of 3/28" since 3/28 was a Monday. A row with 4/5/2022 would say "week…
-
Filtering table -- cells can have multiple values
I have a dataset table with filters. Some cells have multiple values. Say I have a column called "Device." Row 1 can have "Desktop, mobile" and Row 2 can have "Desktop." I want to have a filter called "Desktop" that shows all rows containing any instance of "Desktop." When I do the beast mode formula: case when `Device`…
