ArborRose Coach 
Comments
-
Depends upon whether you want seconds, minutes, hours, etc. DATEDIFF('second', `Created Time`, `Responded Time`) / 3600 DATEDIFF('minute', `Created Time`, `Responded Time`) For non-working hours, you probably need to consider Saturday or Sunday with something like DAYOFWEEK(`Created Time`) IN (1,7)
-
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…
-
Very nice. Give the man a point. Here's python code to hit that endpoint. Note - a single data flow as described in that curl. Domo instance value would be the company name that appears before ".domo.com". In my example output I am calling dataflow id 564. # Domo Dataflow schedule fetcher for Domo Jupyter Workspaces #…
-
Just in case you ever want to try it out - a brick is just an html page with a stylesheet and JavaScript (search 'blank brick' in AppStore). You copy each code type (html, css, or JavaScript) into the provided sections. If you want the brick to interact with a dataset, you can change the sample datasets to point to your…
-
I submitted a request for scheduling information to be added - quite a while ago. I'd love to be able to automate a visual. I ended up creating a brick to plot a type of Gannt chart so I could visibly see when things kick off. But it's a manual process of editing the values in the code: dataset name, type, and quarter…
-
@GrantSmith - I'd just to highlight (pun intended) what a useful calculation this is for setting an alternating row color. Thank you. Sorry, I can't click the "Accept as a solution" button.
-
I don't understand how these rumors get started. I look nothing like that guy.
-
If that does not work, I suggest reporting the issue to Domo Support. It doesn't sound like the AWS has affected this. There were Office updates in 2025 that could affect it. But that doesn't appear to be the issue if you were able to access just two days prior. Especially if you have uninstalled and reinstalled the add-in.
-
There was a massive AWS outage that affected many computer systems used by large corporations. It's possible that the outage was not on your company system, but may have affect systems along the route - including Domo. I had trouble getting into Domo's Jupyter workspace. Eventually, the issue resolved and I could access. I…
-
I don't think so. The actions that bypass cache would be hardcoded to ensure you have the most up-to-date data in critical operations like ETLs and views. Most connectors would prioritize data freshnesss to avoid inconsistencies.
-
Mom said, "anything is possible if you put your mind to it." Everything in your theory sounds doable. But I think Domo is working on a fix for the Executor function.
-
See this previous thread: https://community-forums.domo.com/main/discussion/comment/58093#Comment_58093
-
It's possible you hit a blind spot. The scheduling engine may accept and store the report but the UI might not be able to render it due to pagination or filtering issues. Submit a help ticket. You may be able to audit via admin tools. Check the scheduled reports section under Admin > Content > Scheduled Reports. It might…
-
Sounds like the pivot is complicating the process. Since every new brand means you have to edit the pivot values. What about a truly flat table? Instead of pivoting the brands to columns, use an html table and slicers. Retailer Brand Sales Attribute Target Nike 120000 Sportswear Walmart Dove 80000 Personal Care Costco…
-
I haven't reviewed the episode to follow along, but I see your approval form shows attachment : file. Is there an option to change attachment to image? If not, can it be used as a URL (UploadedImageURL) that hosts the image?
-
This is terrific Mark. In healthcare, we deal with standardizing things like medical codes, billing categories, and insurance company names. We see hundreds of ways people type out company names like Blue Cross and Blue Shield (e.g. BCBS, BC BS Medical, BCBS Dental). So I am interested in how others approach…
-
Person 1: What’s blue and goes ding-a-ling? Person 2: I don’t know. Person 1: A blue ding-a-ling! Person 1: What’s red and goes ding-a-ling? Person 2: A red ding-a-ling? Person 1: Nope… they only come in blue. In other words, I don't have a better answer then the one gave. Except with this happy face 😁. Maybe something…
-
I agree with @MarkSnodgrass. Some possible workarounds - Domo mobile app - apparently the mobile app does cache some recently viewed dashboards and cards. Use DomoStats - DataSets - includes metadata such as last updated timestamp for each dataset. DataFlows includes last run and status for ETL processes to give you…
-
I believe a repository is essentially a deployment package that tells which content to move between environments. If a single repository is shared for multiple dashboards, the entire repository is the deployable thing. Any time you add or remove, you'd have to reselect all the contents. If multiple dashboards depend on the…
-
Be careful about posting too much information to us. You should redact some of those values. I think the error is clear (at the bottom) - your account does not have the proper access to the workspace requested.
-
In Code Engine and Workflows, the account input type would be statically bound to the compiled execution. So the credentials would be to one account. I don't think you can dynamically switch at runtime. This isn’t a bug; it’s a security boundary in the Code Engine runtime. If there's a way, I'd love to see it.
-
Based on your comments, I would expect to leverage the Domo API. But I wouldn't expect the Python tile to handle anything like that. In Domo Magic ETL, the Python scripting tile must declare a static output schema. Domo enforces that so downstream tiles and datasets know the column structure ahead of time. Even if your…
-
It could be that the link briefly shows unfiltered data before applying filters, which would indicate a timing or permissions issue where Domo is fetching data before fully enforcing the permissions/filters for that user. If a user generating the link has broader dataset permission than other people, the initial data fetch…
-
Sorry, I included two 100's in there. Unencoded this would be CONCAT( '<a href="https://{yourinstance}.domo.com/page/0000000000?pfilters=[', '{"column":"Col1","dataType":"string","operand":"IN","values":["', `Col1`, '"]},', '{"column":"Col2","dataType":"string","operand":"IN","values":["', `Col2`, '"]},',…
-
I answered this is a different window. I believe this is a duplicate of the same question. Here's an example answering how to pass the variables with the UserID as a value of 100. CONCAT('<a href="https://{yourinstance}.domo.com/page/0000000000?pfilters='…
-
Somehow an issue on the forum lost the answer I posted. Re-summarizing in simple form. If you clear your browser cache and close all browser windows (so it closes any connected session), it will probably come back to you with fixed width or full screen as an option. Closing the browser will clear any open model dialog…
-
There's some trouble with duplications in the question posting. Re-answering this question. CONCAT('<a href="https://{yourinstance}.domo.com/page/0000000000?pfilters=' ,'%5B%7B%22column%22%3A%22group%22%2C%22dataType%22%3A%22string%22%2C%22operand%22%3A%22IN%22%2C%22values%22%3A%5B%22',`group`,'%22%5D%7D%2C'…
-
The preview only samples data. Such as the first thousand rows. The full ETL may hit limits or collisions the preview does not catch. New rows of data might contain a field that was previously clean and now has NULL or unexpected values. Check critical fields like dates, Ids, and numbers. Check case sensitivity (where…
