Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Once I got the columns named appropriately, it was a simple use of a few Multi-Field Formula tools and a filter before creating the appropriate chart similar to the output.