Best Of

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

DashboardDude

1

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

GrantSmith

1

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

7

Re: Newbie23

Thanks Aditya, I did mean Left Outer Join

amehdad

7

Re: Newbie23

https://dojo.domo.com/main/discussion/comment/62048#Comment_62048

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

Aditya_Jain

1

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?

user013857

1