Best Of
Re: Dividing in SQL
Given the math you've put on the screen, there is no reason to run this ETL as a SQL transform. Just keep your data unaggregated.
Be careful with
Sum(`Early to Lost`+`Early to Won`+`Early to Late`) AS 'Total Low to High'
for any row, if any column contains the value null, the entire result will be null. this is the appropriate adjustment.
Sum(ifnull(`Early to Lost`,0) +ifnull(`Early to Won`,0)+ifnull(`Early to Late`,0) ) AS 'Total Low to High'
to do the division you're describing, just calculate the ratio in a beast mode (you may have to build the beast mode in analyzer, then share it to the dataset in order to reference it in a sumo card.
Personally i recommend you don't use the Sumo card and just use the Pivot Table card in Analyzer.
Re: Calculation of a row value by the Grand total for that selection
What you're describing is a window function. If you abstract your problem and google "percent of total" SQL, you'll find loads of solutions.
You'll have to ask your CSM or support to enable "Window functions in Analyzer" but after that
sum(sum(hours_worked)) over () will give you the 56
Re: Duplicate rows on Workfront Advanced Project report set for Replace updates
The rows are greyed out because domo has archived off those executions so you can't restore from those versions.
Re: User Profile fields only manual?
+1 for the APIs. They are great for automating some tasks like this.
Personally, I've used the PyDomo package and a python script to interface with the Domo API to update the user attributes.
Re: Jupyter workspace
Hi John (@Jobur )
Jupyter workspace is all self contained within the Domo environment. You don't need to have anything installed locally.
If you want to do your analysis locally you could get python / jupyter installed on your local machine and then utilize the pydomo package to pull data from Domo as well.
Domo cards are great for getting quick looks at your data and Dataset Views (in beta, talk with your CSM to get it enabled) are good as well to get simple aggregate views of your data as well.
Re: "Failed to start data processing engine"
Hi @eric_tetik
You'd want to reach out to Domo support as it's an issue behind the scenes on their end and they'd be able to get you a better understanding of what the issue is since they have access to those logs.
Re: Tooltip text in a card
Hi @user01061
You can't dynamically set a column header in a table card. You can use a column's value as tooltip text which you can then use the tooltip macro in the hover text or data value properties but the actual column names can't be changed dynamically.
Re: Custom User|Edit Page Grant
I appreciate that it is a little jarring to have 'read only' users be able to see a section called 'Admin.' But it's just a name. In terms of actions, the stuff they can do is very limited, and they'll only see content that has been shared with them.
The Admin section is actually a really great way to see 'all the stuff that's shared with me.' -- so if you want to direct users around Domo with other tools, I recommend you consider setting up a landing page with compelling navigation (can be accomplished with Domo Stats and Governance datasets).
Re: Custom User|Edit Page Grant
@Culper_Jr ask your CSM.
But also, I recommend you frame your question differently. Instead of "why can i see X in the admin section", reframe it as "i want to limit this behavior." You can't change the UI / UX, but you can alter what actions people can perform.
So ... what actions do you want to control?
Also if you don't want people to be able to edit a page you can Lock it.
Re: In a table card can I use a value to color code a cell?
use HTML wrapped in a CASE statement.
CASE WHEN True then CONCAT( '<Div style ... >'...
Note only works with HTML table cards not Mega Tables (therefore will not scroll).