ArborRose Coach

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…

Weeks don't match year over year. You may have a year with 3 business days in a week, comparing with another year with a different number of business days.

https://community-forums.domo.com/main/discussion/comment/97781#Comment_97781 Send an email to support@Domo.com

I don't know how much control you have over it. Go to the admin settings in Domo and review your SSO configuration. There might be a setting related to automatic user creation.

I don't think pfilters work across apps currently. As of now, pfiltering does not support passing filter values directly from one app to another. This means that filters applied in one app cannot automatically be carried over to another app. But that doesn't mean you can't work around it. You could try something like…

The Domo Eloqua API connector pulls data from Eloqua using its API endpoints. When setting up the connector, you can specify which objects and fields you want to retrieve, such as contacts, campaigns, or other data. Contact Data and Opt-In Status Eloqua has different fields and attributes related to contacts, including…