MarkSnodgrass Coach

I would suggest using the Heatmap Table chart type under Tables and Textboxes in the chart selector. In the chart properties, make the following adjustments: Under Theme, select a color theme that has the range of colors you want to use. Under Scale, select Independent Column Ranges, so that each column will be colored…

To set the background image for a Page, On the Page you want to change the background color of, select Edit Dashboard in the menu in the top right corner of the Page. In the Options menu at the top of the screen, select Change background. (Conditional) If Color Fill is selected in the menu at the top of the dialog,…

If you go to the dataset in the data center and click on it, you can then go to the settings tab and re-upload a file.

Yes, I often add the same field into the optional group by and choose to count. You can accept your answer so that people know it is not an outstanding question and it will help others that run into the same issue.

Your beast mode syntax should look something like this: (CASE WHEN CURRENT_DATE() >= '1/1/2022' AND CURRENT_DATE() <= '3/1/2022' THEN 98 WHEN CURRENT_DATE() >= '3/2/2022' AND CURRENT_DATE() <= '5/30/2022' THEN 98.5 END ) You might also consider adding an ELSE clause to handle when the current date doesn't match any of the…

You can do this in Magic ETL with the Unpivot tile. If you are unfamiliar with it, you can read about it here: https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot#3.

You can do this with a formula tile and a group by tile. In your formula tile, create a column called TimePeriod and use the LAST_DAY() function to normalize your dates to a single day in each month so that you can group by month. Your formula would look like this: LAST_DAY(pickdate) Add a group by tile and group by…

Quick filters to do not pay any attention to the sorting properties, unfortunately. They are treated as strings and will always sort ascending. Your best bet is to have your values be Year-Month, with the month always being 2 digits. You can do that like this: DATE_FORMAT(`datefield`,'%Y-%m') This should return it as…

This is a tough one as I don't know that there is a clear cut solution since this is around data cleaning. Here are a few ideas for you, and maybe one of these will work for you: Use recursive dataflows to identify adjustments - If you use a recursive dataflow, you will be able to use the batch_date as an additional…

You may want to ask your CSM to get a demo of Flex Map. It is a paid custom app that can do exactly what you are looking for.

You might be able to get around that duplication by not showing the newly created column in the main table and including an aggregate column in there. This way, it will just show distinct values. You can even hide the aggregate column in the chart properties, but it is still used to reduce the number of rows.

This requires restructuring your data, so that there is a row for each type. So, if an entry had "desktop, mobile" it would become two rows with this ETL. It would look something like this: You can use a formula in each of your filter to retrieve the rows that contain mobile and another one for desktop. Then create a…

You might consider pivoting the data in Magic ETL to create columns for each of your types. You could also use multiple filters in Magic ETL and then append them back together. This would keep your data from getting wider. You would set up a filter tile for each device type you are looking for and then use the append tile…

There really isn't a copy function for datasets. You just have to create a new connection and copy and paste details over to your new one. The Java CLI command tool might be able to do it. Honestly, though, it would take more time to figure out the correct syntax than it would just to make a new connector that I just…

If you are talking about changing a SQL query, then are you talking about a dataset created in Domo Workbench? Where would you be making the SQL changes?

You can use the Dataset Copy connector to copy a dataset. Go to the data center and click on connectors and search for dataset copy. https://domohelp.domo.com/hc/en-us/articles/360043436533-DataSet-Copy-DataSet-Connector

Have you tried extending how many decimal places are showing on your Fall Out Rate Average Line? 44/319 and 44/329 are pretty similar, so it might just be a display rounding issue for you.

It looks like what you want to happen, is not possible. I just put together a test dashboard and running into the same issue. It treats the filters as one or the other and doesn't let you use them both when they are the same column. I would give some thought to a different approach. You might just need to have cards 2, 5…

I think I'm starting to wrap my head around what you have set up. Let's use part_number as an example. If cards 2, 5, and 8 each use the column part_number, then selecting 1 part on each of those cards should result in 3 rows showing on your append card. This is assuming you don't select any filters on cards 1, 4, and 7.…

Are cards 2, 5, and 8 showing values from the same column? Or different columns?

I would suggest doing this in Magic ETL since you need to access previous rows. You can do this by filtering to Inherited Sale = True and then join it back to your original dataset and choose left join with your original dataset being on the left side. Join on Engagement ID and and Full Name. Records that show from the…

When no filters are selected on your dashboard, your append card should be showing all your data. If it isn't, you need to see what filters are set on it in Analyzer that are keeping it from showing everything. Then, edit your dashboard and choose Edit Content on each of your filter cards and choose Change Interaction.…

All appending is done in dataflows, not in cards. When you say that all cards are coming from the same dataset, is that just the same origin, or they are all actual powered by the same dataset? You can tell by editing a card, and looking at the dataset name on the left side above the dimensions and measures. If all 10…

try adding IFNULL() around each of those like this: IFNULL(Inside Count,0) + IFNULL(Outside Count,0) + IFNULL(Phone Count,0) If you have blanks that aren't nulls, you may want to do some additional cleanup in a formula tile prior to the group by tile.

That does seem like a bug if you are now the current owner and it won't let you certify it. I would submit a ticket to support and have them look at it and hopefully they can create a fix for you. A temporary workaround would create a new ETL and that just has an input dataset and output dataset. If you create that, it…

Remove the sum function in your group by statement. The group by tile will sum it for you. You just need it say: Inside Count + Outside Count + Phone Count

I know I have certified my own datasets. I don't get an e-mail notification, but I am able to go to the certification center and approve it.

There is no way to disable the link to a parent page. I would consider re-thinking your navigational structure so that you have a meaningful parent page. If you can't think of any alternatives, you could create a table card or notebook card that just has links to the subpages.

Are you the co-owner, or the sole owner? It looks as though you need to be the owner of the dataset to request certification. Only DataSet owners—not co-owners—can start the certification process for the DataSet. If a request for certification is submitted by someone other than the owner, a message is sent to the owner…

Unfortunately not. Would be a nice enhancement. Not sure if it has been submitted in the Ideas Exchange, but would be worth adding. I know you're not the only one who could benefit from this type of feature.