MarkSnodgrass Coach

You can use the split columns tile in Magic ETL to split up your string by looking for the comma. You would do multiple splits in that tile so that you can get to the 3rd and 4th entries. You can then do a filter tile where you filter out entries that have the values you want to exclude. Here's a KB article on the split…

I would just not format the revenue as currency, but as a number with commas. I would think people will know without needing the $ sign. The other option would be to make two different fields, one for revenue and one for the other. Then, you can use the built-in formatting for each of them.

@Ashleigh is well-versed in CourseBuilder. She may have some insight on how she tracks her courses.

Since you are concatenating inside your case statement, it becomes a string, so you can't sum it. You will not be able to have one value show up two different ways inside a sum. I would suggest just having your revenue case statement just return a number and the beast mode should work.

Are you using Magic ETL? If so, the full quotation marks " are your problem. Instead, just start typing the column name without any quotation marks and then select it from the auto-complete list. Domo uses single back ticks ` if you wanted to try and manually type it, but it is much easier to start typing the name and…

That is an odd error. I haven't seen that one before. I would using your Division field first and see if it produces results without an error. I would also try switching to a standard table and see if that works. You might also try removing Division out of the Sorting properties and replace it with your beast mode. Hope…

First, make sure that you are installing it form the Microsoft Appsource here: https://appsource.microsoft.com/en-us/product/office/WA200005264?exp=ubp8&tab=DetailsAndSupport&mktcmpid=admindl Second, within PowerPoint, go to File → Options → General → Privacy settings and make sure "Enable optional connected experiences"…

As an alternative, you can use the HTML Single Value Brick. This would allow you to create a border with some basic HTML and CSS. You can find this brick in the Appstore by searching for brick.

I wonder if you could reach out to support to get them to give you at least a one time report on this. You can see the null percentage on a dataset when you go to the stats view on the data tab, so the information is there. It could also be worth submitting an idea in the Ideas Exchange as a Domo Stats/Governance dataset…

There is no limit listed in the Domo documentation. Certainly, the more joins you add, the bigger hit on performance, so that will be something to consider. You can try sending an e-mail to Domo Support and see if they will give you an exact number, if there is one.

I have not heard of a row limit on dataset views. In fact, it is often used on larger datasets, so I wouldn't think there would be a limit. Are you getting an error that is telling you there is a limit?

A Sankey chart could be a possibility for you. Otherwise, I think you would want to look into the custom charts option where you would upload a SVG file that has the hierarchy format you are looking for. I would start by doing a google search for hierarchy SVG files that you could easily adapt. You can also build your own.…

I have found the Period over Period charts to be extremely limiting for reasons like this and will often look to use a standard chart to get the same comparison. You might want to look at this video and see if you can adapt it to your needs as it will give you more flexibility than the PoP charts.…

Your ETL will look something like this where you are linking multiple join tiles one after another. In your case, you would start with dataset B since that has the IDs for everything. Next, add a join tile and connect to dataset A and join on Ad ID. Next, add a join tile and connect to dataset C and join on campaign ID.…

You send a new file to that e-mail address and just have it contain the same column headings but no data. If your connector is set to replace, then it will replace the existing data with zero rows.

Pictures of me in a Halloween costume pre-date the digital age, so I will go with a picture of one my kids. One of my kids dressed up as Sonic the Hedgehog as he was a big Sonic fan. Also included is our dog with her Halloween angel costume.

Which suggestion solved it? If you can mark that response as an accepted answer that will help others in the community.

You might need to apply an aggregation to your Dat Avg CPL field. Based on the field name, try adding the AVG() function around it.

I would also check to make sure the Y-Axis is set to Sum (or the appropriate aggregation type).

PDP is the answer for this. This is exactly what it was designed for. https://domo-support.domo.com/s/article/000005116?language=en_US

Colemen is correct. It will temporarily explode your dataset, but then you filter it back down. Magic ETL processes it pretty quickly, though.

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), '')