Best Of
Re: beast mode
I've re-read this like 10 times and can't figure out exactly what you are trying to do. Could you share once again slightly differently? Or maybe show two excel samples: what the data currently looks and how you would like the data to look with the beastmode?
Re: beast mode
I understand now, thank you! Yes you will want to do what @ggenovese recommended.
Re: How to show events that happened after a selected one?
Hello @ggenovese,
It's super nice how a single problem can be approached in various ways. I'm sure we can think of a few more solutions. It's really about @0RNGL4DY and what will be done later with the Beast Mode and visualizations to determine the most suitable approach for his case.
Re: How to show events that happened after a selected one?
Hi @0RNGL4DY, @ColemenWilson,
This method is effective only if all "Person" entries attended the A conference. If the first conference is B and you wish to check attendance for C, D, etc., an alternative approach is recommended.
I suggest using a Pivot to transform rows into columns, enabling multiple strategies to achieve the desired outcome.
And the result:
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