[RSno0b]

Hello members,

Sorry this is for NA only. Maybe I can get a dataset for other regions to add in the future?

I've been working on a way to view @Shoey's VIN spreadsheet, which he is scrubbing from ETIS (in a basement somewhere in Mexico) :wink-new:. So I created a dashboard, basically what I do in real life, to breakdown his google spreadsheet which he posts here

Here is the link to my dashboard.
Desktop:
https://public.tableau.com/views/Tracker_2/Dashboard1?:embed=y&:display_count=yes&:showTabs=y

Mobile Version:
https://public.tableau.com/views/NAVINTrackingforFocusRSmobile/Dashboardmobile?:embed=y&:display_count=yes&:showTabs=y

Currently it only tracks VINs that have been built. I didn't think it would be helpfull to list all 1,755 VINs since those that aren't produced don't have any other info other than date vin was assigned. You can type in your VIN in the search box, located on the top right, and select it from the list below if it is available to check out your order.

There is some cool info like the a table that shows the breakdown of cars produced by color, seat option, moonroof option. Unfortunately the dataset doesn't contain wheel options, so i couldn't add that.
Of course, Rs2 w/ Moonroof w/ NB color is the most popular :victorious:

You can also see things like how long did it take to move from date VIN was assigned to being built. Average time it took for currently built orders is about 2 weeks.

Let me know your thoughts. Likes\Dislikes....etc.

-KB

Report Updated On: 4-19-2016

 

[wewt]

Like.

 

[RSno0b]

Like.

Thanks!
I'll periodically check the VIN thread for any updated spreadsheets from @Shoey and update the report accordingly.

 

[RS 350]

Like.

^^^ this

 

[kbrd]

+1 for Tableau

We're currently stuck on a legacy version of JasperReports D:

 

[RSno0b]

+1 for Tableau

We're currently stuck on a legacy version of JasperReports D:

Yikes :rolleyes-new:
Tableau does make things so much easier.

 

[Slider]

Very cool, man. Thanks for this.

 

[RSno0b]

Very cool, man. Thanks for this.

Yeah no problem. I had loads of fun creating this. Took me a couple of days to edit, but it's a work in progress.

 

[tbone]

Currently it only tracks VINs that have been built. I didn't think it would be helpfull to list all 1,755 VINs since those that aren't produced don't have any other info other than date vin was assigned. You can type in your VIN in the search box, located on the top right, and select it from the list below if it is available to check out your order.

Thanks for doing this! Looks cool as hell.

Mine has been built, but the VIN (13692) doesn't pop up when I type it in the search field. Am I doing it wrong?

 

[RSno0b]

I was able to see your VIN.
Hit the [Enter] key after typing in your VIN to see your vin appear in the list. Let me know if you still can't see it and i'll post a pic.

Thanks for doing this! Looks cool as hell.

Mine has been built, but the VIN (13692) doesn't pop up when I type it in the search field. Am I doing it wrong?

 

[tbone]

I was able to see your VIN.
Hit the [Enter] key after typing in your VIN to see your vin appear in the list. Let me know if you still can't see it and i'll post a pic.

I found it now just by entering the last digits. Thanks.

 

[FoRS214]

@RSno0b,

Very cool thanks a lot.

 

[North3rn]

Great job dude. The most interesting thing I noticed while looking at the figures (because mine hasnt been built yet) is that the NB colour is by far and away the most popular on the RS2 w/moonroof cars. It is the most popular choice on other versions but not by nearly the same overwhelming margin. Made me go hmmmmm.

 

[Koonster]

Damnnn son, that's pretty sweet!!!

 

[RSno0b]

Thanks for the positive feedback everyone.

I made an edit to the dashboard. Now it shows the actual Focus RS, in its appropriate color, for the Color option.

 

[Kung Fu English]

This doesn't work on mobile any fix?


Sent from my iPhone using Tapatalk

 

[RSno0b]

Let me know if this link works? I scaled it for better viewing on mobile (landscape mode). I tested it and it works on my Android phone (Nexus 6p)
Mobile Version:
https://public.tableau.com/views/NAVINTrackingforFocusRSmobile/Dashboardmobile?:embed=y&:display_count=yes&:showTabs=y

This doesn't work on mobile any fix?


Sent from my iPhone using Tapatalk

 

[NoRagrets]

I don't see my Vin on there but I was on shoeys list and I am produced awaiting shipment. 4193

 

[RSno0b]

Have you tried typing in your partial vin in the search box? It's located above the List of VIN #s on the top right.
I've posted a pic of your VIN.

I don't see my Vin on there but I was on shoeys list and I am produced awaiting shipment. 4193

 

[NoRagrets]

Have you tried typing in your partial vin in the search box? It's located above the List of VIN #s on the top right.
I've posted a pic of your VIN.
View attachment 7736

Yea literally typed the same exact thing you did and it came up with nothing
The stats are wrong though. I have a moonroof