Best Of
Contextual tooltips in hover text
Anyone know if there's a way to show different tooltips in hover text depending on what series you're hovering over? For example, I have a chart that shows the percent change in value from last month as a bar and percent change in value from the same month last year. When I hover over the percent change from last month, I'd like it to just show last month's value and when I hover over the percent change from last year, I'd like the hover text to just show last year's value. Is this possible?
Re: Change Column Name Based on a Date Selected in Drop-Down Filter
While not a column name change, you can use the +SmartText to change the title of cards to be kind of dynamic. So if you're open to that, it's an option.
Re: World Map Visual
@cmarino The country values in your data likely don't match the format that Domo is expecting for that chart type. According to this KB article, the World Map chart matches the data to the country based on the country's 2-character ISO country code. Here is a Wikipedia article with the list of countries by ISO code:
Re: Enable Preview Up to Point in ETL
I would take it a step further and make it so that if you make a change to a tile after a preview you can tell it to recalculate the preview for that tile without having to recalculate all of the preceding tiles. This is already available in the SQL ETLs, and would be a huge time saver.
jimsteph
Re: Overlapping Date Beast Mode
I approached this using Magic ETL, and here is how I did it:
1. Create a Lead and Lag function to get the previous End Date and the upcoming Start Date.
2. Create a formula to flag when there is overlap. (also by creating this I noticed that your data in the excel screenshot for overlap appears wrong. For Customer ABC there is overlap with order number 3 ending 12/30/2025 and order number 4 starting 1/1/2025)
Is there a way to embed bookmarks in a page so you can navigate quickly to different parts of page
Just want to navigate from section to section w/in a page. Similar to the bookmark functions w/i a document in Word. Thanks
jcrouse
Re: HTML tables filtering
A couple thoughts on this:
The first thing I would try would be to re-order your WHEN statements so that all of your Low Risk items are first, followed by the Medium Risk and then the High Risk items. Since case statements stop evaluating once they find a match, if you want someone to be low risk if they meet any of those criteria, this solution will work for you.
If an entity is only low risk, for example, if they meet all of your criteria, then I would restructure so that you only have 3 WHEN statements (1 for each risk) that have a lot of AND statements in them as you are combining each risk.
Hope this helps.
Re: Transforming an ETL
Hello - If you want to take an entire row from one dataset and add it to another then you need to Append rather than Join. If you're concerned about alterations to the existing ETL I would recommend making a copy of the ETL to test the logic and then incorporating your changes into the original ETL when you're satisfied with the results.
Re: FOR WHILE loops in dataflows
100% agree with jaeW_at_Onyx. We need loop structures in ETL.
Re: Graph is only showing 11 months of data for 12 months
Hello @Patricia_Zavisky,
Join your dataset with Domo Dimensions Connector from the Appstore to add rows for each month/year, even if the value is 0. Replace nulls with 0 either in ETL or by using Domo Beast Mode with a formula like:
CASE WHEN IFNULL('your_column', 0) = 0 THEN 0 ELSE 'your_column' END
