-
AVG() Beastmode Handling 0s?
Hi All, If have a dataset with duplicate IDs (required) and a metric - let's call it "total apples" against each ID (so also duplicated) The goal is to get the average of this meric but only considering the trend of distinct IDs overtime. I've labelled each distinct ID (using row_number over create date partition by id)…
-
CodeEngine: JSONDecodeError
Hi All, I'm looking to query datasets from within code engine (a similar function exists but avoiding calling codeengine within codeengine to use that function) def new_users(dataSetId="insert"): url = f"https://api.domo.com/v1/datasets/query/execute/{dataSetId}" body = {"sql": "SELECT * FROM 'table_name'"} response =…
-
Joins: Automatic Identification of Relationship Direction
Please add: Automatic identification of relationship direction within a Join tile. An option to amend this relationship direction (where appropriate) within the Join tile. E.G A drop-down with 1-2-1,1-2-Many, Many-2-1, Many-2-Many (inc warning) e.t.c A visible representation of this relationship direction with ERD arrows…
-
Workflows Form Error: Assignee does not have update content access to queue
Hi Team, I'm sending a form to a user and this error was returned. I can't find a function that grants access to the user (dynamically) to access the queue . The flow is as follows: This is the second half of a loop over dataframe template flow.
-
Barchart elements not visible
Hi All, The bar chart above has all font on largest, why is it fomatting like this and how can I get it more like this: (Wrt the font size and bar length.) P.S I don't mind a scroll.
-
shareCardWithPerson [Invalid type: expected NUMBER. (Expected non-null value)]
POSTMAN: ACCESS_TOKEN obtained: POST: https://api.domo.com/oauth/token data = { "grant_type": "client_credentials", "scope": "data" # "data dashboard workflow user" }, auth = {CLIENT_ID,CLIENT_SECRET} CodeEngine Called: POST: url:…
-
sendEmail Function via API
Hi Team. I'm using this method: With the below details from postman (replaced inputs{} for this question) ``` POST https://{company}.domo.com/api/codeengine/v2/packages/{package_id_found_in_url}/versions/{version_integers}/functions/sendEmail Authorization: Token (generated via Admin > Access Tokens) body (JSON) {…
-
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"
-
Database Management View Instead of Datasets/ETLs view
Currently users view their assets in a list in the Data tab. They have to use naming conventions, or tags to group these assets and the same goes for ETLs. The list can be filtered and includes shared assets by default but regardless it quickly becomes a mess that only encourages redundant asset creation due to low…
-
Capture Metadata From CourseBuilder Apps
The ability to capture user engagement from CourseBuilder Apps would complete this feature. OOTB the feature is too limited for effectively delivering Enterprise training now that the Google Analytics option has changed.
-
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.…
-
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:
-
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,