-
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`…
-
Return data within geographical radius?
I have a table containing a list of zipcodes and corresponding data. Say a salesperson unfamiliar with SQL wanted an elegant user-friendly interface to return all rows within a 5 mile radius of a given zipcode. Is there a way to implement geographical data like this? Or perhaps a free Domo app that can integrate this…
-
Moving one column under another
I have a table with 5 columns: column 1 is an ID, columns 2 and 4 are codes, and 3 and 5 are corresponding names. I need all the codes in one column, and all the names in one column. These means each ID will now have 2 rows, one for each code/name. How would I go about moving data from one column to another in Magic ETL?
-
Maintaining header rows and columns when uploading dataset?
I have a table in excel which has both header columns and header rows. I want to build a dashboard so salespeople can pick which columns they want to display in the table to give to clients. When I upload the dataset to Domo, I select crosstab, but then all of my columns are lost and rows are duplicated for each column. Is…
-
Take large text input as field for filtering?
I have a slicer card to filter zip codes for a large data set. There is a search bar field for finding zip codes to filter by, but say I had a large list/string of zip codes and I wanted to select all of them for filtering. Is there a way to paste this list into a search field to filter them all, instead of selecting each…
-
ZIP code leading zeros being removed in dataset
I have a dataset and one of the columns is ZIP codes. The leading zeros are being removed when uploaded to DOMO. Any way to change the column's formatting or to prevent the zeros from being truncated?
