Welcome to the forums. You'll quickly find that very few things are impossible in Tableau, and the community is very good at finding creative solutions.
In your case, the solution might be relatively easy. Just create two calculated fields,
- # members at or below the upper CI
- # members above upper CI
Add these as "measure values" to create a stacked bar chart. Add the measure names to the color shelf. I also added the individual measures to the level of detail shelf to use the values in the tool tip text.
You could also do a more traditional bar-chart type CI with dual-axis by using a dual-axis chart to combine a bar chart with a Gantt chart for the CI.
See that attached twbx. And shout if the above steps aren't detailed enough or this isn't quite what you were looking for. ...
tom_series.twbx.zip 35.6 KB
Many thanks for taking the time to think about my question. I'm afraid that I miscommunicated and oversimplified the question by neglecting to mention that I also have a lower conf interval and was interested in tinging the tips of a line graph. So a vertical bar chart wouldn't quite work where a line graph would.
Given that, what about a stock ticker type presentation? Tinging something like that could potentially work.
Thank you again,
Yes, you can "tinge" the line as it goes above or below a the CI. Or do many variations.
Start by creating a field to control the color: Count outside of CI =
IF SUM([# Members]) < SUM([LowerCI]) THEN "Below Lower CI"
ELSEIF SUM([# Members]) > SUM([UpperCI]) THEN "Above Upper CI"
ELSE "Within CI" END
Now you can add this to the color shelf to color the lines or dots.
You could also do a line chart with vertical bars showing the CI. Or, my favorite, replace the line with dots.
See attached twbx. ...
tom_series_v2.twbx.zip 80.5 KB
Hi Jim Wahl,
How to show values on data Points on line chart ??
Thanks in advance,