ArborRose Coach

Can you configure a custom interaction using page parameters. Or use page level filters as a simpler approach. Using Page-Level Filter Navigation Use Domo’s Page-Level Filters or Dashboard Filter Views to set up a dropdown or search bar for order numbers. Set the interaction so that once the order number is selected, the…

You can create a Magic ETL using ranking and filtering tiles to separate the top 25, then aggregate the remaining records. Rank Travellers by Their Monthly Spend - Use the Rank and Window tile in the ETL. Use partition by for any grouping you need. Order by - choose your spend column and set the order to descending so the…

Under the MORE command at the top, go to Admin > Content > Cards. You can see all the cards listed as assets and what dashboards or app they appear on.

Creating a Year-Over-Year (YOY) card that compares fiscal weeks, rather than calendar dates, requires some custom adjustments because the default behavior will match the same calendar dates across years, not the same fiscal weeks. Make sure your dataset has a field for the fiscal week and year. This allows you to create a…

It looks like all those conditions point to parent_entity_title. What's the point in the CASE statement? I think you want what you had before but remove the ELSE clause.

Are you sure this isn't caused by the data you are using and the fields that are presented in rows and columns?

I don't think there's any way to directly modify the head section of an embedded dashboard. So adding a tracking script would not be something straight forward. You would need to figure out a work-around like using a parent page to include the script.

Yes, its probably related to the user deleting the file. Files normally will have a unique identifier in the background that let's the application know the difference, even if the names are the same.

To integrate Domo's embedded dashboards without refreshing the entire page, you can try JavaScript to dynamically load the iframe instead of submitting a form that triggers a page reload. <div id="dashboardContainer"></div> <script> function loadDashboard(embedId, embedToken) { // Create an iframe element var iframe =…

Domo, doesn't give you many options for legend positioning. You can probably figure a work around with data label positioning and beast mode calculations, or some other method.

Private Embeds: Private embeds require users to authenticate to view the content. Because users are logged in, analytics scripts like FullStory can capture user behavior as intended. This generally aligns better with tools like FullStory, which often depend on identifying user sessions within a controlled, authenticated…

Create a platform field formula. Then filter on the new field. CASE WHEN `Facebook Engagements` IS NOT NULL OR `Facebook Impressions` IS NOT NULL THEN 'Facebook' WHEN `Twitter Engagements` IS NOT NULL OR `Twitter Post Impressions` IS NOT NULL THEN 'Twitter' WHEN `TikTok Engagements` IS NOT NULL OR `TikTok Impressions` IS…

The formula as Grant has typed it looks correct. Assuming your typing exactly matches the condition logic. Using a fake dataset: hospital_name current_balance financial_class aging_group Central Hospital 15000 Medicare 0-30 days Central Hospital 22000 Medicare 31-60 days Westside Clinic 5000 Medicaid 61-90 days Eastside…

In beast mode, CASE statements can’t perform aggregate functions like SUM within the conditional logic. Use the CASE statement to identify the rows that meet your criteria, and then apply the SUM function on that logic at the card level. I'm not sure what you are trying to do with your conditional logic. You are saying if…

There may be limitations to what it can do inside Domo. Here's a simplified version to check if it fires properly. If its a brick, you have to put the javascript code without tags in javascript, and the button in the html section. <button onclick="openCard()">Open Card</button> <script> function openCard() { var url =…

I’m currently unable to test directly in Domo. I initially assumed you were referring to a programmed button that opens a card, rather than creating an image or a visual element with an action attached. The button should function according to the card's existing settings for full-screen display. If you are implementing…

Domo does not provide built-in functionality to directly set a specific size for the popup window, such as half-screen. But you can try to use a workaround by implementing a custom html button. <button onclick="openCard()">Open Card</button> <script> function openCard() { var url =…

I am saying review the permissions on the card, not the share/embed. The client and secret are used for API calls. The error seems to indicate that the specific card in the dashboard does not allow access to the entity using the token.

Seems the user associated with the clientId and clientSecret credentials does not have permission to access the card in the dashboard. Make sure the user has access to the dashboard or card you are trying to embed. At least view permissions. Check if you are generating an embed token or a private dashboard or card that the…

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.