MarkSnodgrass Coach

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…

In your sample scenario, it seems like the overall yield should be 75%, not 56%. I'm not clear as to why you would be multiplying the individual station yields together. If you thought of all the production as one station, you would have 7+8 and 10+10 which would give you 15/20 or 75%.

I think ETL is definitely the way to go on this. I think a combination of MAX and SUM would get you where you want to go. Could you provide a screenshot of what the end result of your sample data would look like? I'm having a bit of a hard time visually what you are looking for based on your description.

You may want to look into the recursive dataflow option. You can do it in SQL or ETL. Here are the two articles to look at: SQL: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_SQL_DataFlow…

Glad that works for you. To limit to 1 is really easy. 1) Add your Marks column to the Sorting section and sort by Descending. 2) Go the data table properties and change All Rows to 1 by typing 1 in there. (If you don't see your data table below your chart properties, make sure Data Table is selected in the navigation…

Following this thread with my updated profile. Mark

@hamza_123 My suggestion would be to create beast mode field called image url that just looks for the person's name and then build the proper HTML to display the picture like this: CASE WHEN `Student_Name` = 'John' THEN CONCAT('<div style="text-align:center"><img alt="DOWN" height="200"…

@hamza_123 What card do you want to use to display this information? The table card was just a suggestion so you can easily verify the results. The MAX function should still be available as a calculation type in other card types that you can choose from.

Assuming your MAX value is numeric, I don't think you even need to use a beast mode for this. (Although, there is MAX function in the beast mode.) For example, start with a table card and then drag your student name in as one column and then drag your Marks column as another column. Click on that column and choose Maximum…

In the appstore there are two quickstart apps that show you the usage of your instance. Just search for "domostats" and you will see two show up that you should use. You can also search for "governance" and there will be a connector called "Domo Governance Datasets". This has a number of datasets you can pull depending on…

Here is how you can format numbers into currency values and using the B, M and K abbreviations for billions, millions and thousands since showing the full numbers would make the summary number extremely long. In this example, the resulting summary number would look like this: $10.74M Total Written Premium | $19.47M Total…

You can display multiple summary numbers by using the concat function along with an aggregate function. It would look something like this: CONCAT('$',ROUND(SUM(`YourColumn`),0), ' Total for this column | $',ROUND(SUM(`YourOtherColumn`),0),' Total for the other column') The downside is that it won't automatically format…

Apparently, it is an idea that was submitted to the ideas exchange a while back, but still hasn't made it to production. You can vote it up here: https://dojo.domo.com/t5/Ideas-Exchange/Multiple-Values-in-Hover-Over/idi-p/7023