Best Of
Re: Displaying Zero Hires by Month for Different Segments in Line Charts
@lawiti Be sure to remove `Hires` from the Y-axis and `Segment` from the series. Line charts are set up to expect either one measure in the Y-Axis and one dimension in the Series OR multiple measures (one in the Y-axis and the others in Series). If you still have your segment in the series spot, it will not allow you to add more fields
Re: Text box is not populated by Beast Mode
You need a way to select a single value. This beastmode will have a result for every row of data. I used your same beastmode but limited the card to 1 row of data and then sorted on the date field descending and the card worked as expected. You may have to do some ranking in ETL because you need the most recent of 2 different dates. If you had rankings you could use that for your sorting. You could also just add MAX() functions in your beastmode if you just need the most recent of each date.
Re: How to bring certain data from one Table to another Table
@Ankur If you are joining on Country List and still getting more output rows than expected, then the Country List field is not unique. You will need to remove duplicates by the Country List field.
Re: Can DDX Bricks apps bring up blank outlook email?
@Morgan I believe mega tables are the only card type that works with HTML links.
I've also encountered this same issue when working with <a> tags in DDX Bricks (I usually just add a note at the bottom of the brick saying they'll need to right click and open in a new tab).
ellibot
Re: Is there any way to get Embed Id programmatically using DOMO APIs ?
I agree with @GrantSmith, I would probably inspect network traffic while changing the embed settings on a dashboard in Domo.
If you need help on inspecting network traffic in Domo, you can check out this tutorial:
ellibot
Re: How can I access Views using Google Big Query Service Account connector?
@dmurgit1 When working with the BigQuery Service Account connector, I usually just use the custom query report and then do 'SELECT * FROM MY_VIEW' as the query.
I'm not sure if the connector has a view report like the table report. I usually run my queries in GCP to make sure they run properly, then add the query to the connector settings in Domo.
ellibot
Re: How can I embed a website into my DOMO Dashboard? Not a hiperlink to open a new tab.
DDX Brick is the way!
Re: How can I embed a website into my DOMO Dashboard? Not a hiperlink to open a new tab.
@Ivan_Vineskills there's a brick in the AppStore called 'Brick with iFrame (Domo Status) that would be a great starting point for you!
ellibot
Re: Bulk scheduling for datasets
@ColemenWilson For only 50 datasets, it's probably not worth it to come up with a custom bulk scripting solution. If you find this is more of a persistent problem, yes you can definitely script against the undocumented [p]ublic APIs to change datasets to be manually updated (effectively disabling them)
You would need to send an API request to:
PUT https://{domo_instance}.com/api/data/v1/streams/{stream_id}
—data { "advancedScheduleJson": "{\"type\":\"MANUAL\",\"timezone\":\"UTC\"}"}
ellibot
Re: Need Tips for Optimizing Data Visualization in Domo
@rohan02, I always enjoyed this resource that Domo put out about choosing different chart types:
ellibot