Best Of
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.
Re: Magic ETL - tile now beyond scroll ability
@ArborRose this worked. They usually start out as elegant, but then they just want more and more and more. 😄
Jbrorby
Re: Sharing custom themes in App Studio
Custom themes are currently saved to an individual app.
To create custom theme, a user needs to select save as theme then it will store it to custom themes panel. We are working to add the capability to copy a theme from one app to another in the upcoming months that would let you use custom themes across different apps.
Current workaround is to duplicate the app and save that theme and use that new app!
Re: Ranking up in the Community Forum
@damen accumulating points is how you hit the next rank. You earn points by answering questions, getting badges, and recieving reactions. As those points add up, you get closer to the next rank.
The belt system (and Dojo wording) has been done away with. Member, Contributor, and Coach are the ranking levels now.
Re: Error: "Shape input Alert (NUMBER) may not have been initialized, all inputs must be initialized"
I’m here to help. I don’t know why my name is Zoolander, either. Ha ha. This is Dan Hendriksen. I think we’ve met before.
Re: Magic ETL Tiles groups for clearer organization and visibility/observability :D :D :D
Yes, indeed, I definitely agree I am kind, and a stranger.