ArborRose Coach

Comments

  • You could use COALESCE to make sure the sum of the estimated youtube ad revenue does not return NULL. SELECT *, CASE WHEN SUM("AD_IMPRESSIONS") IS NULL OR SUM("AD_IMPRESSIONS") = 0 THEN 0 ELSE COALESCE(SUM("ESTIMATED_YOUTUBE_AD_REVENUE"), 0) / (SUM("AD_IMPRESSIONS") / 1000) END AS "CPM" FROM "youtube_monthly"
    in DOMO SQL - Formula Comment by ArborRose December 19
  • Yes, you can put CASE statements in the SELECT or in the criteria (WHERE clause).
    in DOMO SQL - Formula Comment by ArborRose December 19
  • The NaN means "not a number". LIkely due to a divide by zero issue. Maybe try catching the condition SELECT *, CASE WHEN sum("AD_IMPRESSIONS") IS NULL OR sum("AD_IMPRESSIONS") = 0 THEN NULL ELSE sum("ESTIMATED_YOUTUBE_AD_REVENUE") / (sum("AD_IMPRESSIONS") / 1000) END AS "CPM"
    in DOMO SQL - Formula Comment by ArborRose December 19
  • I believe LinkedIn uses its own Geocoding identifiers to represents countries, cities, and other areas. I don't think they publish an official mapping to their codes. You could do a internet search for something like "unofficial LinkedIn geocode mapping". Or try to connect to the LinkedIn API and get a full geographic…
    in How can I convert LinkedIn geocodes to other geographic variable Comment by ArborRose December 19
  • I don't have any issues scheduling Jupyter Notebooks. On the Python code, there's a link for schedule as DataFlow. When you click and setup the link, you will see the ipynb file in your dataflows.
    in DataFlow Error: Trying to Schedule DataFlow in Jupyter Workspace Comment by ArborRose December 19
  • Are you talking about adding the user to you Domo instance? Or adding the user to an app? The error sounds like a configuration or permission issue with authentication. • Are both user's on the same allowable domain (same email company)? • Does the activity log (Admin > Activity Log) show you any details? • Check user…
    in User access not working Comment by ArborRose December 19
  • If you create a public embed without a login, it can't enforce the PDP. You have to somehow tell the report who is looking at it and filter it accordingly.
    in Can we generate Embed public URLs for PDP policy datasets? Comment by ArborRose December 18
  • I don't think Domo will allow you to write JavaScript in the browser that can post back to the dataset. You would need a backend service to receive the data from the user and then use the Domo API to write to the dataset. Something like the following. const express = require('express'); const axios = require('axios');…
    in Editing the 'Form and Dataset Brick' Comment by ArborRose December 18
  • Have you considered other methods of achieving the outcome? What about something like an html page that allows a selection of clients, pointing to Domo dashboards backed up by different datasets? <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width,…
    in Dataset Switching Comment by ArborRose December 18
  • Sorry, I can't watch the video right now. But I can see your question. You should be able to include a button in your brick that triggers JavaScript to refresh location.reload(); If you add html for the button, something like the following should work: #refreshButton { margin: 10px; padding: 10px 20px; background-color:…
    in Refresh Button Card to Refresh Domo Page in Embed Comment by ArborRose December 18
  • It sounds like there's a problem with the connector itself. I suggest reporting the problem to Domo Support. You've limited the data to a single data. That should give you a small size dataset. But even with a single-day range, pulling data "By ASIN By Date" can result in a large dataset depending on the number of ASINs…
    in Amazon Selling Partner Connector Comment by ArborRose December 18
  • You can learn about the Domo certifications at https://www.domo.com/domo-central/university. Login and there is a link for certifications. https://www.domo.com/domo-central/university. Data Specialist Certification Focuses on preparing, transforming, and managing datasets in Domo. Includes hands-on practice with ETL…
    in How was your experience in taking Domo Student Certification Exam? Comment by ArborRose December 18
  • I think you are getting confused by your data. The answers to your data would not be what you show. Your last record overlaps but your display says it doesn't. I did it using SQL Dataflow. SELECT a.order_number, a.customer, a.business_unit, CASE WHEN a.start_date < b.end_date AND a.end_date > b.start_date THEN 'Yes' ELSE…
    in Overlapping Date Beast Mode Comment by ArborRose December 16
  • @art_in_sky - I haven't done this for anything myself. I'd have to work through it. I would probably try to leverage the Domo Embed API. Embed the card in an iframe and add an export button to append ?export=true. domo.get(`/v1/cards/{CARD_ID}`) .then((card) => { const iframe = document.createElement('iframe'); iframe.src…
    in Can you add an 'Export' Button in App? Comment by ArborRose December 11
  • Did the schema of the data change? Is this something you can test on another dataset? Or test from another computer to make sure it's not something on your environment?
    in Error with Domo --> Excel Add-in Comment by ArborRose December 6
  • I think this is a great idea @DavidChurchman. But let’s take it to the next level. Forget just LOLs—let’s see some ROFLs, LMAOs, and maybe even a few virtual facepalms.
    in November Community Recap 🦃🍂 Comment by ArborRose December 6
  • Congratulations and thank you - @JasonAltenburg, and @Data_Devon.
    in November Community Recap 🦃🍂 Comment by ArborRose December 5
  • If your objective is to read a Domo dataset into a brick, but not on-the-fly upload via a button, then this example should help. This example pulls the default dataset, "Example Sales Data". You can pull other datasets into the brick. var domo = window.domo; var datasets = window.datasets; // get the data…
    in Is there a method to upload files directly to a Domo Brick? Comment by ArborRose December 5
  • The Facebook Advanced Connector in Domo is typically used to pull data from Facebook's APIs, allowing you to analyze both organic and paid metrics. What Each Report Represents Page Posts Report: Provides details about individual posts, including real-time or short-term metrics such as post-specific likes, comments, and…
    in facebook advanced connector Comment by ArborRose December 5
  • I agree with @ggenovese. You may want to look at using the period over period charts. As for your beast mode, maybe changing your condition logic to something like: CASE WHEN Title LIKE '%OTT%' AND MONTH(`Date`) = MONTH(CURRENT_DATE()) THEN 'Current Month' WHEN Title LIKE '%OTT%' AND MONTH(`Date`) = MONTH(CURRENT_DATE()) -…
    in Create Bar Chart with Current Month Vs Previous Month? Comment by ArborRose December 5
  • Generally, when I create a Domo brick I use notepad ++ and create an html file to work through the problem. If it works in html, I then try putting into the Domo brick and work from there. In this case, I can make a solution work in native html and JavaScript, but it isn't working in Domo. Paste the following into an html…
    in Is there a method to upload files directly to a Domo Brick? Comment by ArborRose December 5
  • I think you would have to do some kind of custom styling script. <html> <head> <style> .radio-group { display: flex; flex-wrap: wrap; gap: 10px; /* Adjust spacing as needed */ } .radio-group input[type="radio"] { margin: 0 5px 0 0; /* Adjust margin as needed */ } </style> </head> <body> <div class="radio-group">…
    in Horizontal orientation for Radio button list to occupy less space in forms. Comment by ArborRose December 5
  • I wanted to follow-up with a bit more information in case someone reading has trouble with this. An Azure database can be hosted in Microsoft Azure. Or you might have an Azure VM server in the Azure environment, running a Microsoft SQL database. I just successfully completed a connection to a MS SQL Database on an Azure…
    in What's the trick to get a microsoft sql connector to work? Comment by ArborRose December 4
  • Domo supports embedding dashboards, but it is done through Publish Dashboard or Domo Everywhere. (I'm not familiar with any API endpoint.) The Domo API does not provide functionality to dynamically switch datasets within an embedded dashboard. Dashboard views in Domo are tied to specific datasets as defined during…
    in Dataset Switching Comment by ArborRose December 4
  • Just for clarity, what @Data_Devon is referencing is your field name, not a static value. DATE_ADD(`your_date_field`, INTERVAL 1 MONTH)
    in Date Calculation Comment by ArborRose December 4
  • I only know to set it for the company. Admin > Company settings. The functionality has been requested: And in this previous request - a loom link was shared but it doesn't appear active. https://community-forums.domo.com/main/discussion/67058/can-i-default-the-landing-page-to-an-app
    in Can an App be set as the default landing page? Comment by ArborRose December 3
  • Being an "Analyst" on your company page is probably not sufficient. LinkedIn's API typically requires the user to have an "admin" role for the company page to access data through third-party tools like Domo.
    in LinkedIn V.2 Connector account issue Comment by ArborRose December 3
  • I believe you would need to setup some kind of work-around. Create an automated dataflow and include a step that validates whether the new data was added (check timestamps or row counts). Or set up an alert with a trigger condition to let you know when new data is added.
    in Alert / Notification setting Comment by ArborRose December 3
  • Creating a drill path to an existing card is not directly supported as a native feature in the same way that creating a custom drill path is. You can create a calculated field in Beast Mode that generates a URL to an existing card. If it's the existing card, why not use filter views or page filtering (multiple cards…
    in Drillpath to an existing card Comment by ArborRose December 3
  • As David mentions, sometimes a card might not render properly but still occupies space. Go to the dashboard's edit mode. Look for outlines or boundaries of the dead space. Try resizing. There may also be some type of grid misalignment or layout issue. Go to edit and see if you can drag something else there or reposition to…
    in How to resolve dead space area on a Dashboard? Comment by ArborRose December 2
Avatar