ArborRose Coach

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.

@art_in_sky - did you get the answers you needed on the other question? Or is this still something you need us to review and respond to?

Even if you are the owner of the card, there might be specific permissions on the dashboard restricting edit. Card type could also affect it. For example, if I create a card with a blank brick, the edit may appear different than one that isn't on a brick. You may also try clearing your browser cache to make sure its not…

It's possible for the date format to differ when exporting data from a dataset to a CSV file in Domo, depending on the user’s settings or configurations. Locale Settings The date format in the CSV file can be influenced by the locale settings of the user's browser or operating system. Different locales have different…

There may be some kind of code issue occurring behind the scenes. Something we community users cannot identify for you. You should submit a ticket to Domo Support and provide them an example of one that is staying firm and one that is reverting. It may be that the parenthesis or something is causing an issue in the code…

Verify if the manual updates are being consistently saved. After saving, review and make sure you see (TRAINER). And make sure you have cleared the cache. Check for Overwrites Ensure that there are no processes or integrations that might be overwriting the manually updated names. Data Synchronization Confirm that there’s…

I think we need to see an example of how you are defining the names. I have never seen Domo change what I type in for name. Why not use "title" for trainer? Or some other field to define it?

I believe what @Sean_Tully is expressing is - to filter on something changing, the dates within an example like mine, would need to be a variable. You could take my example farther in defining period1_start_date, period1_end_date, period2_start_date, and period2_end_date. And then use them in the calculations.

There's several ways we could interpret the question. I think you are looking for something where your periods are static (firm, typed, defined). In this case my solution wouldn't incorporate "filters" as a drop down. Let's say we have a sample set: Date,Product,Amount 2024-01-01,Product A,10000.00 2024-01-05,Product…

Variables with dates can be complex. They might involved dynamic calculations or filtering the visual cannot do. Try using static dates to see if the visual loads correctly. There might be something ambiguous in the date parameters. The PowerPoint Add-In may have limitations in handling dynamic or complex date…

Also….review use of Coalesce() when dealing with null values.

You could use string functions to remove unwanted characters with formulas like CAST(REPLACE(REPLACE(`YourColumn`, '(', ''), ')', '') AS DECIMAL)

I don't know if there's a list. HTML links work in table cards, pivot table cards, html cards, and text cards. In charts line bar, line, etc you can have links like drill downs to other pages. You can also implement filters using html links. You may also be interested in using pfilters. Parameter filters let you link to…