-
Magic ETL Joins - include table name as prefix
Hi All, When joining tables in the MAGIC ETL, how do I include the table name as a prefix for the columns? Sometimes the 'Select Columns' transformation offers a rename suggestion in the format, 'TableName.ColumnName' but it is not always suggested and requires using the 'Select Columns' transformation before each join.…
-
Option to add prefix in Magic ETL Joins
The Pandas library and Power Query have this option, it's the option to add the table name as a prefix when joining tables. Huge benefits when working with system-generated datasets for example that can have 40+ columns with similar names in each table. The workarounds mentioned here don't quite cut it - if you're used to…
-
Beastmode not recognising exisisting column
Hi All, Two columns that have been added are not being recognised in the beastmode I've written, Please let me know if I'm missing something or if it's a bug. Kind regards
-
Magic ETL Dynamic Pivot
Hi All, Is this the only solution for dynamic pivoting? : https://domo-support.domo.com/s/article/360042923454?language=en_US Hoping for a simpler solution. Kind regards,
-
Filter is removing nulls plus specified value
Hi All, Question: I am using a Magic ETL filter with: level = 2 status = 'Blue' The filter is removing 'Null' values in the status field as well as the Blues. What's the potential cause here? Context: Both fields are string dtypes (abc) I've tried: level = 2 AND status <> blue -- in one formula status NOT IN('Blue')…
-
Change default "No data in filtered range domo" message
Hi All, Is there a method for customising the 'no data in filtered range' text? In some cases having 0 is a good thing so I want that to be reflected All support appreciated Kind regards,
-
Failed to parse text - Connector error
Hi All, I'm appending a dataset via a Smartsheet connector and the user has entered a string inside a date column. I'm now getting this error: How do I filter/replace these entries from within the connector? Kind regards,
-
Window function - unique ranking
Hi all, I'm trying to create the following logic for column '?' based on the header column: context header: the original column I want to rank against temp: a constant 1 for the row number logic row number: a row number ordered by temp ascending (recommended on the forum) header identifier: a conditional column using 'CASE…
-
Colour condition for words in a string
Hi Folks, Does anyone know how to create a beastmode that colour conditions each word in a string within a single cell for a table visual? For example: These values have to remain joined by the '/' delimiter so I won't simply separate them into columns. All responses appreciated Kind regards,
-
OData connector -- returns list of tables rather then data from tables
Hi folks, We have connected to an application DWH using the OData connector. In Domo this connector produces a list of the tables available but not the data from these tables. How do we get the data from specific tables? My frame of reference here is Power BI which displays a list of tables, once connected, to select and…
-
Fix colour rules across multiple datasets?
Hi There, Can we copy colour rules to a new data set instead of having to create a new set of rules? Generally, we use the same colour rules across various datasets, if these could be set to default against a similar field name it would be a HUGE benefit. For context, there are 3-6 repeated categories that require 3-5…
-
Splitting by delimiter vs LOCATE() function equivalent
Hi All, I want to fill the nulls in column A with the values in column B (or C if B is null). A case statement did not work here so I am aiming to achieve this by combining the columns and then separating them by delimiter. Unfortunately, by separating them we are - of course- back to square one. I was able to use this…
-
Compare data from two views of the same dataset, dynamically
Hi there, Context: I have a dataset with daily snapshots appended and it has one batch date field. Ideal: I would like users to be able to select two dates Date A and Date B to compare the snapshot view from both dates. Simple solution: Split the dataset into a Date A dataset and a Date B dataset in the ETL, create visuals…
-
Resizing text box glitch
Hi folks, While resizing a textbox in a dashboard the scroll glitches and sends me down to the bottom of the dashboard. When I scroll back up the textbox is huge. Each time I try to resize the visual, this happens. I've saved and edited it again but it continues and this has happened on two dashboards now, using blank text…
-
Header Labels on Pivot Chart
Hi All, Is there a way to remove the 'value' input label from the headers row of a pivot table? Thanks in advance
-
Date filter greyed out - multiple date columns in a table visual
Hi there, When I drag a second date column into a table visual, the date filter auto changes to match the new date column and greys out. It doesn't happen every time though so if someone can send the documentation or explain that would be appreciated. In this scenario, I am trying to bring a create date into the table…
-
Multiple measures in one card?
Hi All, Is there an option for inputting multiple fields into the Pie Name? My data is structured like this example: I would like to: 1) Show the % breakdown of Total Cleans by Clean Type on a Pie/Donut Chart (% examples seen below the table) The Pie name option offers one input:
-
How do beastmodes handle filter context?
Please can someone explain what happens under the hood when we slice beast modes (BMs) by dataset fields and/or when a filter is applied to BMs (categorical field filters/date filters) BMs using SUM() or COUNT( DISTINCT() ) when sliced or filtered don't behave as expected. (expectations being the issue). In one case, I had…
-
Colour Rules Across Dashboards
Possibility of copying colour rules to a new data set instead of having to create a new set of rules. On many occasions, we use the same colour rules across various datasets. These rules could be set against a similar field name. For some datasets there are 3-6 categories that require 3-5 different colours each, add in the…
-
Progress Bar - Exporting Datasets
Hi Team, 1) Large datasets are taking up to 60-90 seconds before an open dialog box appears. 2) Prior to this, there is no acknowledgment - encourages more export attempts. 3) A progress bar would communicate to users that the first export is being processed and will be completed shortly. Recommended share from support…
