MarkSnodgrass Coach

Have you looked into using color rules? This allows you to use a certain color for specific values throughout your instance. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/KPI_Card_Building_Part_2%3A_The_Analyzer/Setting_Color_Rules_for_a_Chart You can tell it to apply it just to a card, or all cards…

I wonder if the distinct is throwing it off. Here is a beast mode that shows login failure rate that is similar to what you are trying to do. I got it from one of the cards in the DomoStats quickstart if you have that in your instance and want to compare. (COUNT((CASE WHEN (`Action` = 'FAILED_LOGIN') THEN `Action` END )) /…

I'm not seeing the attachment. Can you try sending it again?

I'm pretty sure you can't create new datasets, but you can have it append rather than replace when you set up your e-mail dataset connector. This would allow you to keep your historical data and you could set up your card to look at the most recent data and display only that.

On this page, https://learndomo.domo.com/learn/course/23/domo-basics-training-level-1;lp=10 , scroll down and in the bottom right section of the page there is the File Repository Area. Click on the Understanding Pages - Sample Data link to download the sample data.

The easiest solution would be to add an additional statement that resulted in "Brad/Scott" like this: case when `Customer Home Branch` IN ('207500','208500') then 'Brad/Scott' when `Customer Home Branch` IN ('203500') then 'Scott' end However, I think you are wanting to be able to have Brad and Scott listed individually.…

I would suggest using Magic ETL and using the Set Column Type operator. You can then tell it that you want it to be a text field and you wouldn't have an extra field created when you create a Beast Mode Field. If you are not wanting to create an ETL, the TRIM function as stated above looks like the best option. 

I don't know if there is a way to change it, but I know it is not specific to the pie chart card. That is how Domo has the legend functionality working on line and bar graphs as well with a legend. If you hover over an item in the legend, it isolates that item, but if you click on it, it will remove it. It could be worth…

If you aren't doing much in your Magic ETL, you might consider DataFusion, also known as Blend. It is much better equipped to handle datasets that are in the millions of rows. https://knowledge.domo.com/Prepare/Magic_Transforms/DataFusion

No, I'm familiar with DomoStats. That is not it. It is called Domo Governance Datasets. Here is a screenshot of it from the app store. Search in the app store for it under connectors and then choose Get the Data and select Dataset Schemas as the 1st dataset to retrieve.

If you look at this thread, you can do it with MySQL https://dojo.domo.com/t5/Data-Sources-and-Connectors/Deleting-records-from-a-dataset-using-MySQL/m-p/23359 Also, you could think about temporarily using the replace method and then go back to your append method. 

@hamza_123 If you look in the app store for Domo Governance you will see a connector that will get you what you are looking for. It has multiple datasets to choose from, but it sounds like the two you would be most interested in looking at are Datasets and Dataset Schemas. Hope this helps.

You could create a beast mode function to look at the time difference between the current time using the NOW() function and the timestamp of when the dataset was last run which is _BATCH_LAST_RUN_, like this: TIMEDIFF(NOW(), `_BATCH_LAST_RUN_`) You could DATEDIFF if you were looking at days instead of minutes and hours.…

I believe you can fix this by going to your workbench and click on preview for that dataset and then review the schema type to make sure the fields and data types are what you expect. I think I ran into this before and it was because the dataset was based off a SQL view that had changed or the dataset was using a SELECT *…

I'm not sure what card you are wanting to use to display your result, but have you tried using the filters to only show the items you are looking for? You shouldn't even need to do an elaborate CASE statement. Based on what you said, I would drag Name into the filters section and select A. I would also drag Support into…

That is strange because I have used it to update departments and job titles before. You may have to open a ticket with support, but you could also try just having one employee in your csv file and see if it can update a single person. That would possibly tell you that the data in one of the employees is constructed in such…

That's hard to say without seeing the file. You could try exporting the file and then importing it back in again without making any modifications. If that is successful then it narrows down what might be happening with the changes you are making.

No problem. Don't forget to mark it as a solution to help others that see this later.

No, it will know to update existing records. You can add people at that time if you want to, though. It will update or add as necessary.

@user19682 If you go to the People tab in the Admin section, there is a Bulk Export button in the top right. It will download a CSV file that lists all of your people. One of the columns in the file is Groups. Just add the name of your group in that column for everyone that needs to be part of that group and then use the…

@John-Peddle Ahh.. I understand now. Here's what you would want to do in SQL. Use the transforms to create 2 table, one holding all of the created dated, with an additional column called DateType and has a hard coded value of Created. The 2nd table would contain all of the resolved dates with an additional column called…

@John-Peddle I think what you are looking for is a recursive dataflow. Here is the KB article for doing it in SQL: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_SQL_DataFlow Here it is for ETL:…

@user34317 If you go back to the main page of that module, in the bottom right section of the page there is an area called File Repository. In that section, you can click on "Understanding Pages - Sample Data" and it will download the sample data to you desktop. You would then upload that sample data to your instance…

@Junior Have you tried using the card description to accomplish this? When you hover over the card title when you are on a page, the card description appears. You can write several sentences in this area.

@user04231 I'm not aware of being able to receive an e-mail if a card has an issue. I've only seen it for datasets and dataflows. Could be a nice enhacement, though. You could submit it in the ideas exchange section of Dojo if others confirm that this feature does not currently exist.

The Domo Knowledgebase recommends the following for datasets: https://knowledge.domo.com/Training/Self-Service_Training/Best_Practices_Resource_Guide/Naming_Conventions_Best_Practices#DataSets DataSets * Utilize suffix/prefix: PROD, INT, QA, or TEMP * Name DataSets using a common format (ex: BU_System_Dept_Suffix; have…

@user07184 You were close. Just a couple syntax changes. Change the OR to an IN statement. You also had a second CASE in there that shouldn't be there. This should work for you: CASE WHEN `Owner.Name` IN ('Name 1','Name 2','Name 3') THEN `Owner.Name` WHEN `Owner.Name` IN ('Name 4','Name 5','Name 6','Name 7') THEN 'CSG'…

That's unfortuante about the support option. Do you only have one card set as a scheduled report? I would try setting a scheduled report on another card and see what happens. I would also try deleting the schedule and re-adding it. Also, what shows when you go to your Admin section and click on Scheduled Reports and click…

It seems like you checked all the right things as far as mail flow is concerned. Did you check to see if an end date was entered on your report? I see that it defaults an end date to 3 months from the first report. If that is not it. I would suggest opening up a suppor ticket with Domo by sending an e-mail to…

According to this KB article, https://knowledge.domo.com/Optimize/Filtering_Data/02Applying_Page-Level_Filters, particpants cannot add or remove page filters. Also, any admin or editor can remove a filter, so a filter may have been removed by another user. Filters can also be hidden from view initially, making them…