1 of 1 people found this helpful
This is one blog post I know of that discusses lollipop charts in Tableau:
If that does not help your scenario, it would be much easier to respond if we could see some sample data and a packaged workbook (twbx) in order to help. A lot rides on your data structure and what else you plan to do in the view (quick filtering, action filter drill downs, etc.) Your best bet is to mock up a scenario using Superstore Sales, if you cannot post your own production workbook.
I forget that stat, but we found out at the Conference that the # of questions with a packaged workbook had a FAR greater chance of being answered (and I would guess, answered with much more quality), when a TWBX is attached to the post. (Patrick Van Der Hyde: can you share that stat again? )
I hope this helps--if you need additional help in setting up a sample, feel free to ask. I often take a subset of my own records, blind them in Excel, and then use that in Tableau as my data source--so my sample workbook matches the granularity, etc. of my production data.
Here is a really basic sample of where I'm at so far:
I made a really basic set of dummy data but essentially it's like this, the lowest level is the line item level. Each item has a level.
Each item has an order # assigned to it. There can be multiple lines on an order.
Each order has a section. Only one section per order.
Each section has a region. Only one district per region.
Each order also has a group, which can either be us or them - I want to calculate, the % we, ("Us") orders we cut for each region, and eventually section.
If you need a better data set, I can, as you suggested create a blind set from my data, but I figured that'd add more minutia than necessary.
Thanks again for your help!
I do intend on filtering it by region too, and when I filter it out, I want it to be able to see the avg. % change, based on only the regions selected.
I'm going to try to do it with super sales quick to see if that makes it work.
Yes, it will be important to try and replicate all the functionality you want in your example. This is because we may go down one path, and end up with a solution--but as soon as you add another layer to that, the solution may break. So, try to set it up as closely as possible to the end result you want. Cheers!
Hey Matt and Patrick!
After running the numbers, it looks like questions with workbooks attached are answered approximately 38.5% more frequently than those without workbooks.
Was there any solution that was every displayed for this? I am in a similar situation where I would like the currently center off of the group average based off an index, but I would like the sticks of the lollipop to be centered off of the average, they currently start from 0.
It's difficult to understand your issue. This thread is quite long and don't want to spend time to go thru everything.
Could you post another thread with you own issue?