Not really on topic since the meeting already occurred, but what is the easiest way to find out about upcoming meetings? I happened to see that one took place after the fact simply because I have InterWorks on my google+. Wish I could have attended, so just curious how to be notified?
Thanks to everyone who is working to get an OKC TUG together. I'm in SW OK, but looking forward to attending the next.
Hey Justin! We've decided to meet every 3rd Thursday at Noon at Sonic HQ. We may not be meeting in Nov or Dec but will determine that as we get closer to those months. Hope that helps!
Thanks Amber. Yes, we will meet every 3rd Thursday of the month at Sonic HQ, 300 Johnny Bench Drive. Lunch provided. Invite should be coming soon.
One issue I've been stumped on is top/bottom X items on a dynamic chart. If anyone has any examples they can share, it would be very helpful.
For example, I may have a primary simple bar chart that has all customers and their sales. The bars are tied to actions that filter a secondary chart for products (sold to that customer). If I want that products chart to reflect only the top 5 products (for the customer selection), I am out of luck, the existing "top filter" works on the entire dataset, and not the context of existing filters (such as month, or combination of months).
The alternative is to use an external aggregation engine, (which is what I am doing right now), but it's far from ideal. Tableau's internals operate on a tabular data model (as described to me), so it seems we should be able to do this kind of thing.
Looking forward to the next invite.
I am currently struggling with calculating employee turnover. I know the formula (# of Terminations/Avg # of Employees) but not sure how to do this in Tableau and how my data should be structured. I need this stat to be dynamic based on location, dept, timeframe, etc. I've tried every example I can find online but can't seem to get it to come together. Any insight would be super awesome. I can provide dummy data in a packaged workbook if that would be helpful to anyone willing to help me tackle it.
If you would like help with this before our meeting I may be able to help you out or if they do not get to it at the group meeting you can find me there after and I can take a look!
Thanks, Jessica! I will keep working on this week but will connect with you on Thursday. Thank you!
Amber if you want to send over that with dummy data we can work on that and see if we can get you an answer.
Philip, Can you provide a dashboard with your data and we can address that also.
I think we can solve your problem Amber but I would need to see Philips data set and how he is doing things.
you can attach it here or send it to email@example.com.
Thanks, Mark! Emailing it to you now.
Sending a sample to mark at the email address listed.
First I put a "top 2 parts by sales" on the parts.
Then I add a division filter. When viewing both divisions (east and west), we see that the top two items are in fact visible. But when switching to just west, we only see 1 part. I'm trying to figure a way out to have tableau re-work the part "top two" filter by the visible divisions.
This is a very striped-down example; I actually need to accomplish this across 4 or so dimensions in my real dataset.