Best Of
Re: Reconnecting Disconnected Output DataSets and Cards
Hi @Tow, what would the significant differences be between the two Dev account settings that would cause the different visibilities of the cards?
amehdad
Re: Status of Ideas in Idea Exchange
I'd be keen for this as well! There's plenty of similar ideas across Exchange that just need to be consolidated. Perhaps there can be an additional step during any post for ideas submission where the Admins can review the post against any existing comments before approving for voting.
amehdad
Re: Connecting Woo Commerc
Hi @KenTravels, this is a good first place to start to understand the steps of setting up: https://domohelp.domo.com/hc/en-us/articles/1500000161782-WooCommerce-Connector.
Did you have a particular question or issue around connecting?
amehdad
Re: Beast Mode to add two values from the same column
@GrantSmith back to beating me by milliseconds again. 😁 You may be first, but what about better? Only @Golfoholic can answer that. 😉
Re: Alerts - When Dataset Fails X times in a row.
The thing I have done in the interim is put an alert on datasets that haven't updated in XX minutes and control the minutes on a google sheet by dataset ID. I usually target my production datasets and then can dig into root causes. It updates every 15 minutes. Then I can get a single alert for all datasets I want to track.
jstan
Re: Drill from global view to country view
I just did a search for "svg global map with states" and it took me here https://morioh.com/p/1ed2ddd34690 and I downloaded the big map at the bottom. I have attached it for you. You'll have to look through and see everything is properly labeled. You can edit the svg with Inkscape, which is free, or Adobe Illustrator.
Re: Period over Period (MOM/YOY) option in Multi-Value card for 2 months prior
You can use the DATE_SUB function to subtract different intervals at a time, such as month.
DATE_SUB
Subtracts date or datetime values (as intervals) to date values in a date column.
DATE_SUB('DateCol', interval 1 month)
In this example, if the value for DateCol was 2/27/2022, it would subtract 1 month and result in 1/27/2022. Now, if you needed to get to the last day of the month if the month you just subtracted to, you can wrap the LAST_DAY() function around the Date_Sub function. This would make 1/27/2022 end up being 1/31/2022.
LAST_DAY(DATE_SUB('DateCol', interval 1 month))
Let me break down a part of my first example in case that might help you as well.
DATE_SUB(CURRENT_DATE(), INTERVAL (DAYOFMONTH(CURRENT_DATE()) - 1) DAY)
There are several functions wrapped together here.
CURRENT_DATE() is returning today's date whenever the card is viewed.
DAYOFMONTH(CURRENT_DATE()) - 1) is returning the day of today's date and reducing that by 1. So, if today is the 3rd, then this would return 2. This number is then used in the DATE_SUB function to subtract the number of days from today's date.
The result of the entire function returns the first day of the current month. So, right now, it would return 3/1/2022.