Best Of
Re: How to build a card which show the latest-date data only?
I actually found a solution for this using ETL instead of SQL. I did a Rank and Window function on the Batch ID field, where I ranked the ID by descending order so that the latest batch will also have a rank of 1. Then I did a filter in the ETL to only show rows with a rank of 1 (you can do this filter with Beast Mode instead if necessary).
annelieu
Re: Historic Gas Price Datasets
I found these API calls as potential options for you:
https://collectapi.com/api/gasPrice/gas-prices-api/stateUsaPrice
https://collectapi.com/api/gasPrice/gas-prices-api/usaCitiesList
Re: Is there a way to retrieve or export cards data to csv using Domo API?
Make sure you're using the correct layout id. Also you may need to do a PUT request to the writelock endpoint (https://[INSTANCE].domo.com/api/content/v3/pages/layouts/[LAYOUT_ID]/writelock ) to establish a write lock before attempting to save your layout and then issue a DELETE request to the same writelock endpoint to release the writelock.
The JSON structure that is sent in the PUT request to save the actual layout is slightly different than what you get back from the GET request. You'll need to monitor network traffic to get the exact structure needed (right-click in the browser, select inspect element, then select the network tab. Click Save on the layout to see what request is being sent)
Re: Is there a way to retrieve or export cards data to csv using Domo API?
You can use the page layout API to get the definition and to also save the updated definition.
https://[INSTANCE].domo.com/api/content/v4/pages/layouts/[PAGEID]
use a GET request to get the definition and a PUT request (with the JSON definition as the body of your request) to save the updated definition
Note: This is not officially supported by Domo. Use at your own risk. If not done properly can completely break you page and cause it to fail to load. Also, these APIs can change at any time.
Re: Beastmode adding multiple different values from the same column
Hi @user048760
You can utilize a beast mode to conditionally add the values together with a CASE statement:
SUM(CASE WHEN `Marketing Channel` IN ('Yelp', 'Facebook', 'Google Ads') THEN `Value` ELSE 0 END)
Re: Domo and GitHub
Domo now offers a new product called "Sandbox" which does what you're looking for where you can promote pages to "production". You can talk with your CSM to get a demo of it. It is a premium feature so it'll be an extra charge. You can read more about it here: https://domohelp.domo.com/hc/en-us/articles/4403367344023-Domo-Sandbox
Re: Simple Beast Mode Failing on Federated Dataset
Hi @LCash
Just curious if you multiply your numerator and denominator by 1.0 to force them both to be decimals on the off chance that they were being treated as integers and doing integer division instead of decimal / float division.
(SUM(column1) * 1.0) / (COUNT(column2) * 1.0)
Re: How to add pivoted value to new columns by Magic ETL
Hi @eriena
it looks like you’re wanting to do a offset year over year. I’d recommend using a custom date dimension to calculate the values for the prior year or whatever offset you’re wanting. You can read more about how to do this here: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest
Re: Schema not keeping changes, but no error given - have you run into this?
Hi @AnaKS
This sounds like a bug with Workbench. I'd recommend logging an issue with Domo Support. In the interim you could utilize a dataset view to drop the column and rename another after you import it into Domo.