Best Of
Re: Can You Edit a Role's Description After the Role is Created?
Great job. Glad to hear you found the answer. Five points to Gryffindor.
Re: Arrow Trend an Color Condition Format
Wow, there's some neat stuff going on in this post. We need @Eddie Small to get these three on a talkabout. (Sorry, I made up that word because it's late on a Friday and I can't remember what Eddie calls those neat online get-togethers.)
Re: AUSTIN CONNECTIONS TOUR CHECK IN
@SurfingDataLakes longtime user first time comment, from San Antonio looking to connect
Re: Apply Different Filters to Same Card on Dashboard
OMG I already had a super annoying ramification of this - I needed to change the max on my axis on each graph. Excuse me while I go do that 21 times. 😭
Re: Is there any API to get Alerts data?
@MarkSnodgrass you rang?
https://INSTANCE.domo.com/api/social/v4/alerts/series?cardId=CARD_ID
POST will return what's used to populate the alert modal. You'll need to play around with the body but should look something like:
{"filterGroupIdArray":[ID_NUMBER]}
I'd recommend monitoring the traffic for each card to see which ID it's using.
Filter out happy people
So, that's a strange title… Here's the deal:
We have survey data about support tickets. It's pretty basic— just Good, Neutral, and Bad as responses. A person can be interviewed more than once. So, I've been creating a visual of "Sentiment by user". It's a stacked bar graph with the following:
X axis: The user's name
Y axis: Count of user sentiment
Series: User sentiment
So, with a little formatting and sorting, we end up with Bob on the X axis with a tall blue bar since he's always happy but needs lots of help. Jane has a shorter blue bar with a little red top bar since 1 support ticket went badly but the rest were good. Joe has just a tall red bar since he's never happy. And so on…
So, I'd like to include only the people that have at least one non-happy (that is, neutral or bad) response. This would, using the examples, exclude Bob. How could I do that? Thank you.
Name | Date | Disposition |
|---|---|---|
Bob | 8/25/2024 | Good |
Jane | 8/21/2024 | Good |
Joe | 8/22/2024 | Bad |
Bob | 8/10/2024 | Good |
Bob | 8/12/2024 | Good |
Joe | 8/9/2024 | Bad |
Jane | 8/8/2024 | Bad |
Joe | 8/26/2024 | Bad |
Bob | 8/26/2024 | Good |
Bob | 8/16/2024 | Good |
Joe | 8/26/2024 | Bad |
Jane | 8/17/2024 | Good |
Jane | 8/11/2024 | Good |
Bob | 8/14/2024 | Good |
Bob | 8/18/2024 | Good |
5 Reasons NOT To attend Connections Tour
The Connections Tour is the ticket to snag, especially with the $0 price tag that’s easier on your budget than those concert tickets you splurged on this summer.
But if you’re thinking this tour is a total skip, read HERE for the 5 reasons you might be right.
Re: Writing a Beast mode for a table card that selects a column and only displays rows with values
create a beast mode to do a case statement to return a value if it’s not null and then add that as a filter to your card
COALESCE(your beast mode to select the column value, 'IS NULL')
then just filter where the beast mode doesn’t return IS NULL
Re: Magic ETL Join Tile
@zcameron - that is great news. I am not normally one to champion beta features before release, but a few of these things can't come early enough for me as I stave off the angry villagers at the castle walls wanting to upper case our data.