Check this out. Added two new filters to
the horse race chart that enable some fascinating ways to narrow the list of competitors.
One filter lets you choose only competitors between a defined range of total supercharger visits. In the visualization, it is called "Total SCs visited." In the graphic below, I narrowed the view to only those competitors with 400-600 visits. That's just me,
@IT Geek, and
@NKYTA. The annotations show how to adjust and use the filter. So, if you're
@bmah, you might set it to 70-90. What's so neat about this as compared to the graphic in our spreadsheet is that the upper and lower bounds can be set by you between 0 and the maximum number of superchargers visited by the leader.
The second filter is labeled "Running Sum of visits." In human language, it would be this: show me the total number of supercharger visits over time for each competitor but only during the window from X to Y supercharger visits.
In the second graphic below, I combined the two filters to create a view that does the following
- Shows only competitors with 300+ supercharger visits
- Shows their plots only from the time they crossed 200 visits to the time they crossed 300 visits. @Darren S and @Tdreamer are almost vertical lines through this window. @PLUS EV is just a dot because we don't have good date data for his visits back then, which is something Darren and @JSergeant are trying to dig deep into history to see if they can reconstruct.
Of course, all the other filters remain active and work in concert with the filters above. So, you could narrow to just competitors from the West coast, or select only a specific set of competitors, or down select to specific countries.
Finally, I discovered that Tableau allows anyone to download the data set that is behind any specific visualization. The second graphic below shows where to click to get the data. So, for instance, if you wanted to conclusively show who went from 0-100 the quickest, you would open all filters to include all values and then set "Running Sum of visits" to 0 and 100. Then, click the data download and import to a spreadsheet for easy calculations to see minimum time between 0 and 100.