ArborRose Coach

{this is a duplicate post - see 69902}

In my example, using Excel to verify numbers

What does your data look like? Can you give us an anonymized example. I think your formula looks right. If I work with example data like this Booking Date,Business Unit,Revenue 7/13/2024,Demand Generation + Ad Ops,1557.65 8/8/2024,Demand Generation + Ad Ops,3112.78 3/29/2024,Demand Generation + Ad Ops,1825.61…

I don't know if you can get that specific group and stacked chart. With the native setup. Take a look at the following knowledgebase page: https://domo-support.domo.com/s/article/360043428713?language=en_US and similar discussion:…

Oh…I could have added as many records as I want. I'm normally pulling from a vendor API, collecting as a csv or dataframe and then appending that to my Domo dataset.

Yes, it is reusable. The ID will be unique to that dataset. If you create a second with the same name, it will have a different ID. Here's a result showing that I have run the code two more times to append two more records.

It sounds like the behavior of domo.onDataUpdate() may have changed. Since this change affects your existing applications, I recommend reporting this issue directly to Domo Support. They can confirm whether this is a known change or a bug and provide guidance or a fix. If your handler is asynchronous, that might have…

How you append and the code you use will also depend upon how the dataset was created. In the example I showed, I create a dataset using the API and then append it via the API. If you create the dataset as an output dataset in Jupyter, you don't need the API to talk to it. Unlike systems like SQL where a table is a table…

Example to create a dataset using API import requests import json base64auth = 'XXXXX' # Get token from Domo token_response = requests.get( 'https://api.domo.com/oauth/token?grant_type=client_credentials&scope=data', headers={'Authorization': 'Basic ' + base64auth} ) token_data = json.loads(token_response.text) token =…

I have many Domo datasets that I append using Python. I normally do this in Jupyter workspaces. You can access that area by going to Data Center on the top ribbon bar, then click on the three dots on the left bar - at the bottom. In my Python code, I can either call the Domo API to manipulate datasets or I can access the…

You should be able to do page-level interactions. Make sure both cards use the same dataset, or the datasets share a common field like category or date. If the datasets aren't directly connected, create a Magic ETL to join or combine them as a unified dataset. And create the Sumo table and bar chart cards from that new…

In Domo the stack order should be based on the series. You can create a custom variable for your academic years and decide whatever order you want. It would be helpful if you could show us the card. CASE `Academic Year` WHEN '2023' THEN 1 WHEN '2024' THEN 2 WHEN '2025' THEN 3 WHEN '2026' THEN 4 END

@TommyDenn Apparently Microsoft Graph is the official API for accessing data in Microsoft 365 and Azure Active Directory. Try connecting through Microsoft Graph's API us OAuth2. You should be able to access user profiles, last sign-ons, groups, titles, departments, etc.…

I'm not trying to solve your whole issues, but trying to assist on a possible solution. Review the code with the assumption you have a dataset for 'ReviewStatusOutput'. Btw, there may be other more elegant ways to answer your question. Try this: Go to AppStore and open a Blank Brick as a new dashboard. Edit the brick so…

It may be related to the way you have the fixed series set. Even though you filter the data, the series is still affecting the chart.

I needed to Google to understand CPK (Process Capability Index). I do not believe Domo has any native CPK function. Beast mode can do basic aggregations but its limited for something like complex statistical functions like standard deviations across a dataset. You'll want to create a Magic ETL or use SQL. And if your data…

You can use Domo forms to collect submissions and write those submissions to a Domo dataset. Then using a card, display the submitted data in a dashboard. The dataset updates in real time when new forms are submitted. But you need something like workflows to define automated logic based on the dataset changes. For example,…

Another topic I would like to see is AI forecasting with medical transactions. Forecasting the next few months or year based on previous data.

The SQL tile can do group by and inner joins but it has limitations such as temporary tables, limited CTE, and no recursion. If you are having trouble with group by, remove aliases and use actual column names. You may also need to break up complex logic into multiple tiles. I don't use the SQL tile because of performance…

I don't believe so. Without some of the windowing functions of SQL, you won't have dynamic logic in FIXED expressions. I played a little and got close but did not get a running total. It used a value at each date not accumulated over time. You are going to have to create an ETL because of the aggregation needed.

The error seems to indicate Snowflake does not have access to that output dataset. I do not have "compute" in my instance to see similar options. Is there an output tile for a Snowflake dataset?

Embedding a form brick without authentication is not safe for collecting sensitive data or PII. It exposes security, privacy, and compliance risks. A work around would be a 3rd party secure form like Google Forms. You can then ETL the data into Domo via connectors or API. Otherwise, as I mentioned - run the form…

Looks like a bug in flex table. I suggest contacting Domo Support.

You screen images are not showing.

It may be that the error is referring to a specific dataset in your ETL. Such as a dataset from a cloud connector (AWS, Google, Azure).

Am I to understand that you are trying to extract email addresses from a single column that has a huge amount of text and contains ALL your email addresses and their domains? If so, ouch. And then…you are trying to compare each value to a list of known freemail domains and flag whether the domain is freemail or business?…

When you apply a filter on the card, it might not apply to the logic on the dataset powering the card. The card filters are like quick filters…sort of temporary. Make sure your alert is based on a value or or change to a value or aggregated metric of the dataset.

You state that you removed "some" null dates. Preview may work because it is not hitting the full dataset that hits the issue. Such as data consistency, nulls, or formatting. It's just working with a subset. Make sure your data column is properly formatted as a date (not string) and contains NO nulls when passed to the AI…

One of my favorite quotes was highlighted by X-Files' Lord Manhammer. When coworkers need help but don't want to admit they need help. Say it! https://www.youtube.com/watch?v=NOb7JXV1T1Q

It looks like it has something to do with the way it was stored and ported over. Can you delete and recreate the aiMetadata variable in the new instance to see if it will have the child properties for dataDictionary, etc as in the first instance?