ArborRose Coach

That works. Thank you @GrantSmith .

Okay…I get it. Something like this Domo blank brick….

An app in App Studio is a compilation of cards with easy to use styles and "fanciness". Okay, I made up that word…fancy-ness. Some cards may be tables, charts, bricks, etc. The "forms" you see in the AppStore can be used to create cards, which can be added in App Studio.

I'm not sure if I understand the question. Does this help? Year Outcome Type Count 2023 Win Retain 50 2023 Win Capture 30 2023 Loss Retain 20 2023 Loss Capture 15 2024 Win Retain 60 2024 Win Capture 35 2024 Loss Retain 25 2024 Loss Capture 10 outcome and type: CONCAT(Outcome, ' - ', Type) retain: SUM(CASE WHEN `Type` =…

I guess you could say they don't talk well together. I would say FIXED BY isolates the situation for each so they don't "see" each other well.

Given your use case, where you need to handle a POST request with a dynamic body and interact with third-party services, you might want to explore a couple of alternatives: External Server Proxy: Set up an external server or service that can act as a middleman. Your external server can handle the API requests, including…

The requests library is a popular choice for making API calls in Python, and it’s what I would typically use in most environments. However, when working within Domo's Python script task, the standard library might be more limited. If requests isn't available directly in Domo, you can achieve similar functionality using the…

Is it possible your name is being interpreted to cause that space? As a gap between the start of the timeline and where your first task begins? Chart date range maybe too broad, encompassing more dates than where the tasks start? We can't see the actual dates associated to things like State of the Company Dashboard….so…

There's no way to save from the card. As you mention…you can create calculated fields…setup an ETL transformation that can replicate the logic of the card. The FIXED BY clause in Domo is part of the window function capabilities. It allows you to calculate metrics within specific partitions or groups in your dataset,…

Go to the Admin Settings: Click on the Admin tab in the top-right corner of the screen. If you don't see this, you might need to access it from the Settings menu or another admin area based on your Domo version and permissions. License Management: Look for an option related to License Management or Subscription. This area…

I was only introduced to using Python inside Jupyter Notebooks in the past few months. But it has worked well. Somewhere out there are demo pages and videos. Short and sweet - I go to "Data" and on the left side, there are three dots. Click there and you will find Jupyter Notebooks. Within your Python code you can edit,…

import requests def add_user(instance_token, domo_instance, new_user): url = f'https://{domo_instance}.domo.com/api/content/v3/users' headers = { 'x-domo-developer-token': instance_token, 'Content-Type': 'application/json' } # Example payload for the new user payload = { "name": new_user['name'], "email":…

I like @MarkSnodgrass suggestion. You could also use Python scripts using the imaplib, email, and os libraries to automate the download of attachments from emails. Alternatively, third-party tools could possibly automate the download process. Domo Workbench could probably do it, but you would need to handle the specifics…

I have not. But you could use Jupyter Notebooks and Python to establish connections to the APIs of the tools you've mentioned. Wiz - CSPM: import requests token = "your_api_token" headers = {"Authorization": f"Bearer {token}"} url = "https://api.wiz.io/your_endpoint" response = requests.get(url, headers=headers) data =…

The data is still uploaded to the cloud. Domo Workbench is a tool that allows you to connect to various data sources on your on-premise server. It pulls data from those sources and then uploads it to the Domo cloud environment for processing, visualization, and storage. Although the data originates from your on-premise…

I liked the JSON OAuth connector also, but dislike the speed. I found that using a different method with Jupyter notebooks and Python, I have more flexibility talking to my APIs and my speed is significantly faster.

Enthusiastic "yes".

1. Timing/Latency Issues with Input Datasets Problem: If the input datasets are updated by upstream processes (e.g., data imports, other ETLs, or connectors), there might be a timing issue where the ETL is triggered before these datasets are fully refreshed or populated. Solution: Adjust the schedule of your ETL to run…

Have you checked the dataflow schedule? Make sure the dataflow is scheduled to run regularly. Sometimes, the dataflow may not be set to refresh automatically, which would cause the input data to lag behind the source table. (Let us know if you need some assistance understanding how to check or setup the schedule.) Domo…

One way to do it might be to organized columns: Referer, January, February, March, April, May…. Create calculated fields for month to month changes. Such as CASE WHEN `February` > `January` THEN 1 WHEN `February` < `January` THEN -1 ELSE 0 END And create similar calculations fields for every month pair. Then set up…

The 401: Unauthorized error you're encountering typically points to an authentication issue. Expiration - The OAuth token used by the Domo GA4 connector may have expired. Insufficient permissions - The Google account used to authenticate with the GA4 API might not have sufficient permissions to access the requested data.…

I don't know the version, but it's this thread and Andrea's comments may answer your question. https://community-forums.domo.com/main/discussion/54244/get-mysql-on-latest-version

To transform your dataset, use Magic ETL. Setup selected columns. Add an Unpivot Tile. Drag the Unpivot Columns tile onto the canvas. Unpivot Columns: Select budget, forecast, and actuals. New Column for Key Names: Enter Category. New Column for Values: Enter Value. This will turn the three columns into two: Category and…

If you transform your dataset Category Value Type Budget 343 planned Budget 3432 carry-over Budget 123 unplanned Forecast 444 planned Forecast 4432 carry-over Forecast 145 unplanned Actuals 200 planned Actuals 3302 carry-over Actuals 80 unplanned Then create a stacked bar using category on the xaxis, value on the yaxis,…

from domomagic import * import pandas as pd # Reading the data from Domo input1 = read_dataframe('Existing - Sales Rev') # Convert input to a DataFrame df = pd.DataFrame(input1) # Sort the DataFrame by 'Close Date' df = df.sort_values(by='Close Date') # Initialize a set to keep track of seen accounts seen_accounts = set()…

Try this: from domomagic import * import pandas as pd # Reading the data from Domo input1 = read_dataframe('Existing - Sales Rev') # Sorting the DataFrame by 'Close Date' df = input1.sort_values(by='Close Date') # Initialize a set to keep track of seen accounts seen_accounts = set() # Initialize a list to store the results…

I should have noted that my legend shows in order of outer ring to inner ring. Labels on the rings are not turned on in the screenshot.

This is a bit out of my area of reach, but I'll give it a go. Based on what I read and see in your image, it looks like you are working with a brick that involves making an API call to a Domo dataset. Then performing calculations, and possibly aggregating data with subtotals. To calculate subtotals and a grand total using…

If you are trying to capture other titles that include accented characters, the following might work. CASE WHEN Page Title REGEXP '^[A-Za-zÀ-ÿ0-9 .,!?-]*$' THEN 'English' ELSE 'Other' END This would cover most accented Latin characters used in European countries. Basic Latin alphabet characters (A-Za-z) Accented characters…

I'm not sure if I understand your description or your data well enough, so this may be off track. But perhaps enough to assist. if you have a calculated field like this (z_Combined_Units): CASE WHEN `Unit Type` = 'Climate Controlled' THEN `Climate Controlled` WHEN `Unit Type` = 'Drive Up' THEN `Drive Up` WHEN `Unit Type` =…