MarkSnodgrass Coach

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: https://youtu.be/mZlxTS4s81I

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.

You can actually use color rules to do this and not lose the formatting you are applying to the cell. Create a color rule, select a color and set the opacity to zero, then select the table text to be the text choice in the middle and unselect the apply format to table row.

It doesn't appear that you have a lot of consistency to go off of since some of your first words have spaces and sometimes your first word is also the second word. Are the words at the end consistently the same? If so, you could look at the end of the string using the RIGHT() function and if it equals Referral or Internet,…

@jaeW_at_Onyx has several YouTube videos around Domo and Jupyter. He might be able to weigh in and answer this

Which report are you choosing with the HubSpot Connector as there are over 20 to choose from? It may be that you need to pull two different reports and then use Magic ETL to join them together so that you get the friendly names you are expecting and not just the internal IDs. One way that can make this easier for you is to…

You should be able to do this utilizing the partition support in Workbench. Here is the KB article on it. https://domo-support.domo.com/s/article/360062446514?language=en_US

I would double check the settings tab of the DomoStats Activity Log dataset to make sure that it is running daily and then check the history tab to see that it has run successful up to the most current date. You can also check the data tab and look at the Event Time column to make sure it is current. If those all check…

that's interesting the page filters are interacting with them if your javascript code in the brick is only referring to dataset1. There is not a way to add/remove datasets, which is an unfortunate limitation of bricks. The easiest fix I would suggest for you is to make a domo webform or an excel file that has 3 columns and…

I have been experiencing the same issue. I use Chrome on a Windows PC. I haven't tried Edge to see if I experience the same thing to truly determine if it is a browser issue or not.

You can do with the deep link filtering (or pfilters). Here is a video of how to do it: https://youtu.be/zrNDxinOti0 It's also covered in this KB article: https://domo-support.domo.com/s/article/360043430113?language=en_US