MarkSnodgrass Coach

If you go into the analyzer for each card (or slider), click on the date range in the top right. This will tell you which field the card is using for the date and you can change it to what you want the card to use. This may be your issue.

You might need to give some examples of your filters, but you can add multiple fields into the quick filters, which may accomplish what you need. Another idea that may help you is to create a beast mode for a date. For example: IFNULL(date1,date2) This would use date2 for the date field if date1 was null. Hope this helps.

You might try watching the network traffic in your browser when you go the scheduled reports section and edit the list of users to see what APIs it calls. This site might be of some help as well: https://datacrew.circle.so/c/developerdomocom-community-edition/ It's not free, but you may want to talk to your CSM about Domo…

Domo can't plot anything for something that isn't there. It would be nice if there was something you could do in Analyzer, but you will need to go to your ETL and join it to a date table, such as the Domo Dimensions Calendar to create entries for every date. You can then replace nulls with zeros in your ETL for those dates…

I believe the solution to this is to append your data. For example if you had two groups, one that could see revenue and one that couldn't, you would just append your data to itself once, and zero out the revenue values in the appended data. You would also have an additional column that would distinguish which is which and…

You can use the formula tile and use the replace function like this: REPLACE(fielname,'.0','') This would replace .0 with nothing which would then make it read how you want.

There is not something out of the box that would do this. You can easily build a card that would show your inactive users. If you have the Domo Stats dashboard, there is already a card built that shows you inactive users. However, the tricky part is removing them. You would need to build some API calls in order to delete…

A basic way to accomplish this in a beast mode is to use sum distinct like this: SUM(DISTINCT `Row Count`) However, this is not a perfect solution if you have names with the same row count. I'm not sure it is doable in a beast mode that is perfect, but you could do this in Magic ETL by doing a group by statement to get the…

@Katie_Forrest_2022 glad it helped. If you can mark any answers as accepted that helped you, that will help others in the community. Have a great weekend as well!

Are you running the install as administrator by right-clicking and choosing Run As Administrator on the setup file? That would be the most likely cause. Are you able to see the log file that it references? That might provide additional details to help troubleshoot.

If you wanted to do it in a beast mode, it is quite a bit more involved, but you could do this: CASE WHEN `Start Date` = `End Date` THEN 0 ELSE DATEDIFF( CASE WHEN DAYOFWEEK(`End Date`) = 7 THEN SUBDATE(`End Date`, INTERVAL 1 DAY) WHEN DAYOFWEEK(`End Date`) = 1 THEN SUBDATE(`End Date`, INTERVAL 2 DAY) ELSE `End Date` END ,…

If you are able to do it in Magic ETL, the date operations tile makes it quite easy to do. Magic ETL Connect your Input DatSet tile to a Date Operations tile. Configure the tile as shown here: Note: In Step 4, you will want to make sure to choose your end date first and then your start date as this function subtracts the…

That looks correct. Are you looking at the newly named column for your result as it won't affect the original column. A better option might be to use the Formula tile and use the date function to extract the date from your field. It would look like this: DATE(`drentlastchanged`) This will not only produce just the date,…

Ahh.... I would say the Domo University materials are out of date. That screenshot you just added is how it used to work, but they changed the look and function a while back. Show Formatting Options replaces Show More Options.

Seems like a browser issue or something. I would try a different browser or a different card and see if happens. I found a summary number like yours and I can click Show Formatting Options and it worked. Also, you keep saying "show more options". Are you referring to something different than "show formatting options"?

Here's the format I used in my sample dataset and it worked. Keep in mind, the preview window may not be pulling in all of the rows to accurately determine if your filter is working properly. You might need to run the full ETL, depending on the size of your input dataset. DATE(`datereported`) >= DATE('1/1/2022') AND…

There wouldn't be any applicable formatting options if you are not wanting to display a summary number which is why you don't see the option when you choose No Summary Number. You need to select Use All Values or Use Current Value and then you could choose how you want those values formatted.

I have seen this before. I would take what @GrantSmith is suggesting and wrap the date function around your field as well in the formula. DATE(`TicketCreatedDate`) I think it is a bug in the ETL and have found that wrapping the date function around both works around the bug.

You should be able to do this. Edit your dashboard and then choose Change Interaction on this card and see what the settings are. I have a bar chart like this and I can uncheck items in the legend. Here is what my interaction settings look like. You can also check the filter exceptions. Mine look like this.

You can do an @ mention to a group name, so if you know the name of the group or groups that have access to the dashboard, that should notify all of them. It would be a good suggestion for the idea exchange to have a @page or something to notify everyone that has access to the page.

To do a running total with the rank & window tile, choose Sum and then choose unbounded and 0 following and sort by date ascending. I'm not sure how you are determining lost clients, so you may need to explain more how that is determined if you need help on that.

@MaryAl Here are a couple more links for you as this has been a common question in the Dojo. https://dojo.domo.com/discussion/52677/domo-ideas-conference-beast-modes-number-formatting#latest https://dojo.domo.com/discussion/comment/44279#Comment_44279 Hope this helps.

Hopefully the history tab will be helpful for you. I would also suggest looking into rebuilding your dataflow in Magic ETL. Complex joins can be accomplished by using filter tiles after the join statements and other additional tiles, but the end result typically results in a much faster runtime.

Does the issue persist when you save the card and view it outside of Analyzer? Either way, here are a couple options for you. In the Data Label Settings, you can toggle the Allow Overlap checkbox and see if that helps. Use the Hover Text Settings instead of the Data Label Settings. You can have multiple fields of…

Are you using Magic ETL 2 for you dataflow? That will run faster than MySQL or Redshift dataflows, so I would switch to that if you aren't already using it. You can also investigate the individual steps of a dataflow by going to the history tab of your dataflow and then going to the far right of the latest run and click on…

I agree that it could be improved and it is more obvious to the end user which type of scheduling is being used. Glad it helped. If you can mark the answer as accepted, it will help others in the community that have the same question.

I agree that it is a bit confusing. When you go to the scheduling section of your dataset, if it is actually using Advanced, it will show you that first when you click on scheduling. If it is not using advanced, it will show you the basic. If you click on Advanced, it defaults to putting in the current time (in UTC) in the…

Pivot table is a good way to go. There is also the transpose property in the regular table that can be useful for turning your rows into columns.

Amazingly fast answer by @GrantSmith :) Beast modes also accept /* */ as comment blocks, such as this: /* check to see if the shift is in the same day */ (CASE WHEN DATE(`startdate`) = DATE(`enddate`) THEN /* same day*/ /* check to see if the start hour is too early */ (CASE WHEN HOUR(`startdate`)< 9 THEN /*move the start…

You could do a case statement to look for each color in the string, but I think you will need to create a beast mode for each color. For example, the red beast mode would look like this (CASE when `String` LIKE '%Red%' THEN 1 ELSE 0 END) Blue would look like this (CASE when `String` LIKE '%Blue%' THEN 1 ELSE 0 END) You can…