ArborRose Coach

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.

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…

To my knowledge, Domo does not natively support .avro files through its connectors. If your .avro files are stored in a cloud storage service like Azure Blob Storage or AWS S3, you can use the Blob Storage connector in Domo to access them. However, this will only allow you to access the files; you would need to process the…

I think you are going to need to contact Domo Support. I don't see any information for the publisher nor links. Please don't click this as correct answer…someone from Domo may have the information to supply here. https://domo-support.domo.com/s/article/4409676591127?language=en_US

You could create a beast mode calculation to determine whether each actual value meets the corresponding goal. CASE WHEN `Actual` >= `Goal` THEN 'Goal Met' ELSE 'Goal Not Met' END Add to your table. Apply conditional formatting with this status.

As Jones01 says, either of these should work FLOOR((DAY(`date_column`) - 1) / 7) + 1 FLOOR((DAYOFMONTH(`date_column`) - 1) / 7) + 1 Create a Table or Chart in Domo. Add the fields: YEAR(date_column) MONTH(date_column) Week Number of Month as shown Total Spend: SUM(spend_column)

The seems to be pointing to an invalid JSON response. It indicates the response might be HTML…such as when an API call returns an error message. You could try to capture what is happening by adding some error handling code. for (var i = 0; i < 1000; ++i) { var res = httprequest.get(baseUrl + "?cursor=" + Cursor); try { //…

Will the topics cover anything other than AI Chat?

In Domo, there isn't a built-in feature to directly mass transfer datasets from one connector to another. You would need to come up with a process. You could try automating the process through Domo's API. But I think I would attempt it in Python. Authenticate import requests # Domo API credentials client_id =…

The error suggests the domo publish is failing due to an issue with how CLI is handling a file path. The path argument must be a string or an instance of Buffer or URL. The error indicates that somewhere in the process, a file path is either missing or improperly defined. Update the Domo CLI npm install -g ryuu Or,…

You could setup the SFTP connector or use Workbench to pull from the SFTP. Make sure the file is fetched in CSV. Then use Python or Domo's AWS S3 writeback connector to transfer to S3. Use a dataflow to do any processing or transformations. For the archive, write a step that trigger the S3 Writeback to upload to the…

I don't have time to replicate it as an example today. I think you need to create custom columns and rows to get the comparisons over each metric. Replace Amount with the relevant column for Order. Replace Amount with the relevant column for Unit Sold. Overall Period 1 & 2… GMV_P1: SUM(CASE WHEN `Date` >= 'P1_start' AND…

I would need to do it see it more specifically. Hour Time_Zone Count 0 EST 10 1 EST 15 2 EST 8 ... ... ... 0 CST 12 1 CST 9 2 CST 11 ... ... ... 0 MST 7 1 MST 14 2 MST 13 ... ... ... 0 PST 5 1 PST 10 2 PST 9 ... ... ... Group by Hour and Time_Zone. Aggregate the counts of your specific field. Create a new card and select…

Yes, I think you could use beast mode. Build some calculations for each time zone, and pivot the data to get everything in a single column. I'd have to create some sample data and try it to give a better answer. Beast Mode for EST: HOUR(Created Date) Beast Mode for CST: HOUR(CST Created Date) Beast Mode for MST: HOUR(MST…

I create a formula for current year (CY) and previous year (PY). Do this and you can then look at the difference. Let's say I want this year quarter to date. And previous year quarter to date. CASE WHEN YEAR(`date`) = YEAR(CURRENT_DATE()) AND QUARTER(`date`) = QUARTER(CURRENT_DATE()) THEN `amount` ELSE 0 END CASE WHEN…

Make sure your dataset has columns for the hour extracted from each time zone's created date (CST Hour, MST Hour, PST Hour, and EST Hour). Create a Magic ETL to aggregate your data by hour for each time zone, Group by with the count of your fields for each time zone. Then use a multi line graph and set the x-axis for hours…

Yes, look up "recursion". This is something you can do in Magic ETL. Also can do it with a Python tile. https://domo-support.domo.com/s/article/360057087393?language=en_US

To my knowledge, Domo doesn’t provide native, detailed tracking for changes to Dashboards and Cards. The version commentary feature for Data Flows is quite useful for tracking changes, but similar detailed tracking for Dashboards and Cards isn’t available. There are a few things to help you monitor changes to Dashboards…

You have defined four variables: P1_start, P1_end, P2_start, and P2_end. It appears that you have also made those into controls. Next, change the calculated fields so they make use of the variable instead of static values. Then, when the variables are changed on the controls panel, the values on the card will change…

Can you transform your data in an ETL? Apply a formula like Log(Value) or Value / Scaling Factor to adjust the bubble sizes. Create a calculated field to adjust the size values directly. A formula to scale down or normalize your values. For example, Size = [Original Size] / 1,000,000 to convert billions to millions.