MarkSnodgrass Coach

The issue is your date range filter is set to Yesterday. That means it will only return 1 day and likely 1 row if you have 1 row per day. If you want to compare yesterday to the day before yesterday, set your date range filter to Last 3 Days. Then sort by date descending. This will make the day before yesterday as the last…

I'm not sure if it is available in Beta yet or not, but I remember hearing about a SQL Editor for Views, which should address this issue for you. I would reach out to your CSM and see if they can provide any insight into that feature. They may be able to let you be a Beta user of the feature.

you can add a TRIM() function around the entire concat function and that will remove trailing spaces. You can also do it around each field, which may help.

Unfortunately, there is not a smart text field to display that information. It would be worth adding to the ideas exchange. I get around this by putting a dynamic textbox card above the other card and display the max date in the textbox card. Often using the dynamic textbox card as the card title for the card below it.

Yes, you will find it under the Vertical Bar Chart types

Not quite sure what your data looks like, but You can use this to get the prior month CASE WHEN LAST_DAY(datefield) = LAST_DAY(DATE_SUB(CURRENT_DATE(), INTERVAL 1 month)) THEN totalamount ELSE 0 END And this to get the 5 months prior CASE WHEN LAST_DAY(datefield) <= LAST_DAY(DATE_SUB(CURRENT_DATE(), INTERVAL 2 month)) AND…

You can also use this: /* my multi-line comments go here */

The remap nulls likely isn't working because the data contains blank spaces instead of actually being null. I would suggest dealing with this by creating a beast mode in Analyzer that looks like this: CASE WHEN LEN(TRIM(fieldname)) >= 1 THEN fieldname ELSE replacementvalue END This will trim out all the spaces and then…

Oh, that's true. If this is part of a dashboard, here is what I have typically done: I will stack a dynamic textbox card on top of my main card and use the dynamic textbox card features to display the date.

Drag that field into the filters section and select that value. It will be the only value. Then, go the smart text and choose filters and select that field. That should add it to the title.

Definitely worth adding an idea in the ideas exchange to allow for more options in display the last updated dated using the smart text option. Another option would be to use the formula tile in your ETL and create a field called last updated has this in the formula: NOW() that would store the timestamp of when the ETL ran.

You might also want to look into the certification center where you can certify cards and datasets. When certified, a blue badge will be visible and will stay that way unless the card or dataflow is altered. In theory, if it has passed the certification process, you shouldn't need to continue to check on it to make sure it…

Are column A and column B the same information? For example, a ProductID or something? If so, then you would use a Left Join and have the dataset that has column A on the left side and have your join criteria be Column A - Column B. After the join tile, you can add a filter tile and filter to where column B is null.

Can you elaborate a bit more as to what your two datasets look like that you are trying to compare? What does your join criteria look like?

If your value isn't null but empty or blank, you might need to consider a different option. Another option would be check the length of the value of the field and also use the sum operation. Like this: SUM(CASE WHEN LEN(TRIM(columnname)) >= 1 THEN 0 ELSE 1 END) This will trim out any spaces and then check the number of…

you are missing the END statement in your CASE statement. Try this: COUNT(CASE WHEN column name IS NULL THEN 'Something' END)

The opensource library is the font awesome library. They aren't supported except for in Domo Bricks and by adding a link to their library.

You might try the INSTR() function as an alternative. You could do something like this: CASE WHEN INSTR(fieldname, variablename) >= 1 THEN 'True' ELSE 'False' END

I have run into this before. I had to create a quick filter that used the variable on the card and then save and close the card. After that, the dashboard recognized the variable and I was able to add it to the dashboard.

I have had trouble with the Word plug-in as well. I created a dashboard using a combination of cards and bricks to get the formatted look I was going for. I walk through how to do it in this video:

You can use the Color Rules to do this. This is found in the chart properties. It would look something like this.

Agree @Nihar_Ex_Domo . If you post this as an idea in the Ideas Exchange section, it can be voted up by others.

This seems like a use case for fixed functions. I would look through the examples in this KB article and see if one of them matches your use case. https://domo-support.domo.com/s/article/4408174643607?language=en_US

Agree with @MichelleH that this sounds pretty busy. You might look into using the Trellis Categories on a bar chart to help break it up.

You can click on More in the Navigation menu and then Certification Center → Certified Datasets and then scroll down to see the datasets that are certified. Same process for cards.

Love these ideas @DavidChurchman . I think you should repost this in the Ideas Exchange so that it can be voted up.

It sounds like you are wanting to combine two columns together to make a new unique ID. You can do this with the formula tile and use the CONCAT function. Something like this: CONCAT(IDcolumn,'-',PageColumn) This would combine the two columns with a hyphen between the two fields.

You need to select a macro to put in the text box (i.e. %_VALUE) and then you can choose Lines Only in Show Datalabels On

Oddly, the tab functionality still works in the formula editor in Magic ETL, just not in Analyzer. Seems more like a bug that should be sent to support@domo.com.

Agreed. I would suggest submitting this in the Ideas Exchange in order for it be considered as a feature enhancement.