MarkSnodgrass Coach

@tejusarora Thanks! I tried that earlier and it was giving me an error, but now it is working as well.

If you're only wanting this to process for Account A, I would a nested case statement like this: (CASE WHEN TRIM(`column1`) = 'Account A' THEN (CASE WHEN TRIM(`column2`) = '' THEN `column1` ELSE `column2` END) ELSE `column1` END)

Blanks and nulls are not the same, so the ifnull function would not help with this data. I would try this to look for blanks: (CASE WHEN TRIM(`column2`) = '' THEN `column1` ELSE `column2` END) The trim function removes any spaces that may be in the data and then you can evaluate it to see if it is blank. Hope this helps.

Try just doing this: IFNULL(column2,column1)

Ahh... It was hard to tell from the screenshot if you need to access info from two different rows. In this case, You can still use the TIMEDIFF function, but you are going to need to do some work in Magic ETL first. You would need to utilize the rank and window tile and then use the Lag or Lead function so that you can add…

I would suggest looking at the TIMEDIFF function and the UNIX_TIMESTAMP function. The TIMEDIFF function is pretty straightforward: TIMEDIFF Returns the difference between values in two date/time columns, expressed as a time value. TIMEDIFF('Time 1','Time 2') The UNIX_TIMESTAMP function will require a little bit more work.…

You might also try: IFNULL(`company_name`, `group_name`)

You chose Heat Map for your chart type, which is actually different from the Heat Map Table. On the right side, choose Tables and Textboxes from the Chart Types dropdown list. Then choose Heatmap table for the chart type.

Within Analyzer, make sure Properties is selected. This will allow you to adjust the chart properties. You will then want to go to General and enter in which columns you want to apply the heatmap to as I referenced above.

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…