I'm pretty new to Tableau, so unsure exactly how to go about this:
I have a company with 29 different teams. Each team has 10-15 members on it. Each member had a 20 day span for sales. Either they sold something, or they didn't, 1 or 0. I would like to display a graph that calculates for each team, only the number of members that sold something on every day of the 20. Thus, if you sold on 19/20 days, you're counted as a 0, but if you sold 20/20, you're counted as 1. Thus with an output of:
Team A: 10/15
Team B: 14/15
Team C: 12/15
I would then like to take those values to make a 2 variable graph comparing the number of miles driven by each team, and the number of perfect sales periods.
If you could attach sample data as twbx format and illustrate your expectations, it really help us to assist you.