Please accept my apologies in advance, been out of Tableau development for 10 months and have forgotten a lot, now find myself faced with a can of worms and a three-day deadline argh!
Basically, I just need a horizontal stacked chart that enables the end user to select the customer in question using the radio-button quick-filter for which they shall then be represented against the top 25%, average and bottom 25% of all the other customers displayed as the four marks (see mocked pick)
Unfortunately, to get my if statement to work, I have had to de-aggregate my measures and with just the selected customer, I cannot remember even the basics (it shall all come flooding back soon but spending soo much time doing complex querying and making Excel vba to Oracle user tools has knocked me for six); result is, I cannot remember if I'm going in the right direction or not.
Please help, I in the meantime shall sit here with my nose pressed against both the fundamentals and advanced coursebooks from last Summer...
Steve
Attached is my first pass. I am not sure if I understand the exact computation that you want, but I am sure anything that you want can be achieved.
You can get all four stacked bars in a single sheet with a refresh rate of less than 10 seconds.
It uses a few tricks, so it is likely not an intutive approach.
You are welcome to contact me via the email in my profile to set a screen sharing session if you want to dive into this approach, or adjust it to fit your exact needs.
