Best Of
Re: Adding values to a custom chart
Hi Mark,
Thanks for your response - I've been watching a lot of the content you have put out on custom charts on behalf of DOMO with this, so I appreciate your time and want to thank you for your help with SVG files and the custom chart format.
Unfortunately, the Risk Heatmap card suffers from the same problem as any other table where if you want to use a custom sort through a beast mode, any cells with 0 values will not be captured and sorted correctly, leading to the categories being out of order, (unless I'm missing a trick?).
The other issue with the risk heatmap is that as it's a gradiated colour pallet, the set cells that need to be a specific colour cannot be coloured correctly. Part of the work we will be doing in other graphs is trending the time-series of the count of each colour bucket to differentiate severity visually. So the set colour per cell is, unfortunately, crucial for the story we are looking to tell.
Samuel.
Re: Update to Grants!
To add to this, I want to be able to restrict users from creating scheduled reports, but still allow them to export the dashboard, or dataset, or print.
At the very least, I would love to see 'create scheduled reports' be completely separate grant from 'exporting'.
Even more so, as it appears basic participants can add users or groups who shouldn't have access due to PDP via the scheduled report feature.
Re: Highlight alternating sections of rows on a table (to differentiate based on a single column)
You can utilize the DENSE_RANK window function and a MOD function to calculate alternating lines and then conditionally set your row coloring. MOD will return either 0 or 1 depending if it's even or odd to allow you to identify alternating rows.
MOD(DENSE_RANK() OVER (ORDER BY MAX(`User Pseudo ID`)), 2)
Sort your table based on the Pseudo ID as well.
Re: Highlight alternating sections of rows on a table (to differentiate based on a single column)
Hi @NathanDorsch ,
Not the best solution, but I hope this helps: https://www.loom.com/share/cd0cfd29478d441d923623714dfad678
John Le
You're only one dashboard away.
More video solutions at: https://www.dashboarddudes.com/pantry
Re: Update Domo Magic ETLs via API/DomoCLI
Currently there isn't a publicly facing supported API which would allow you to programmatically edit a Magic ETL. You could inspect the network traffic as you're editing and saving the API and attempt to replicate it
Re: Newbie23
And if it's the case that you'd need to have filters applied, then yes using beast mode is recommended but initially posed using magic ETL for the calculation due to better processing/rendering of a dashboard page.
amehdad
Re: Newbie23
Hi @amehdad I think you meant Left Outer Join instead of Inner Join. Rest the solution looks good.
Another thing, the formula is a fraction, so I think calculating it on the front end might be a better solution.
As the formula might resolve to sum(qty rejected) / sum(qty received) and trying to do it in the ETL might lead to sum of fractions which might be incorrect. Just thinking out loud, pls correct if wrong.
Thanks
