ellibot Domo Employee

@brentsickmiller @ARosser @AsimBaig @CBrowne Apologies if you've already tried this, but have you tried to manually sync the collection using the API? I have a code engine function that does this, and I just tried it and it synced the collection to the dataset successfully. Could be worth a try? const codeengine =…

@ARosser have you looked at AppDB admin to make sure the sync is turned on? https://domo-support.domo.com/s/article/9221297758615?language=en_US

@SharonB_CF I believe Google Analytics actually samples the data if you pull using their reports api (which the domo connector uses): https://docs.cloud.google.com/looker/docs/studio/google-analytics-4-sampling To prevent sampling, you'll need to export your GA4 data to BigQuery:…

@JimChan I believe you can already accomplish this today using chart properties. Go to Grid lines > Zero line color and width.

@MackenzieConner when you say export, are you just wanting the visualization of the app component? Or the underlying data? Have you already tried the new report builder in app studio? I was able to get it to send me an app studio with an app component on it, but it was just the visualization.

@KandiKraner have you tried adjusting the app studio layout's mobile view? The mobile layout can be independent of the desktop layout. Here's a KB article on how to do this: https://www.domo.com/docs/s/article/1500010172542

@zacpolin as you've expertly outlined, there are a TON of ways to distribute data via Domo to external clients. If you don't already have your own web app/portal, the easiest way (in my humble opinion) is to create subscriber instances and publish the required data using a publication (here's a KB article on how to do…

@Sailaja_Lokasani if you're wanting to call an external API such as Grok, you'll need to use a Code Engine function as a proxy in order to avoid the CORS error. Here is documentation on building a code engine function: https://www.domo.com/docs/portal/Automate-Actions/Code-Engine/overview

@verytiredgirl I believe unioning is possible in dataset views, have you tried this route yet? It could require the advanced SQL editor. Full disclosure: I have not tried this but have heard others have been successful with it.

@mariobutler here's another discussion showing how to do this in app studio: https://community-forums.domo.com/main/discussion/66868/get-rid-of-filter-icons-in-app-studio-apps It definitely is a bit confusing since the interface is different from traditional dashboards.

@jamesj I believe this is actually already possible today using the Java CLI. This video walks through how you can do that: https://youtu.be/kHSeSbSFS1Q?si=UulS3Ct0MWAi97UC

This would be super helpful! Definitely agree there are many times where I would like the legend to be hidden on the app studio, but still showing if the user maximizes the card.

I also wish I lived in Chicago 😔

@verytiredgirl Flex tables can be tricky to configure, but once you have the formatting down, they are incredibly powerful! I think we have a few working examples of how to configure them in our community instance: https://domo-community.domo.com/page/96678585/kpis/details/2095209419 Feel free to send me a message if you…

Nicely done @GrantSmith! You continue to teach us thing year after year!

@Jbrorby you can actually run DomoStats connectors more frequently than daily. The easiest for me personally is to set up a quick workflow that has a timer trigger (for example hourly) and a single action called "Run Connector" which is a native Domo function.

@hayashida definitely agree that having an UPSERT connector would be great. Have you looked at leveraging NSAW for your use case? Using Domo's new cloud amplifier connection for NSAW, you can query live data from your NetSuite instance and it's extremely performant.

@KristinDavis BQ supports using wildcards in their SQL, so you can create a view on the BQ side that unions all the tables together. The SQL would look something like this: SELECT PARSE_DATE('%Y%m%d', event_date) AS date, COUNT(DISTINCT user_pseudo_id) AS total_users, COUNTIF(event_name = 'user_engagement') AS…

@James_Lord as far as I'm aware, you can only suppress public embed as a global setting in your instance.

https://us.v-cdn.net/6032830/uploads/Z5T4H1KOK63J/codeengine.txt @Martin_deLeón take a look at this markdown file. My understanding is that you alias the code engine function in the app manifest.

I will make sure to find you during one of the days, gotta make sure I meet the legendary @Data_Devon in person!

@SayyedHussain you can absolutely rank based on another column in the dataset, you would just adjust the order by clause. Rank needs a column to determine the ranking. In your screenshot, you could order by one of the value columns you have in the dataset.

@Data_Devon I’ve been loving the new report builder with app studio. I also find attaching an Excel export of the data that powers that dashboard can be extremely helpful for people who want to do some extra exploration. I know you can do that with the older scheduled reports, so I’m assuming it’s possible with report…

@James_Lord it might be an issue with whitelisting. When you look at your Domo Everywhere settings, are you listing specific domains that Domo can be embedded? https://{instance}.domo.com/admin/domo-everywhere/settings

@bingmitchell great callout. And you’re right, definitely a security concern to store client id/secret in plain text in the app. I would recommend looking at HubSpot’s secret manager: https://mpiresolutions.com/blog/how-do-use-hubspot-secret-api/ I haven’t done this in HubSpot before, but I have done this in Salesforce by…

@MarkSnodgrass @Sam_Donabedian @ArborRose @Data_Devon Thank you all! @GrantStowell Thanks so much for the shoutout! Absolutely love this community and couldn't be more excited to continue to contribute.

@Martin_deLeón totally understand that sentiment. In that case, I would suggest what @ArborRose has already said: send the form payload to an external service and then have that service call the Workflows product API. Domo Bricks and Pro code apps can call external services. Here's an example using an integration platform:…

@Martin_deLeón One potential workaround is using the new forms available in App Studio, and then have a workflow trigger off a dataset alert on the dataset that the form creates. From what I've seen, you can embed these kinds of forms publicly (whereas you can't with workflow forms). So the order would be: 1. Create form…

Thanks for the vote of confidence @MarkSnodgrass! Not sure I deserve it 😅 @random_user_098765 I don't have personal experience doing this, but I know @jaeW_at_Onyx has done some scripting to automate dashboard/card testing at scale. This YouTube video that he published might be helpful:…