Good catch. I'll make sure the filter is set correctly to just those that are open. I'll also make sure the filter is available on the actual graph tab so users can see the count in any way they like.
-
Want to remove ads? Register an account and login to see fewer ads, and become a Supporting Member to remove almost all ads.
Superchargers visited 3.0
- Thread starter juliusa
- Start date
@Graffi, here is a direct link to your map. Try clicking into the Highlight box on the right side and then mousing over the years. If you want to see open superchargers that you haven't yet visited, simply toggle "open".
Tableau Public
@cpa, here is a direct link to your map. If you want to see by year, we'll need you to add dates for each visit. We can do this for you, or we can give you edit access to your column. You can generalize to yyyy or mm/yyyy if you don't have specific dates tracked. Send us your email via private conversation.
Tableau Public
@[email protected], I'll add your maps when data is entered.
The leaderboard is on the first dashboard tile called "Most Superchargers Dashboard"
All visualizations are interactive.
@theflyer - great work on integrating this with Tableau and updating the spreadsheet with array formulas. Thanks!
cpa
Active Member
Thank you very much for your yeoman's work to add me. I will mess around to see if I have the cognitive ability to add the years.
I will be heading to the desert soon and plan to hit a handful of new ones.
I will be heading to the desert soon and plan to hit a handful of new ones.
GHammer
Dark Star
@ThisIsTrue, I've added your map to the Tableau Visualization. Here is a direct link to your specific map. There are tabs across the top to view the other visualizations and dashboards. There was a typo in one of your dates (3017). I've fixed that in the spreadsheet and it'll eventually get updated in the visualization. The neatest way to view your map is to click into the "highlighted thisistrue status" widget and then mouse over the years. As previously stated, if you want to get a view of open superchargers you've yet to visit, toggle the "visited" category on and either leave the years on or turn them off so you see a clean view of chargers to be visited.
ThisIsTrue
Re-member
Thanks much! (Typo: oops!) And I appreciate your pointing out the hover and "not visited" tricks -- I hadn't spotted those yet. Very cool.
Want to see your list of visited superchargers? Or anyone's list of visited superchargers? It is easy.
Just open the spreadsheet: Superchargers Visited
Click on the "Superchargers" tab on the bottom. Scroll right to the entry column for the competitor, and create a temporary filter view. Data - Filter views - Create new temporary filter view.
Then create the filter by clicking on the filter icon, "deselecting" blanks (which are the non-visits), and click "ok" and you will have a list sorted by country/state/supercharger.
Just open the spreadsheet: Superchargers Visited
Click on the "Superchargers" tab on the bottom. Scroll right to the entry column for the competitor, and create a temporary filter view. Data - Filter views - Create new temporary filter view.
Then create the filter by clicking on the filter icon, "deselecting" blanks (which are the non-visits), and click "ok" and you will have a list sorted by country/state/supercharger.
Last edited:
Blueshift is now accepting patrons to help defray his costs for Supercharge.info. I would hope everyone here will chip in:
Keith is creating supercharge.info | Patreon
Keith is creating supercharge.info | Patreon
Thanks for letting us know. Pledged at Tier 3 level. I hope everyone does the same.
In order to fill in the dates, I'm going back to various places where I tracked my trips. This was the first big trip in 2014 back when it was still a bit of a challenge to do long trips:
Shutterfly
Shutterfly
@tes-s has added a bunch more competitors to the spreadsheet. I've added them to our tableau visualizations. Competitors can click into the "highlight <username> status" widget and mouse over the years to get an interesting visualization. Get Tes-s your dates if you have them to further improve your visualizations (if you haven't already).
The "open" filter option shows all of the superchargers you've yet to visit. We're talking about renaming this status to "not yet visited" to be more intuitive.
You can save the following URLs to your favorites list for easy and direct access to your map.
So, without further adieu,
The "open" filter option shows all of the superchargers you've yet to visit. We're talking about renaming this status to "not yet visited" to be more intuitive.
You can save the following URLs to your favorites list for easy and direct access to your map.
So, without further adieu,
GHammer
Dark Star
Oops. Sorry about that @[email protected], I thought I'd already added you. Here is your map.Hi @theflyer any chance I can get my data added to the map?
I made a couple tweaks to the tooltips so when you hover over one of your locations, it will now show when that supercharger opened and when you visited (if you've provided us dates). Here is an example from AzEd's graph.
We made a couple more tweaks. We eliminated the "permit" entries. We cleaned up some data so there is no longer an "Open - Limited" category and we removed the "Not public" entry (Cleveland) as only public SCs can be part of this competition. @Sasmania was the only person with Cleveland marked on his list of those we've imported, so his count decrements by one. Sorry sasmania.
I think we now have the canonical list superchargers for the competition. If you don't see a North American location on our spreadsheet that you believe should be there, let us know.
We also modified our algorithms so if there is an open supercharger that you haven't visited yet, it will be classified as "Not yet visited," which makes our Tableau filters much more intuitive.
We made a couple more tweaks. We eliminated the "permit" entries. We cleaned up some data so there is no longer an "Open - Limited" category and we removed the "Not public" entry (Cleveland) as only public SCs can be part of this competition. @Sasmania was the only person with Cleveland marked on his list of those we've imported, so his count decrements by one. Sorry sasmania.
I think we now have the canonical list superchargers for the competition. If you don't see a North American location on our spreadsheet that you believe should be there, let us know.
We also modified our algorithms so if there is an open supercharger that you haven't visited yet, it will be classified as "Not yet visited," which makes our Tableau filters much more intuitive.
GHammer
Dark Star
We can easily retreive them from history if there is consensus to do so. Now that it appears supercharger.info will stick around, I'm personally less worried about this spreadsheet being a backup and there doesn't seem to be much value in terms of this competition.
We did keep under construction entries.
Similar threads
