Best Of
Re: Heatmap Hover Character Limit
Hi Oliver, I've had similar issues before but with calendars. You might need to create a magic ETL or beast mode to ensure the characters you want in the hover text are the right ones. You could try making categories with a beast mode. i.e. CASE WHEN 'insert column' LIKE '%insert characters%' THEN 'insert new category name' ELSE 'insert other category name' END. Not sure if what you're looking for but will help with limiting characters in hover text to fit.
Re: dynamic date associating
To provide more clarity on my answer, your flow will end up looking something like:
Which after running provides the following output:
The modifications to the original one is on the number of days we take from the calendar, so we no longer limit it to a calendar year but to a set number of days, this happens in the filter of the Domo Calendar section (here I used 10 days as I didn't expect anything to have a list of associated IDs with more than 10 entries, but you can change the number to whatever you want):
The other key change is that I'm self adding a reference to itself on the (Self Associating SA) as part of the formulas to your original dataset, and that we measure on the number of commas, not spaces:
When we split we also make sure to remove whitespaces and transform to an integer, so that we can do the join afterwards:
The select Columns 1 narrows it down only to the ID and date, which is what we care for, and then on the group by we select all the original columns from your dataset, plus perform a MAX aggregation on the joined one.
This is scalable in the way that you can accept lists of up to N associations, but how fast it'll be to run on your real data with thousands or more entries is something you'd need to test.
Re: Sorting Beast mode
Thank you MichelleH and Colemenwilson! I wanted to keep the 'month' reference in the naming so adding the '0' before the numbers worked great. Thanks for the advice!
cmarino
Bryan Van Kampen Joins the Ranks as the Community's Newest Coach!
👨🎓 Graduating to coach status in the community forum is a monumental achievement! 🏆️ It is a sign of prestige and knowledge that few Domo users can claim to have. Which is why we all need to give @trafalger a massive round of applause for this impressive accomplishment! 👏👏👏 Bryan has been a long participating member of the community forum for over 5 years. Last month alone, he solved 12 questions and finally became a coach on September 1st.
If you'd like to connect with this Domo pro on LinkedIn, click on this link.
Congratulate @trafalger by leaving a comment below!
Re: Possible to use a value that ignores filters?
You could use FIXED BY function(s) that ignores filters:
See "Applying Filter Logic" section, use case #1.
