-
Trend line within Table
Hi folks, Please let me know if there is an option to add a trendline (based on a beast mode) for individual line items in a table. All help appreciated Kind regards,
-
ValueError: The truth value ...
Hi Folks, I'm having an issue with a Python tile in Magic ETL , the code works on my machine (pycharm) but throws an error once in Domo (this happens often, what's the difference?) ValueError: The truth value of an array with more than one element is ambiguous. Use a.any() or a.al The goal is to produce a string value…
-
Group By Filter for Dashboards
Hi Folks, Is there a way to add a 'Weekly' 'Monthly', or 'Quarterly' filter to a dashboard that would aggregate best modes accordingly (when written dynamically) within charts by those groups against a date field? The equivalent of the graph by feature in the analyzer: I want someone to be able to select weekly and see an…
-
Distinct List_Agg
Hi Folks, In Magic ETL, I'm grouping by a key and defining a new column using the formula: List_Agg(customer_name, ' / ') Is there a method to generate a distinct list of customer names by key? I don't want the repeat customer names in this value. All support appreciated Kind regards,
-
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
-
Horizontal center for a table card
Hi Folks, I would like the table on the right to be horizontally centered against the pie chart but due to the number of rows, this doesn't seem to be an option. Is there a method to achieve this? All support appreciated Kind regards,
-
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
-
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…
-
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…
-
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…
