Best Of
Re: Pivot Table switch values to show as columns or rows
Agreed, I ran into this issue yesterday and was frustrated I couldn't do this. Great request @marcel_luthi!
Re: Pivot Table switch values to show as columns or rows
Any updates? This feature would be very beneficial.
Re: Need role and warehouse details used in accounts in domostats
@Malvika_Chauhan09 a current workaround for this is to create your own Domostats report like so:
ellibot
Re: Need role and warehouse details used in accounts in domostats
@Malvika_Chauhan09 I believe that data also resides in the JSON that is returned. Here's a screenshot I took from the video showing the specific warehouse:
ellibot
Re: How to pull Google Reviews data from various locations on Google Maps into Domo?
@kylemcmahon I don't think there's a connector for Google reviews, but it looks like you can pull reviews via Google's API:
ellibot
Re: Export Magic ETL Code for External Version Control
@MasonW you can also use the CLI to export the JSON definition of the dataflow using the 'list-dataflow' command. This could be automated through scripting if needed.
ellibot
Re: Datasets not accessed in a while
@NateBI @Ashleigh @MarkSnodgrass I believe there's a key stored on the dataset called 'cryostatus' that will tell you what state the data is in. 'Adrenaline' means it's ready for use; 'Vault' means it hasn't been accessed in a while (so you will see that message). You can get this info into a dataset using the JSON no code connector hitting this endpoint: https://{instance}.domo.com/api/data/v3/datasources/{datasetId}?includeAllDetails=true&includePrivate=true
You can also defrost a dataset programmatically using this endpoint:
https://{instance}.domo.com/api/data/ui/v3/datasources/{datasetId}/defrost
ellibot