ArborRose Coach 
Comments
-
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…
-
@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…
-
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?
-
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.
-
Congratulations and thank you - @JasonAltenburg, and @Data_Devon.
-
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…
-
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…
-
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()) -…
-
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…
-
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">…
-
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…
-
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…
-
Just for clarity, what @Data_Devon is referencing is your field name, not a static value. DATE_ADD(`your_date_field`, INTERVAL 1 MONTH)
-
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
-
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.
-
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.
-
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…
-
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…
-
Sounds interesting. Is this question coming from a school or training exercise? Parsing the Currency Code and Amount: As your screenshot shows, you can use the split column tile toseparate based on a delimiter (space or symbol that separates the code and amount) and then a formula tile to clean up or reformat the separated…
-
CASE WHEN COUNT(DISTINCT CASE WHEN (Company Name IS NOT NULL) AND (Activity types LIKE '%attended event%' OR Activity types LIKE '%email engagement%' OR Activity types LIKE '%webcast attended%' OR Activity types LIKE '%webpage visit') AND (distribution team LIKE '%marketing') AND (salesforce contact record type LIKE…
-
When working on the data from the data center, there's a schema option in the upper right: You can reorder the column from that command. But they will not stay in that order. If the ETL is modified or the process re-runs, it will most likely change the order back. Under Admin > Governance > Toolkit, there is also a schema…
-
You can select a set of stories, features, etc and compare their open/completed status with the their status in the source system. Make sure the totals, averages and other aggregates match the source data for a given period or project.
-
@ggenovese, Lol….I thought I was confusing computer languages. Obviously…that's a better route to use.
-
Can you use the year and month to build a date? And then use that date to calculate your end date? Say you create a formula to find the first of the month after and then subtract one day from that. I have to test this, but possibly something similar: DATE_SUB(DATE_ADD(DATE(CONCAT(`Year`, '-', CASE WHEN LENGTH(`Month`) = 1…
-
You can use a replace text tile in an ETL to remove the known value, "FY2024". Or a command like this if it's static: TRIM(SUBSTRING(`BDM Name`, 1, LENGTH(`BDM Name`) - LENGTH('FY2024'))) Or get a be more complicated using a regular expression in a formula: REGEXP_REPLACE(`BDM Name`, 'FY\\d{4}', '') and wrap the TRIM…
-
Yes, I would try the Azure Connector. I have a few things hosted in Azure and it works a bit different than having a normal MS-SQL database.
-
I don't have an example set up to try this. SUM(CASE WHEN ( (Year Selector = Fiscal Year AND Month Number >= 2) -- From February to December of the current fiscal year OR (Year Selector = Fiscal Year + 1 AND Month Number = 1) -- Include January of the next calendar year ) AND Month Number <= CASE WHEN Month Selector =…
-
I don't think MFA would be an issue. Are you attempting to connect using the Azure Synapse SQL Connector?
-
I think DomoStats has: - Dataset ID - Dataset Name - Dataflow Name (if the dataset is used as part of a dataflow). - Input/Output Type (whether the dataset is an input or output for a given dataflow).
-
What if you change January to 13 instead of 1? That should cause it to treat January as part of your fiscal year Feb 2024 - Jan 2025.
