MarkSnodgrass Coach

If I am understanding the question, I think you might want to be using LIKE instead of IN. Using like with % signs on both sides of the field will make it look for that string anywhere within the other string. I tend to do this in a formula tile first and return a 1 or 0 and then use the filter tile to filter on 1 or 0.…

I only have a couple cards where I have this set up, so I can't say with 100% certainty, but I think you will have to go in and collapse those. Would definitely be something to monitor after you initially roll it out. As an alternative, you can have your main card be the summary totals, and then make a drill path on the…

You have to manually collapse them while you are in Analyzer. Once you save it in Analyzer with them collapsed, they will be collapsed for the card viewer.

@marcel_luthi laid it out very nicely (and faster than I could put together 😄 ). One of those options should do the trick for you.

In that case, you are going to need to use Magic ETL to selectively pivot some columns. Here's the KB article about pivoting. https://domo-support.domo.com/s/article/360044951294?language=en_US

You are going to need to use Magic ETL to unpivot this data so that you can create a single column that has the names C-1,C-2,etc. This KB article walks you through how to do it. https://domo-support.domo.com/s/article/360044951294?language=en_US

The first thing I would try would be to use the Transpose option in the table chart. It is in the Chart Properties → General → Transpose

It looks as though the orders report would have it. This KB articles lists what is in the connector. https://domo-support.domo.com/s/article/360042927994?language=en_US

You would just expand your beast mode to include the logic to color your values Here is an example of how you would do your variance beast mode: CONCAT('<div style=color:', CASE WHEN SUM(NumberOfVisits) + SUM(Activities) > 0 THEN 'green' ELSE 'red' END,'>', SUM(NumberOfVisits) + SUM(Activities), '')

Period over Period charts are a bit limiting in their configuration, but you can remove the line by choosing Symbols Only in the Chart Properties → General → Line Style.

It seems as though when the BETWEEN date range is selected, it does act differently. This is what I am used to seeing. I would try using the Previous → Last and choose last 6 years (which should get you back to 2018 that I saw in your between range) and choose the Graph By Quarter and Compare to 1 quarter. You can then use…

Have you tried the Variance Bar Line chart in the Period over Period Charts? It shows the variance as a line for you. You can add data labels to make the values easier to see.

If your start and end dates are in the same row, then it is pretty straightforward as @ColemenWilson points out. If your start and end dates are in the same column, but different rows, then you will need to use Magic ETL to get it consolidated so that the start and end dates are in the same row and separate columns.

Here's a video walkthrough on setting it up.

I would look into the Trellis Categories property on a bar chart. You can create a look like this with the categories, subcategories and attributes.

Yes, you can. It all depends on your datasets. If those 3 cards are all built on the same dataset and are just looking at different fields, you can create a beast mode that looks at all 3 fields and sums them up. If those 3 cards are based off of 3 different datasets, you would need to use Magic ETL and append those 3…

The subtotal and total row values are based on the aggregation type that is selected for that column. I'm guessing you have the aggregation type of your % Spent column set to Sum. If you change it to average, it will take the average of those values.

Ahh… I see what you mean. When I select my beast mode, I am not given the next option to select which values I want like you do with regular fields. I would start by reaching out to support and see if they determine if this is a bug. If they say it isn't then I would suggest adding this ability to the Ideas Exchange.

For Period over Period cards, any time you change the date range, you will need to re-select what you want to compare it to. It should give you the ability to do it, but it won't automatically do it for you.

I see beast mode columns show up in the columns to filter when creating a segment. When you created the beast mode, did you select "save this beast mode to the dataset"? I didn't think it was required, but it could be. Also, when selecting the columns, make sure you are looking in the correct data type. They are sorted by…

Yes, workflows would be the best solution for this and easier to maintain compared to the potential # of cards you might need to create if you went with card alerts.

There is a new feature called Workflows that could do this for you. I believe it is still in Beta, so you would need to ask your CSM if you can have access to it. Here is a link to the KB article. If that isn't possible, you could set up multiple cards that have alerts tied to them and would be filtered to the specific…

The partition feature in Workbench should help you accomplish it. Here is a link to the KB article. https://domo-support.domo.com/s/article/360062446514?language=en_US

You would use the pivot tile in Magic ETL to do this. However, it requires you to manually name the columns and doesn't dynamically name the column based on the data. For example, the Pivot tile converts data in this format... ... to data in this format... ... using this configuration: Here's the KB article about it. This…

Here is your case statement with the DAY parameter added: SELECT DATEDIFF(DAY,"date","published_date") df, CASE When DATEDIFF(DAY,"date","published_date") >0 and DATEDIFF(DAY,"date","published_date") <=29 then '01 Month' when DATEDIFF(DAY,"date","published_date") >29 and DATEDIFF(DAY,"date","published_date") <=59 then '02…

I would check your syntax because I tested it in Redshift and it worked.

I would check to see if any of your column names changed recently. I also wonder if you really want the NULLIF in there or not. Do you want to potentially divide NULL by 12? Or even 0 divided by 12? You may want to re-visit that portion of your logic.

@PJG Glad it worked for you. If you can accept any answers that helped you, that would help others in the community.

You need to add the day parameter as the first part. Like this: DATEDIFF(DAY, "Date", CURRENT_DATE) You could also simplify your case statement if you used the month parameter instead, like this: CASE WHEN DATEDIFF(MONTH, "Date", CURRENT_DATE) <= 12 THEN LPAD(DATEDIFF(MONTH, "Date", CURRENT_DATE),2,'0') + ' Months' ELSE '>…

Here's the KB article about Company dashboard settings that may help you as well.