Best Of
Re: Dataset Tags in Workflows Not accessible
@brycec so it is supported in Python as well, I was recommended it by Jace at Domo. I've created a ticket so all good, I'm pretty sure it's a bug.
NateBI
Re: Scheduled Report - Excel Attachement
@Jones01 That is correct. I am able to receive card-based scheduled reports as an .XLSX file, keeping all of the UTF-8 characters. I don't have an option to choose XLSX or CSV. It sends an XLSX file for all card-based scheduled reports.
Re: SQL Tile - not able to reference CTE name in itself when using recursion
You can use Domo’s Magic ETL to simulate recursion if your hierarchy isn't too deep or large.
- Filter rows where ManagerID IS NULL (top-level).
- Join the result to the hierarchy where ManagerID = EmployeeID.
Repeat the above as multiple steps (one per level).Append each level's result together. You’ll be limited by the maximum depth you hardcode in ETL.
Or, if you control source data, process outside Domo. And import the result into Domo.
Re: SQL Tile - not able to reference CTE name in itself when using recursion
I'm going to venture a guess and say you expecting too much from the SQL tile. When it was introduced to us, we were told it would have limits. Having the SQL tile reference itself isn't something I'd expect it to do.
Re: Storing Form Responses Based on Dropdown Selection in App Studio
To my knowledge, if you are wanting your app studio form to have cascading dropdown lists where dropdown list B will show options depending on what was selected in dropdown list A, (i.e. list A contains states, list B contains cities for only the state selected in list A), that is not currently possible in app studio forms. It was possible in the Form Builder app, so it is disappointing it has not made it over as a feature in app studio forms yet.
I would suggest creating it as an Ideas Exchange if it isn't already.
Re: Schema and Meta Select Tiles
Sorry for the delay, the Knowledge Base article is in progress and should be out soon.
Re: Schema and Meta Select Tiles
@ColemenWilson your answer helped and I was able to test and make it work. Thank you for your detailed explanation.
Having said that, I would really like Domo to provide more documentation and examples on how to use this. Hope they do it soon.
b_rad
Re: I need to convert the following beast mode to Group by
What about using FIXED? Something like
SUM(`served`) FIXED (BY `Physical County`, `CABINET`) /
NULLIF(SUM(`passed`) FIXED (BY `Physical County`, `CABINET`), 0) * 100
Re: App Studio share a specific page with a person or user not the entire app
Would love this feature sooner than later!
Re: App Studio share a specific page with a person or user not the entire app
Great idea @HelenOBrien would love to see an ETA assigned to this.
