-
No undefined variables have been added to Variable list
Hi All, How do we dynamically add people to a group using variables returned from a query? This error comes up often, it's not super clear what it means but I've gathered it's when an action requires a fixed input. Same for "Email a Person" or "Shard a Card"
-
The ability to right-click on a Workflow
Currently, no option to right-click on a workflow to open in a new tab.
-
Workflows Custom Dataset Error
I get this error when attempting to add a Dataset from 'Custom' in a few actions. It will ask to choose the dataset. Once located, upon clicking 'Select' the screen will go to this message:
-
CourseBuilder Metadata
Hi All, I've built a coursebuilder app and published it, I would like to manage and track completion - it's for training documentation. I would access to a dataset that tells me who has view it, the completion % and any other interesting factors (dwell time etc). Ideally I don't want to venture into using Google Analytics.…
-
Are You Sure? Beastmode Safe Exit
After writing a Beastmode, I shouldn't be able to click outside of the dialog and have the beastmode completely scrapped. There should be a 'draft' option or a 'Are you sure you want to leave?' come on! This is basic UI stuff.
-
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,