Best Of
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?
Re: How do I change my week to Mon - Sun and fix this report?
Since you are sending this every Monday, you can use this beast mode and put it in your filters and then filter to Include.
CASE when `date` >= DATE_SUB(CURRENT_DATE(), INTERVAL 14 day) and `date` < CURRENT_DATE() THEN 'Include' ELSE 'Exclude' END
You would need to change date in my example to the actual date field in your dataset. When filtered to Include, this will only show rows where the date is in the last 14 days and before today.
