Best Of
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.
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.
Re: Creating an "unassigned" row for gantt chart visualization
I would suggest keeping your data in your original format and then building out your unassigned dates by using the rank and window tile and a formula tile. I did it by doing the following:
- Connect your original dataset to a rank and window tile and then create a column called Last End Date and choose the Lag function using the End Date column with an offset of 1. Order by the start ascending and partition on the resource name
- Add a formula tile next and create 3 columns that look like this
This will result in an output like this:
You can then filter to unassigned equal 1 and overwrite your assignment name column to unassigned and then append to your original dataset using the unassigned start and end dates as your start and end dates.
Hope that makes sense.
Re: Changing color of line in line chart
To change the color of the line or bar without it adding additional items in the legend, use the color rules but leave the condition as "always" and then choose your color. This will allow to change the colors of each.
Re: Survey - Count the answers.
You could do a case statement to look for each color in the string, but I think you will need to create a beast mode for each color. For example, the red beast mode would look like this
(CASE when `String` LIKE '%Red%' THEN 1 ELSE 0 END)
Blue would look like this
(CASE when `String` LIKE '%Blue%' THEN 1 ELSE 0 END)
You can then put each of these beast modes into your card and sum them each to get the total counts.
Re: Survey - Count the answers.
You can separate the multiple answers out into separate columns using the Split Column tile in Magic ETL. You would need to use multiple tiles to account for the maximum number of answers that a person might have selected. Once they are all separated, I would recommend adding an Unpivot tile so that you have a single column called answer and if a person had selected 3 colors, it would result in 3 rows, one for each answer. It is then very easy to count the results.





