Best Of
Re: unpivoting data
It's a recent addition and not yet mentioned in the docs, but Magic's GROUP_CONCAT does support the DISTINCT keyword now.
A Group By tile with grouping column Account and the formula aggregates GROUP_CONCAT(DISTINCT Category SEPARATOR ', ') and MIN(Date) might be what you're looking for.
rco
Re: Buzz - Bulk Deleting Previous Content for Whole Organization
We would definitely love the opportunity to bulk delete as well. Or auto-delete posts that are a certain age. For us, Buzz is a tool for the users to communicate and share, but it is not utilized as our support communications tool, which can muddy up the instance when a user floods the buzz feed with usage and access questions. We have found that not having this functionality not only creates a messy environment, it also creates a certain degree of negative commentary around using Domo when we can't remove some of these things.
(Yes, we know we can delete individual messages, but it does still show “Message Deleted” which isn't ideal)
Re: Convert text to date field using
You can use a formula tile and the STR_TO_DATE function
STR_TO_DATE(`Month`, '%Y-%m')
Alternatively you could just use LAST_DAY to get the last day of a month to get the month of your date / timestamp field.
LAST_DAY(`RRDAT`)
Re: Pivot Table - More control over subtotal rows
This is a pain point for us here at GE HealthCare as well. It would be great if this enhancement request can get some traction 😊
LAFligg
Re: Color Rules and Drills
Agreed! I end up creating new columns that just reference the columns with beast modes but it'd be great to not have to do this workaround!
Re: Have you upgraded Domo SSO successfully (or unsuccessfully) to Azure AD?
just curious can you share how you sync AD groups into DOMO without using just the claim token for SAML
dchan17
Re: Number Format issues at dashboard/instance level
Have upvoted this as absolutely crucial for us to have this at instance level which would hopefully then impact every element. Our customers love to export tables to Excel and without the separators being correct Excel will not see those cells as numbers!
Jones01
Re: Auto-Hide Buzz on Default
Agree with this, it's the first thing I teach people when I run Domo trainings, it would be nice as an Admin to have a switch to keep it collapsed by default.
