-
Legend includes colour rules
Hi folks, The legend on a link chart is including the rules set for the colours. How can this be removed to just show the label Thanks
-
Default Set Legend to EXCLUDE Colour rules
Referencing this: And this: Example: When you don't want to have to transform all your data just to make the legend work. The root issue here is the limitations of the colour rules.
-
Domo Buttons
Hi Team, Is there an option to add a button/or equivalent to a dashboard that when clicked, updates a dataset within Domo? The use case is for maintenance - clicking a dashboard/page button to validate it has been quality checked and the button can capture the username and time of check. Alternatively custom logic I may…
-
Identify Null Roll-Ups in a Pivot Chart
Hi Folks, Question: How do I identify blank values in a pivot chart? I want to filter where all values are blank against any column in a pivot chart but no option. I can't do it in the ETL either because it needs to be dynamic based on a date selection. (dates are the columns) Context I have the fields 'People', 'Dates',…
-
Text in Table Colour Rules
We have four options for text within the colour rules, it would be better to have full control over text colours. For example, I want a field to be Red when the text says 'Red' but I don't want to see the word 'Red'. Here, I could match the text colour with the cell colour in the rules and this would remove the word from…
-
Colour Markers on Line Chart
Hi Folks, We are able to use conditions to highlight an entire row in a table using colour rules, but how do we achieve this when we want to highlight specific markers in a line chart - using the same conditional logic? I'm building an SPC chart from scratch to include more control lines - the controls are conditional…
-
Rick Click To Open New Tab
The ability to right-click on a banner option: Workarounds: Right-clicking on the browser tab, selecting duplicate, then selecting the option. The workaround is an irritant because it's not in keeping with modern UX/UI practices.
-
Back Button Functionality
The back button from a dataset sends the user to the 'Data' tab. workaround: The back button from the browser (tested in Chrome) should behave as expected and send the user to the previous page they were on. Scenario: Selecting an ETL, clicking one of it's datasets to view the data. Selecting the Domo back button, only to…
-
Label ranked rows based on consecutive condition
Hi Folks I'm looking to label multiple rows but only when they consecutively reach 8 or more Rank criteria. I'm ordering the rank on the date, (magic ETL) and partitioning by rule2_hours. When the Rank reaches 8 or more, I want each row leading up to the highest number to be labeled - see the colour field. All feedback…
-
Dynamic Colour Rules | Line Chart Markers
The ability to reference a beast mode when setting colour rules so we can create line charts where the markers/line colours dynamically change based on a configured metric comparison. For example, Colour for [Field One] when < then [Variable/Beast mode One] | Red
-
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
-
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…
