Jackie, please widen out your first screen shot so we can see how your data is structured. Thanks,
Thanks Shawn, I widened the first screen shot.
- Go to Show Me and click the line chart type.
- Now take SITE_TEXT off the row shelf.
That should do it. You should have a line chart, with a line for each individual city.
Thanks... when I click on the Show Me and then the Line-discrete (because it won't let me select Line-Continuous, the result is the screen below. I lose the original values that were computed by the Reference Line - (92%, 71%, 93%, etc.).
Also, I tried just changing the Bar to Line under "Marks" to the left and it shows the following (same thing - I lose the original Reference Line values).
Jackie, without playing around with it, I'm not sure I can help. Sorry,
Jackie, What are you trying to show with the % of Total Distinct Count of CUST_ID ?
The % of Total Distinct Count of CUST_ID shows the % of total distinct Customers from each site.
In this view, I'm only "Keeping" Customers that have a MET_GOALS_REV (# Goals Met) value of 3 or 4 because that's what I'm interested in Graphing. So each site adds up to 100% as follows:
Charlotte - Dec 2012
% of Customers who meet 1 Goal = 2%
% of Customers who meet 2 Goals = 6%
% of Customers who meet 3 Goals = 52%
% of Customers who meet 4 Goals = 40%
The total of 3 & 4 is 92% (52% + 40%) - that is what I'm trying to graph.
Try these steps:
1. Remove Parameter: Dummy from the rows shelf
2. Remove SITE_TEXT from Rows shelf
3. In the Marks shelf change mark type from bar to line
4. Right click on CNTD(CUST_PERSON_ID) in the rows shelf and choose 'Edit Table Calculation'
5. For 'Summarize the values from' choose Advanced
6. When the Advanced popup opens, Move [Month, Day, Year of PERIOD_REP] to the Compute Using section on the right
7. Close all popus with OK or APPLY
Let me know if this works
Can you try clearing the the Level of Detail shelf and removing MET_GOAL from the column shelf
Jackie, Why did you have AGG(MET_GOAL on the columns shelf in your original view? Not sure if that is causing any inconsistency. Would be difficult to tell without looking at the actual data.
Heres what I would do. Right click on the tab name at the bottom and select duplicate as cross tab. Once you have the datasheet view, try modifying the CNTD(CUST_PERSON_ID) field so you have accurate percentages. The problem you are facing is not a formatting issue, Its the way Tableau calculates % of total distinct IDs
I had AGG(MET_GOAL on the columns shelf as I wasn't sure if I need it to keep only the "3/4" values for this field. The values don't change whether I keep it on the columns shelf or not.
Also... do I need to do anything with the "Percentage of" in the Analysis menu? It is currently set to "Column in Pane".
I've tried playing with both the Analysis menu and the CNTD(CUST_PERSON_ID) field to get the accurate percentages with no luck. I tried that even before posting this. The line graph above is the closest I've gotten however to what I want.
The percentage of should be set to 'None'