-
A way to see cards housed in app pages
Hello, I'm putting together an ETL where I can identify if a card is housed in a dashboard page or an app page. The domo stats 'Card Pages' dataset, has been great to see where cards are in dashboards, but I don't see that option for Apps. I've pulled the 'App Studio App Pages' dataset, however, it still isn't providing…
-
HTML Card | Background Color Style
I have an HTML Card that breaks down products by level. In my beast modes I have each level (0-6) set to a particular color as long as the number of accounts is > 0 otherwise it's set to a white background. My code seems to work for every level except for the first, 0, and I can't seem to figure out why. CASE WHEN…
-
HTML Card for Account Product Matrix
Hello, Back in March 24' I attended Domopalooza where a html card was utilized as matrix to measure domo account activity (picture attached). I would love to utilize a similar idea, but I am running into some issues. I have my ETL set where I have distinguished my levels to measure an account product matrix. I have been…
-
Python Scripting in Magic ETL | Iterating through close dates to get unique account id values
Hello! I'm trying to find the issue in my current python code that iterates through each date while maintaining a set of already logged accounts and then counting new accounts each day. I have sorted by the 'Close Date' , grouped by the 'Close Date' and the 'Owner Division', and have 'new accounts' and 'seen_accounts'…
-
Pulling Domo Data into R
Hello, Is it possible to use APIs to pull some Domo Account Data into a third-party R system? I'm assuming I would create a developer account and use the Account API?
-
Using regexp for pulling multiple values out a text string
Hello, I need some help pulling out email addresses from a text string. My goal is to place these multiple emails listed in the 'Description' column in a separate column, where they'll be separated by ','. Is there way for the search to end before the Sent Date info? Thank you!
-
Creating a Cumulative Concat Function on a Text Field
I currently have an ETL looking at distinct Opportunities by their close won day. However, this issue is now looking at Distinct accounts within the same dataset. At first, I thought to use the count distinct function on the account ID in a groupby. However, since multiple opps can be tied to one account and each one can…
