ArborRose Coach

There has been a suggestion posted asking Domo to give us a default value ability based on formula or at least set it to curdate(). Over 100 upvotes but alas, we are still waiting.

{removed, duplicate}

{removed, duplicate}

Yes, you can use your embedded image. @MarkSnodgrass has a trick for that. Mark's cool trick - If you create a quick note card with a graphic, you can right click in your browser to see the source. This shows the Domo embedding, which can be used to host an image inside of domo. If the card is deleted, Domo still holds the…

Here's an example using your image. (Although I would improve this by using Inkscape to export the proper images and overlays). https://embed.domo.com/cards/ZY13R My images are self hosted…see the placeholder in html code. You will need to host the images and modify the paths accordingly. When you hover over the bin, you…

I don't know where Domo posted the Canva Challenge submissions from last year. Mine was a blank brick showing Japanese Cherry Blossom dates, integrated to Domo data. Move your cursor over an image on the map and it would overlay the data for that location. https://embed.domo.com/embed/pages/wmzPz If your image is svg in…

Mine is Yang Water Tiger.

@DeborahAnderson - you should post your question as a new question so the forum community can read it in entirety. A quick response…. DomoStats and Domo Governance Datasets collect data on dashboard views and provide insights on dashboard or card views, user activity, date and time. Since your dashboards are embedded in…

@csteele - As @MichelleH stated, you should be able to use variables for start and end dates. The variables will show up under the variable tab on the card. They can be placed on the dashboard for user selection. In a formula, reference the variable like you do a field name (backticks).

@MarkSnodgrass - While Mark may already have the answer to this, others seeing this post may not. You can access the pro-code editor via the Asset Library. https://domo-support.domo.com/s/article/000005500?language=en_US#access_the_pro-code_editor

Bump. Are we still waiting on this? How many other requests have over a hundred up votes? I concur with @Jones01, not just default to current date, but to a beast mode formula would be ideal.

In December, I made my New Year's Resolution to stay off the leader board in this forum {sad face}. My response to the question was that you can identify the most recent load date with a query, and use that to filter your query so it's increment (only gets the newest information). I haven't looked at any of the NetSuite…

You are still attempting to aggregate in a beast mode calculation. I was assuming a group by tile to aggregate.

@gkonkoff - you can update directly on this post. Up at the top where @jorgy has started this message is an upvote button.

Try using an ETL instead of beast mode. Create a total rating calculation column that computes the sum logic at the dataset level. Then create a beast mode calculation as a silcer. CASE WHEN `total_rating` >= 0 AND `total_rating` <= 6 THEN 'High Risk' WHEN `total_rating` >= 7 AND `total_rating` <= 12 THEN 'Medium Risk'…

I agree with what @david_cunningham said. There's isn't a way…using drill paths. I was suggesting you can try pfilters as a solution. But pfilters wouldn't be using your drill paths. You would create columns with pfilters that direct to whatever page you want and induce whatever filter you desire. Whether you drill back to…

That error normally means you have a data type wrong. Check the schema to make sure your date fields are proper date types. Check your data source. If it's an Excel file, make sure that column is formatted as date. You can also override the schema under Admin menu…Governance Toolkit > Schema Management.

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"

Yes, you can put CASE statements in the SELECT or in the criteria (WHERE clause).

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"

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…

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.

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…

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.

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');…

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

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:…

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…

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…

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…