ArborRose Coach

I didn't realize this was on a pivot table. Yes, the calculations must be full aggregated with the case logic contained in the aggregate. I don't have a sample dataset to test with. How about this? MTD: SUM( CASE WHEN `Fiscal Year` = `Year Selector` AND `Month Selector` = `Month Name` AND `Class 3` = 'Sales' THEN `Amount`…

How about CASE WHEN `Fiscal Year` = `Year Selector` AND `Month Selector` = `Month Name` THEN SUM(`Amount`) / SUM(CASE WHEN `Class 3` = 'Sales' THEN `Amount` ELSE 0 END) END

The way Domo works with different chart types, often depends upon the underlying chart interaction settings and how Domo is designed to handle filtering on the chart types. Currently, I don't think Domo has the ability for line clicks to filter by both series and x-axis values in line bar charts or multi line charts. You…

This usually points to a filtering logic or problem with the data. Verify the column does not have any unexpected data types or values. (Check the data visually to see if you see any mixed data types.) Make sure to filter out null values or create a beast mode such as CASE WHEN YourColumn IS NOT NULL THEN YourColumn END.

The .limit() issue may be caused by that query syntax hitting a structural limitation in the framework. There are a few alternate approaches you might try to keep the workflow without creating a new column. 1. Apply Multiple .where() Clauses query .select([...]) .where('errorMessage').contains('Some text')…

Since the Domo dashboards are embeddedin an iframe, tracking tools don't have direct access to grab the interactions within the iframe. You have a few options though. You can setup tracking to attach listeners within your page to capture data when users interact with the dashboard. You can then push the data to your…

Domo's Javascript may not support .or(). Using the following code, you should be able to get the include to return true if either condition is met….creating an or condition. query .select([...]) // <- specify select columns here .where(row => row.errorMessage.includes('Some text') || row.errorMessage.includes('Some other…

You could… Test the API Outside of Domo . Run the API using something like Postman or cURL to make sure its givng back data. If the API outside of Domo also shows no data, it’s an issue with the API source itself. Review API Parameters and Filters Check the API parameters, such as date ranges, filters, or other query…

On your data flow, check the schedule to make sure it is scheduled. It may be set to manual, which requires manually triggering. If the log shows the data flow ran recently but you still don't have data, you probably need to verify the data source has data. Or that the process isn't filtering out your data or otherwise…

1. Set Up a Google Analytics Account and Obtain Access Make sure you have access to the Google Analytics account and specific views or properties you want to analyze. You will need permission to connect to Domo. 2. Navigate to the Google Analytics Connector in Domo Go to Data Center by clicking the Data option on the top…

If you go to the Data Center (data on the top bar), and click on AppStore, you can search for Google Analytics. You will find different connectors available.

If you continue with regexp, you can try something like this… CASE WHEN REGEXP_LIKE(REGEXP_REPLACE(`body`, '^\s+|\s+$', ''), 'USD\s+\d{1,3}(,\d{3})*(\.\d{2})?') THEN REGEXP_REPLACE(REGEXP_REPLACE(`body`, '^\s+|\s+$', ''), '.*USD\s+(\d{1,3}(?:,\d{3})*(?:\.\d{2})?).*?', '$1') END

If the preview works but the output is empty, it might be there are characters unseen. Have you tried using trim/replace? I'm not sure if this formula is quite right as I'm not in an example. CASE WHEN REGEXP_LIKE(REGEXP_REPLACE(`body`, '^\s+|\s+$', ''), 'USD\s+\d{1,3}(,\d{3})*(\.\d{2})?') THEN…

The first part of that regular expression may not work with Domo SQL because part of that is a "lookbehind", which can be finicky. If you try to isolate the numeric part following the USD, you could try something like: CASE WHEN REGEXP_LIKE(`body`, 'USD\s+\d{1,3}(,\d{3})*(\.\d{2})?') THEN REGEXP_REPLACE(`body`,…

In the base URL, do not include a slash and avoid adding a question mark if you plan to include the entire query string dynamically. When you create the dynamic parameters, do not include an initial question mark nor a slash. Format the dynamic parameters so they start directly after the base URL, something like:…

You can't directly reference a dataset field in the textbox for "Single URL," so you probably need to approach it a bit differently using Dynamic URL with a dataset. In your ETL or DataFlow, concatenate the full URL (including all parameters like Scenario, FiscalYear, $filter=FiscalMonth, etc.) into a single column. For…

GET https://localhost:3000/domo.js net::ERR_ABORTED 404 (not found) This error indicates that the application is trying to load domo.js from localhost:3000, but the file does not exist, resulting in a 404 error. This is a key issue: domo.js is missing or not correctly deployed to your local server. Refused to execute…

If you are using concat to combine text and numeric values on an html card, you won't be able to use Domo's heatmap. But you can implement your own heatmap by assigning your own color ranges based on the number of accounts. Level 1: 0 - 10 accounts → light green Level 2: 11 - 30 accounts → yellow Level 3: 31 - 50 accounts…

You put multiple cards on a dashboard and the filters work across the cards. In this example, the main card is the green outline at the bottom. The three cards at the top are for filtering. They have chart type: filter. Each of the cards use the same single dataset (result of an ETL or an import, etc).

Think of a dashboard as a collection of cards. You can have several cards on the dashboard. They can be text/table cards, charts, etc. Each card would use a single dataset. If you are joining the datasets, you would create a Magic ETL to handle the logic. In this brief example, we would take two datasets, join them and…

The card probably isn't the value going to the alert. That would be the field in the dataset. If you set a field up to represent percentage in the dataset, it should show up as a percentage in the alert. You might even have to do it as a string representation in the dataset.

I see. So some branches and months may not exist and the join won't create rows for missing combinations. Sounds like you need a way to make sure the combinations have all relevant GL accounts, if if they don't exist in the GL Records. You could handle this by creating a master dataset. Complete with all possible branch,…

Glad to hear you got it resolved. For anyone not aware, under Admin > Toolkit, there's a scheme management capability to modify a dataset's field types. But I use it as a last resort; when I can't seem to get Domo to accept my field types on import.

Domo tries to infer the data type based on what it sees in the column of numbers and text. If you import an Excel file, and use formatting in Excel prior to the import, you can get Domo to recognize the proper types to use. For example, if you import a date Domo will probably get it wrong. But format the column to date…

Perform a full outer join or a right join between the GL Records table and the Chart of Accounts table. The key for the join will be the gl_account_id. This will ensure that all rows from the Chart of Accounts table, including "Addons-Repairs," "Restocking Charges," and "Contractor Discounts," will remain in the result…

I wasn't at Domopalooza, but it looks like a very interesting card. I think what you are looking for may be something like the following. rgba - is R (red), G (green), and B (blue)..the colors of light. With an alpha channel as a fourth value. The values go from 0 to 255. Turning the first value to 255 means red is on.…

1. Model Setup with ARIMA (Exogenous Variables) or Random Forest ARIMA with Exogenous Variables (ARIMAX): ARIMA can accept external (exogenous) variables in addition to time series data. You can set up an ARIMAX model using Python in Domo's data science tool (like Jupyter Workspaces or Python tile). In Python, when fitting…

I don't think we can turn off the icon. We can only disable functionality. Which makes no sense to me. All AI appearance and functionality should be off by default.

There's no beast mode command for dealing with commas, but you can achieve it in other ways if desired. CASE WHEN `Category` = 'Revenue' THEN CONCAT('$', CASE WHEN ROUND(`Actual`, 2) >= 1000000 THEN CONCAT(ROUND(ROUND(`Actual`, 2) / 1000000, 2), 'M') WHEN ROUND(`Actual`, 2) >= 1000 THEN CONCAT(FLOOR(ROUND(`Actual`, 2) /…

Um…I did not put those numbers on that code. Hmm.