ArborRose Coach

Comments

  • 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.
  • 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,…