Best Of

Re: Is there a way to update/run a dataset or ETL every 1 minute?

@DashboardDude option 1 seems like the way to go for a couple of reasons:
1. Least complexity/effort
2. Least credit implications
3. Was the idea I suggested so I would get the accepted answer :D

ColemenWilson

1

Re: November Community Recap 🦃🍂

Re: Are there any other data points you'd like to see me include in these monthly posts?

What about more information on ideas from the Ideas Exchange? How many have been implemented this month? How many are under review? Which users have had ideas they suggested incorporated into the product?

I'd also like to incentivize posts being written in a more entertaining fashion. I don't think I've ever seen anyone use the LOL reaction, so I'd like both metrics on who induced the most LOLs and links to those posts so I can see them (and verify for myself that they are indeed LOL-worthy).

DavidChurchman

3

Re: November Community Recap 🦃🍂

I think this is a great idea @DavidChurchman. But let’s take it to the next level. Forget just LOLs—let’s see some ROFLs, LMAOs, and maybe even a few virtual facepalms.

ArborRose

2

Re: Create Month End Date column with Year & Month columns?

@ggenovese, Lol….I thought I was confusing computer languages. Obviously…that's a better route to use.

ArborRose

2

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.

ArborRose

1

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.)

ArborRose

1

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. 😭

Mary_Moilanen

1

Re: Is there any API to get Alerts data?

@MarkSnodgrass you rang?

@Kms

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.

GrantSmith

2

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

froghunter

2