MarkSnodgrass Coach

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

Have you gone to the Chart Properties and to the Hover Text Settings? In there, you can manipulate what you want displayed on hover. Click the + sign in the Hover Text textbox to add any of the commonly used values. You can also add static text by simply typing and add line breaks by adding \\n . Hope this helps.

Try removing the date column on the left. Since those dates have different timestamps, they are making the row unique. If you just have the person's name as a column and then the count of the person's name, you should see a proper count.

If you are just uploading a list of zip codes, I would suggest you make use of the ZipToFips connector in the App Store. It has all of the zip codes and their associated fips code, which can be used to power the map cards. It has the zip codes as strings to account for the leading zeros. You can then join this dataset to…

I have been looking for the same thing, but have not found a way to do this. It would be a great feature for Domo to add so that processes can be better documented.

How many rows are in your dataset? By default the preview only pulls the first 10,000 rows. If the ID you are trying to filter on is not in that 1st 10k, then your filter will come up empty. You can change the preview to pull a larger number of rows so that it pulls the ID you are looking for. You could also export the…

That is interesting that there is not a "multiply by 100" checkbox in the summary number formatting section like there is when you use a field in the main card area. If that was offered, you could just uncheck that box. Since that isn't option, you should create a calculated field and create the formula like this:…

I would love to see this is as well. I'm working on a custom connector right now, but not having much luck due to the way the ActiveCampaign API calls are structured.

I think the dashboard design has an issue with percentage. Here are some screenshots that may help you see what is going on.

Thank you. That was very helpful. I found a suitable svg file from that site and I am working on dividing it up into paths for each body part so that the data will match to it. I noticed in this training video: Custom Maps Regions that there is a body part card shown. Any chance that can be made available?

I decided to go in a different direction and get the data in the format I needed in the workbench rather than in the dataflow