ArborRose Coach

Comments

  • I don't think you can rename datasets in Domo Everywhere publishing. And I'm not familiar with any way to hide them. A good workaround might be to use a Magic ETL or data flow in the subscriber to create a renamed version of the dataset. You could apply PDP and keep a clean, user-friendly name without affecting your…
  • If your execution log is no longer updating, there are a couple of possible reasons: 1. Log Retention or Display Limits Domo doesn't appear to have officially published a specific size or time-based limit on Watchdog execution logs, but people have commented that: Logs may stop displaying updates after a certain volume of…
  • Tokens are domain specific. If your domain changed, you need to make sure you regenerate access and embed tokens for the new domain. And allowed domains are set. You say you created a new client and allowed domains are still set. Are you referring to the embed and settings for Domo Everywhere?
  • Those are a bunch of questions that should probably go to the AI Academy presenters or post in a specific thread. I'll say this - my mother said, "you can do anything". Mom wouldn't lie. There's always a way or a work-around. Forms can be done in workflow, pro-code, etc. And they can all interact. I came back from…
  • Private embed codes should be user-specific for authenticated embedding. When you use private embed, the code can be generated for specific users or sessions. So they may be different. If you use Domo Everywhere it should generate a single embed code that is universal. If you don't need the embed to be private, switch to…
  • Boolean sum depends upon whether you mean Boolean Summation as a logical "or". Using a formula like the following would give you the logic that if any one of the values is true the result is true. MAX(CASE WHEN `boolean_number` THEN 1 ELSE 0 END) Domo is not going to be able to do the summation on a string value. Try…
    in Sum True Comment by ArborRose May 14
  • I'm not sure Send Email can send an attachment that isn't hosted or via a URL. There may be limitations on sending binary or other form attachments using a workflow.
  • Interesting - a chart of survey responses that appear to be asking about AI. Um….how about using AI? If you haven't been viewing the sessions…on the black ribbon bar just below the main menu up top of this browser page, under the heading Community Forums, there is a link to past "event recordings". The Community Forum has…
  • Can't you just do the following? SUM(`your_boolean_column`)
    in Sum True Comment by ArborRose May 13
  • Here's an example. Using the following sample data id,word_list 1,"apple,banana,cherry" 2,"grape,orange" 3,"mango,peach,plum,kiwi" 4,"strawberry" I uploaded this as "Sample csv content". Then I build an ETL. In the split column tile: In the unpivot tile: My final dataset: If I had only one row, I would end with only one…
  • No, I don't think there's any easy default functionality. Maybe someone knows something I don't and can add to the discussion? Obviously I haven't tried for this specifically. But I have done this in a brick using the same concept. Using Magic ETL with an HTML table card, you could try to create a row based heatmap effect…
  • Log into Domo. Go to the Appstore on the top bar. Search for Snowflake Connector. Click add connector.
  • I'm having trouble understanding what you are trying to accomplish. It sounds like you want to use a form step to send a file attachment to the Send Email action. Have you considered using a link to the file instead of an attachment? Insert the URL as a variable in the body of the email.
  • I don't think you apply heatmap color formatting on row-level independent heatmaps (per row). By default, heatmap or conditional formatting in pivot tables would be applied across the entire column. :( You could try something using a Magic ETL and calculate row min/max or percentage. Then compute a color scale per cell…
  • I think there's a split column tile in Magic ETL. You could try creating an ETL, split column using comma as the delimiter. Then use an unpivot columns tile which would turn them into rows under one column.
  • The issue of blanks is a common on that normally comes from filtering or aggregate issues. I would try aggregating with something like SUM(CASE WHEN Rank = 1 THEN 1 ELSE 0 END)
  • Any row is changed only works if the existing row's value is updated. I believe you want to select "Any row is added or changed". This would catch new student or rows that were not previously flagged. Make sure the dataset updates regularly. Or manually trigger an update to test. You can try updating or adding a student…
  • I don't know any way to make the native chart scrollable in the direction you mention. You can limit the value axis by setting min and max. But that won't make it scrollable. You would need to find a work around like switching to a different chart type or recreating it in a brick. Or perhaps you could split the data into…
  • What kind of witchcraft is this? I never knew we had this ability. Bravo you two. I shall be investigating this.
  • Audit dependencies: We traced the alert triggers back to the source datasets and dataflows to check for refresh lag. In some cases, the alerts were firing before the data was fully refreshed. Re-sequencing scheduling: We adjusted the schedule of dataflows and alerts to ensure alerts only triggered after all dependent data…
  • Welcome to Domo. To create an alert for when any student's attendance drops below 80%, follow these steps: Go to your student dataset Click “Data” on the top menu bar. Locate and click on your student dataset. Access the Alerts tab Just under the main menu bar, you'll see a ribbon-style menu. Click the last option labeled…
  • Hizzah! Good to hear you got it working.
  • I don't have experience with the Office Add-in. I understand it needs defined Excel tables, not just raw data ranges. If Domo has headers and says it completed the upload, but there's no rows….that sounds like the data needs to be formatted as a table. In Excel: Select the entire dataset including headers. Go to the insert…
  • The error indicates the ds_update() method isn't being used correctly for large or incremental datasets. Domo's API expects part ids to be consecutive and well ordered. If PyDomo messages up the part numbering or the data is too large, the API rejects it. I like Grant's suggestion. Give it a try. If you need, you could try…
  • Domo's documentation on the Office Add-ins mentions a need to clear your Microsoft cache if you do not see data. Make sure your authentication token hasn't expired. Try logging out and sign back in to refresh the connection. If the add-in has an option for replace or append, you might try appending to see if there's…
  • I was so disappointed in Domo's SQL performance, I stopped using it. Any time SQL is mentioned in association with Domo, I throw up a little. You can break large queries into smaller transforms. And try to avoid large cross joins. But the performance is just not acceptable. Magic ETL is optimized for Domo's backend,…
  • I think that's a Domo UI limitation. When the app background setting updates, the page background also gets updated. This causes issues, especially when using images and fixed width layout. Instead of putting a background on the app, try using page settings to set an image by page.…
  • I'd suggest you watch the past few Community Forum AI sessions. They are one hour long, each. These are useful examples of working with workflows and they have given direct examples of using Send To Person email. On the black ribbon bar at the top of your Community Forum screen, there's a label "Community Forums".…
  • Reference: It sounds like the credentials are invalid. Verify the NOAA CDO token using the URL above. On this page, you can submit your email address to receive a API token. If you've registered before, the system will resend your existing token to your email. The token is limited in requests per second and per day. I…
  • Sounds like a win to me. Good job.