ArborRose Coach

Not really….except that you might have a NULL or zero denominator. What I do is stick a DEBUG output tile into the flow. After your GroupBy tile, branch off to the side an output tile and give it a name like DEBUG1. Run the process and check the data in the DEBUG1 output dataset. Review your values for Total Expenses and…

We can't see the end of the formula. SUM(CASE WHEN condition THEN value ELSE value END) So it would be SUM(CASE WHEN `Account` IN ('EE Salaries and Benefits', 'OD Salaries and Benefits', 'Supplies') THEN `Amount` ELSE 0 END) Without the THEN value in there, there is nothing for the SUM() to act on.

Aggregations (Group By) are essential. You are grouping "like" things to sum them up, count them, average, etc. Consider a sample: Salesperson Region Amount Alice East 100 Bob West 200 Alice East 150 Bob West 300 Now you want to know how much each salesperson sold in total. Aggregation means doing math across rows — like…

SUM() is an aggregation function and the Magic ETL formula tiles don't have the ability to compute it across rows unless they are grouped. Group your data Use a Group By tile to aggregate: Net Revenue → SUM(Value) where Account is in Gross Revenue, Other RevenueTotal Expenses → SUM(Value) where Account is in your expense…

Here are the Domo Support Reference : https://domo-support.domo.com/s/article/360042934574?language=en_US …and one of the Community Forum Posts for references: https://community-forums.domo.com/main/discussion/57717/documentation-on-activity-log-event-action-definitions VIEWED Definition: A user opened or clicked into a…

If you get hit by that bus, or "milk truck" as I like to say…(oh dear I am old. Do they still have milk trucks?)…Condolences. Make sure your colleagues are signed up to post here on the forum.

Durable Sharing Setup for Domo Publications Create two groups: All (default group, gets all datasets) Small (subscribers, gets dashboards only) Publish datasets: Create a publication containing only datasets Share this publication to All Publish dashboards: Create a publication containing only dashboards Share this…

If users can see data but aren’t allowed to use or share it, they’ll often end up recreating or duplicating that data elsewhere just to keep working — which ultimately causes bigger governance problems. For me, the key is that the root dataset must be trusted, protected, and unchangeable — but once it’s available, users…

I don't do a lot of workflows, so this a bit of theory. Upload your file (CSV, Excel, whatever). Then based on your comments, parse the file and transform the rows into delimited format using JavaScript/Python, converting them with a code block into a delimited string and store the result to a variable. JavaScript: let…

It means the assistant couldn't figure out what you want, specifically. Perhaps your question is too vague. "give me count of Miami location" The assistant may not know what Miami location refers to - is it a column name, a filter, or a label? Try changing the input "input": "What is the count of rows where location =…

Biggest Data Horror Story I can think of two. I was the sole author of an order system for a major company that supplies point-of-sale to restaurants. I accidently deleted the user table. When I saw the system message my heart sank. I'm pretty sure it skipped a couple beats. I managed to get the table rebuilt quickly and…

Thanks for the thoughtful questions. My main goal with a “view-only” permission is to let users safely inspect and use datasets without any ability to modify or delete them. They should be able to explore and analyze data, and build Cards or Dataset Views, but not make any changes to the dataset itself. I’m less concerned…

Hizzah! Glad to hear it.

Thanks, that means a lot — but honestly, I’m just doing my part. The real credit goes to those who set the bar long before I got here. I'm not concerned about always having the ‘right’ answer or posting my own questions — the aim is to be helpful or get help. If it leads to a solution, adds insight, or sparks discussion,…

Hmm…its been more than a decade since I touched SalesForce and Apex. Try this code for a button, which does not use an iframe and opens a new tab: <apex:page standardController="Account"><script> window.open(…

Congratulations @erikjamesmason!

Apparently the Chrome 142 patch was introduced to combat a lot of security vulnerabilities. One article mentioned it blocking public websites like Salesforce or Domo from initiating requests to private IP address such as 192, 10.x.x.x. Your history, cache, and cookies aren't the issue. It's apparently something related to…

To restrict dataset and card access to specific users and selected admins—you could try using Personalized Data Permissions (PDP) combined with a custom role and sharing. PDP would allow you to filter the dataset access by user or group, and the custom role would let you limit admin privileges by removing “Manage Datasets”…

I think you need to make the workflow trigger an action like a dataset update. I don't think it can response back to the brick / app directly. I think that bricks and pro code apps run in some type of client side host or sandbox. And the behavior is to assure security to the Domo APIs. The API would be secured with OAuth…

After creating what I think is a sample csv file, I've modified the code to this: import pandas as pd import re # 1 Read raw CSV as text lines with open(r'C:\Users\username\Projects\raw_events.csv', 'r', encoding='utf-8') as f: raw_lines = [line.strip() for line in f.readlines() if line.strip()] # 2 Group lines into…

You can create an ETL that starts by splitting each comma-separated value into columns (Split Column). That would give you each label/value in it own column but not aligned. You would have to iterate over all the columns to find the patterns. Label: Value —> Label and Value. With Label: in one column and value in the next…

[Edit] I've reviewed code that I have tested and modified to different variations. It doesn't appear that looking at the API directly provides the values needed to show which datasets will produce the warning. I thought we could use the lastUsed value…but that does not appear to be updated for every type of query. I tried…

You are showing us the name of the ETL, but not the flow itself. Assuming this is a Magic ETL. Can you confirm there is an output tile that was given a proper name for the dataset? If its not a Magic ETL, a SQL tile should have an output dataset. Is there anything special about the workspaces used?

I can't find any reference to whether child properties can be set to NULL. The documentation says you can have multiple child properties but it does not say whether NULL can be set. The system will probably treat it as undefined. It may be ignored or raise a validation error.…

There is a SQL connector that gives the ability to pull SQL tables or views into Domo. Migrating the stored procedures as ETLs would be more difficult and probably require manual translation.

You can create a beast mode formula to convert month wording or abbreviations into datetime, or into month numbers. When I create ETLs, I typically have a value for numeric month such as month(`transaction_date`) and the alphabetic monthname such as monthname(`transaction_date1). I use the wording for display and the…

UNIX_TIMESTAMP() in Domo converts a date-and-time value (like "2024-11-04 15:26:00") into the number of seconds since January 1, 1970 00:00 UTC — a continuous numeric timestamp. We use it because Domo can’t directly subtract two datetime fields and get a difference in seconds. By turning both Created Time and Responded…

Here's what I came up with. Starting with sample data. ID Created Time Responded Time 1 2024-11-04 15:26:00 2024-11-05 08:11:00 2 2024-11-05 10:15:00 2024-11-05 16:45:00 3 2024-11-06 08:50:00 2024-11-06 17:10:00 4 2024-11-07 14:30:00 2024-11-08 11:20:00 5 2024-11-09 09:00:00 2024-11-11 12:00:00 6 2024-11-10 16:00:00…

Here's Python code (use in Domo Jupyter Workspace), to loop through the dataflow ids, extract JSON, and stores to csv. Modify if you want to store to a Domo dataset. End result of this code is shown below: # -------------------------------------------------------------------------------- # Author : Arbor Rose # Date :…

import os import requests from getpass import getpass import json import sys DOMO_INSTANCE = os.getenv("DOMO_INSTANCE", "YOUR_INSTANCE") # <-- set this or export DOMO_INSTANCE DATAFLOW_ID = "PUT_YOUR_DATAFLOW_ID_HERE" # <-- Replace with a real dataflow id (uuid-ish string) # Token: either set DOMO_DEV_TOKEN env var or…