trafalger Coach

This is so so needed!

Go to the "Vertical Bar" section in Chart Types → Select "Bar" and then add a series to it and it will be a stacked bar!

So in an group-by tile, add Publication and InHomeYear to the groupings and do a SUM(Total Cost) in the bottom section which should result in what you are trying to achieve

You'd probably have to do this in a dataflow!

You can also normally give your IT team a list of emails/dates and recepients and they can confirm if it got there. I went down this rabbit hole with a client's IT, and they weren't even hitting their email servers. Domo support finally told me that 5/7 people all unsubscribed within seconds of each other but also this…

This would be great!

@imelendez it's not my favorite…

Can you let me know if there's updates on this @Abark12? I'm working with Domo support on a similar issue with one of my clients.

Also 100% put yourself and whomever else would need emergency access on the "Direct Sign-On" list so you can still login to fix things. Also this URL is your friend https://<subdomain>.domo.com/auth/index?domoManualLogin=true

As far as I know, the only way to do that is by linking the Cards and Pages dataset to the cards dataset to the cards and data datasets.

You'd have to do this in the dataflow -basically join the 12 prior monts to each month (Aka, April's date would have the prior 12 months appended to it and all have a "Report Date" of April, so in analyzer when you select April you'd have the 12 months there). If you don't want the ability to drill, you could aggregate…

Hmm thanks for the heads up @DataMaven , not sure why it didn't load the first time. It was a screenshot of like 15 FAILED tiles that all said "No additional details." In large datasets with a lot of tiles you need to hover over like 15-20 FAILED tiles to actually find the one with an actual error message.

Have you considered using TIMEDIFF?

You could create an outlook rule to do this!

I don't believe this connector exists still, @marco_p. Your best bet would be to create the data engineering you're doing in PowerBI in Domo.

What are you trying to automate? Those boxes should only pop up once you are authenticating but shouldn't be popping up later

Use the "Dataset copy" connector, take a copy of the original dataset and append it to your snapshot dataset on a quarterly basis. From there you can make an ETL that marks the most recent version of the data as the most recent and use the snapshot date to view history of the date.

Hey Tad! Great to meet you and great job speaking at Wednesday's Chicago tour!

It's such a great platform! I'm BVKSpins4Beer but sadly have fallen off a bit recently, blame the baby haha.

I know the CSV Advanced PULL connector can (which I've found to be easier) I usually use the CSV advanced files which don't support excel, but other excel connectors can usually specify the tab.

No but I've had some similiar issues and haven't found a great solution for them yet.

Do I get community points if my answer was copied from the slack to here? 🤣

I've seen issues where the sorting gets strange if some of the sales people don't have any values in a particular time period and Domo handles that sorting strangely because it's a NULL.

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!

Nice to meet you Dan!

This needs to be a thing!

And if you message me requesting access please include your email address so I can add you quicker!

To give some context, I’ve seen MySQL dataflows take 4-5 hours and then their Magic 2.0 replacement take 10-15 minutes. Unless you’re doing like a stored procedure Magic 2.0 is the way to go.

#1 is writing a SQL statement, like ALTER TABLE t1 ADD INDEX('t1.COLUMN')