ArborRose Coach

Can't you just do the following? SUM(`your_boolean_column`)

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.

You can save buttons and such within individual tabs in App Studio. There must be something else causing it not to save. Sometimes, the components don't properly "nest" inside the tab. Visually it might look correct, but technically they are not inside the tab container's hierarchy. Try re-placing it. If you dropped an…

Sure, you can use a Domo brick. A Domo brick is basically html code, css stylesheet, and JavaScript that works with you Domo data. You can create almost anything with a Domo brick. But I'm not familiar with any brick templates or anything pre-designed. If you have trouble, go to ChatGPT and ask it to help you code your…

I don't believe you can compare more than one using the card. The multi-value card only supports one target value. You could create a custom brick using html, css, javascript. Or use a table card with beast modes % Change vs LY: (SUM(`Income`) - SUM(`LY_Income`)) / SUM(`LY_Income`) % Change vs Budget: (SUM(`Income`) -…

March up the hall, bang on the door and tell those IT guys that Arbor said to give you the Domo office add-in. Could be security issue with that old legacy code and we don't want the company using insecure software code. And after you get access to it, come back here and tell us so we can all post a congratulatory "Hizzah…

I like using Domo bricks, but you could do it in App Studio. Create a couple datasets. Start with predefined options (dataset 1) such as Name, Category, Price, Description Sunroof, Exterior, 1200, Open air roof Leather Seats, 2100, Genuine leather fabric Alloy Wheels, Exterior, 1200, 18" alloy wheels Roof Rack, Exterior,…

The issue seems to be related to a failure in resolving the datasource ID for any dataset you're trying to use in your Jupyter workspace. datasource_id = _find_input_datasource_id(datasource) ... raise Exception(f'Input dataset with id or alias {datasource} missing or not configured for workspace.') This error indicates…

Using value fields you can put the information inside the gauge. I don't think you can control the text to put it outside the gauge unless you create your own card using a brick or use two cards.

Besides the parens, I see a dot where I should see a asterisk. (SUM(Impressions) / (Budget / DATEDIFF(`End Date`, `Start Date`) * DATEDIFF(CURDATE(), `Start Date`)) ) * 100