Using a table calculation as a dimension

tableaucommunity@tableau.com — Fri, 20 Mar 2015 21:18:15 GMT

I have casino data that tracks players (by an ID) and the min bet limits of the tables they bet on. Each row is a 'player session' which begins when the player sits down at a table and ends when the player leaves that table. If the player leaves and then returns or visits another table, then a new row of data is recorded.

I have created a table calculation, TableMinGrp, to display the most frequently visited table minimum limit for each ID. I want to classify players by this value. For instance ID #1000 may have bet most at $100 tables and so is classified as such and grouped with other $100 players. I then wanted to plot, either in bar or pie form, the percentage of bets made at other tables minimums. So maybe $100 players bet at $100 tables 60% of the time, $50 tables 30% of the time, and $200 tables 10% of the time. I have created such a visualization with my table calc but now have run into an issue with the tooltip. Unfortunately the level of detail is by ID so hovering over gives a specific player's percentage (instead of the cumulative percentage for the table min limit). This should be able to be solved with a simple window_sum, however I cannot seem to partition by my calculated field TableMinGrp. Despite it acting like a dimension in my view it cannot be dragged there or used as one. I am hoping there is a workaround for this, or if not, that there is some way to accomplish what I want without table calcs.

I have attached a sample workbook of data with my viz.

Return most frequent value

tableaucommunity@tableau.com — Fri, 10 Oct 2014 16:12:43 GMT

Hi there,

I have casino data that tracks player ids and each of the table minimums they bet on. The player id repeats through the dataset with varying table minimums each time. I would like to create a field, "FrequentTableMin", that returns the most frequent table minimum for each distinct player id. (I have accomplished this much with a table calc, but I am thinking I need to start over to accomplish the rest)

For each FrequentTableMin value I want to create a stacked bar chart (or pie chart) that displays the percentage of bets made elsewhere. Essentially I want to answer the question: of people who bet most frequently at $x, what other minimums are they betting on? So for 'FrequentTableMin = 100' players, maybe 40% of their bets are at $100 tables, 25% at $50, 5% at $1000, etc..

I also have filters such as gametype, pit id, etc. that I would like to have update the information. For example with all gametypes, player A may be a $100 FrequentTableMin player, but when limited to blackjack he becomes a $50 player. I want this reflected in the output.

I would greatly appreciate any help. Attached is a subset of the data as csv.

Content in Tableau Community Forums

Using a table calculation as a dimension

Return most frequent value