Best Of
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
JSON Pagination with Response Header
I'm new to working with Domo and the data connectors, but I'm attempting to use the JSON No Code Connector to pull in data from an API. This connector has options for paging and to get the next page or URL from the results. However, this API returns the paging data in the headers. Are there any workarounds for this, or different connectors that offer the functionality to get the next page from the headers?