ArborRose Coach

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` =…

Filtering on multiple keywords can be tricky. You can set a column on the dataset to match the condition(s) you require. Or create a filter formula: CASE WHEN `column_name` LIKE '%keyword1%' OR `column_name` LIKE '%keyword2%' OR `column_name` LIKE '%keyword3%' THEN 1 ELSE 0 END

Are you sure its referring to the output dataset? Does your SQL have input datasets that may be locked?

I don't do much with Smart Text but I think you'd need to create calculated fields to dynamically calculate the start and end dates with a label for the period you need. Start Date of Last Week: DATE_SUB(CURRENT_DATE(), INTERVAL (WEEKDAY(CURRENT_DATE()) + 6) DAY) This calculates the Monday of the previous week. End Date of…

I don't know a specific chart type if custom formatting isn't available. I don't know all the options without trying to replicate the entire thing myself and see what's available. My approach would be to start creating some kind of custom output using a brick or possibly try to work with separate charts in a dashboard…

Can you reformat the JSON incoming, before you handle it? Loop through each object in the array, extracting the details from the "name" key and creating a new object with the key "details" associated with the value. // Simulating the incoming invalid JSON (you receive this from the API) var invalidJson = [ { "name":…

That's too bad. And you can't go back to the source of the API code and talk to them about it?

If you're applying this Beast Mode calculation to a chart, ensure the chart type is compatible with mixed data types, as some chart types may not handle string formatting (e.g., concatenating a %) on axis values. 1. Beast Mode Calculation with Mixed Data Types If your Beast Mode calculation returns different data types…

Given a structure: { "name": ["details1"], "name": ["details2"], "name": ["details3"], "name": ["details4"] } This JSON structure is not valid because JSON keys must be unique within the same object. If your data is like this: [ {"name": "details1"}, {"name": "details2"}, {"name": "details3"}, {"name": "details4"} ] You…

If your screenshot is showing a card with a dropdown filter, the card would have the field/column at the top in items and optional group. Go to the optional group and set the format as number and uncheck the thousands separator box. Result:

1. DataFlows: Data Storage: Yes, DataFlows (which include Magic ETL, SQL DataFlows, and Python/R DataFlows) store the output datasets in the Domo cloud. When you run a DataFlow, it processes the data and outputs the result as a new dataset in Domo, which is stored in the Domo cloud. 2. SQL View (Domo): Data Storage: Yes,…

How about CASE WHEN `Churn Unit` = '% of Units' THEN CONCAT(ROUND(`Churn (%)`, 1), '%') WHEN `Churn Unit` = '# of Units' THEN ROUND(`Churn (Units)`, 0) END ROUND(Churn (%), 1): Rounds the churn percentage to one decimal place. CONCAT(ROUND(Churn (%), 1), '%'): Appends a percentage sign to the rounded percentage value to…

The issue in your JSON code seems to be the repeated "name" keys without nesting. To properly reference the data in your loop, you should ensure that each entry in the array is an object with distinct keys for "name" and "details". JSON [ {"name": "details1", "detail": "detail1"}, {"name": "details2", "detail": "detail2"},…

To compare month to a previous year's same month: sum( case when YEAR(`transaction_entry_date`) = YEAR(DATE_ADD(CURRENT_DATE(),-365)) and MONTH(`transaction_entry_date`) = MONTH(DATE_ADD(CURRENT_DATE(),-365)) and `date` <= DATE_ADD(CURRENT_DATE(),-365) then `amount` else 0 end And add a criteria such as Month(date)=1 if…

Something to ponder

It sounds like you are encountering different levels of aggregation - the left table and the right table aren't matching correctly. Make sure the tables are aggregated consistently, and that the data formatting match. If there are duplicate 'Project ID' values in the left table and not in the right table, you will get…

You probably need to search the internet for some examples of using pfilters. Here's an example of what I mean with a pfilter. In the redacted card below, I created a field with a clickable link, "Details". The link is built using a formula with CONCAT. And it looks really complex because its HTML encoded. I did not code…

Whew. That's a bunch of columns. Whether you do it through Domo's AI or externally….you can feed AI a list of column names and ask it the question. It may have a limit on how many you can give it at one time. You may need to feed it a hundred or so at a time and limit the answers down til you get what you need. Let's say I…

Domo's ability to color text in cells is pretty limited. But you can work around it. One way would be to use an HTML table with custom formatting. This thread may give some insight: https://community-forums.domo.com/main/discussion/67852/html-table-conditional-formatting I believe you can also do the following: <p…

For Net Promoter Score (NPS), you'll want to create a formula that counts the number of Promoters, Detractors, and Total Responses, and then applies the NPS formula. You should have a column that contains the net promoter scores and another one for your calculated Promoters, Passives, and Detractors. You should have your…

"Not following what you mean by bottom branch not doing anything…" Sorry, I don't see any additional columns in your screenshots. Therefore, I couldn't see it doing anything beneficial.

From what I can see, your output is already coming from your Group By path (left side of the join). Although I wouldn't put the condition the way you have it. I would compare the date only and knock off the timestamp. Your bottom branch does not appear to be doing anything.

I think we would have to see what you have in the group by. The group by paths are going to aggregate the left and right sides. Assuming what I show below in yellow is the Nov 2023 path, you would be summing the planned cost and grouping by the other fields. On the green path, you would be summing the same way. Your tiles…

Oh…and add the condition of MONTH in the same way we do YEAR to get Month over Month.

If you use formulas for dynamic years in an ETL using the Group By Tile, such as: current year: sum( case when YEAR(date) = YEAR(CURRENT_DATE()) and date <= CURRENT_DATE() and sku='Product A' then amount else 0 end ) previous year: sum( case when YEAR(date) = YEAR(DATE_ADD(CURRENT_DATE(),-365)) and date <=…

The error "Invalid alias: T2" suggests there’s an issue with how Domo is referencing or aliasing the columns in the new dataset. Make sure the column name from the new dataset exactly matches the column name you expected in the Data View. Check for leading or trailing spaces also. If you copy and paste names, copy them…