MarkSnodgrass Coach

Perhaps if you divided that by the day of the month, like this: SUM(COUNT(TicketNbr)) OVER (PARTITION BY board_name ORDER BY date_entered) / DAYOFMONTH(date_entered)

Have you tried using a window function to get a running total? It would look something like this: SUM(SUM(`ticket_number`)) OVER (PARTITION BY board_name ORDER BY `date_entered`)

Are you getting an error? Or just the wrong number? It looks like you are totaling 13 numbers (current week plus last 12) and then dividing by 12. Depending on what you are wanting to do, I would either drop the current week, or the last week. This post has good documentation on this if you haven't already looked at it.

Ah that makes some sense if you are using the x Periods Ago rather than the Last 2 Values.

A couple things to try. Add ReportDate into the Optional Group By. Also, try changing Data from Last and X Periods Ago to Last 2 Values.

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.