1 2 3 Previous Next 35 Replies Latest reply on Feb 10, 2016 9:32 AM by Joan Armande

# Stem and Leaf type chart?

I'm trying to do something that seams simple but isn't obviously so.

I'd like to create something like this first picture where I have a continuous measure along the x-axis. Then I  want one category to plot above a line and the other in another color but below. But dimensions can't be straddled across a line like this. However, I'm stuck at the second picture. I've created bins which are needed to stack the marks but I can't seem to come up with an idea that will group the reds from the blues and would put them above and below a line. I thought that maybe a calculated field might help where if [dimension] equals B then [measure]*-1 but that means that if a value is far from zero then that mark plots too far away from the line rather than in either picture below.

I don't have a workbook to share but anyone have any ideas?

• ###### 1. Re: Stem and Leaf type chart?

No exactly same , but here is my approach.

Create Bin on "Value" // in this case

And put in the Columns

Create calculated Field

[Reference Line]  /// Actually any value works.

{Fixed :sum([Value])}

and Put this field to Column X 2

Create "Bar Chart" and set color as you like for both bar as back ground

Edit Axis of bottom chart

Create Calculated Field  // You can change the Mark from "O'" to something else by changing "Font"

[Mark A]

left("OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO",sum(if [Type]= "A" then 1 END))

[Mark B]

left("OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO",sum(if [Type]= "B" then 1 END))

Put [Mark A] to the label of Top Chart and [Mark B] to label of Bottom chart.

Set alighnment

Expand Bar size

Thanks,

Shin

9.0 attached.

• ###### 2. Re: Stem and Leaf type chart?

Hi Joan/Shin-

I used the data Shin attached.  Would this get you there?

Instead of bins, I made value a discrete dimension.  Analysis->Aggregate Measures Off and Stack Marks On.

Value Calc on Rows.  The real Value and Type Total in the marks card for the tooltip.

Value Calc

IF [Type] = "A" THEN [Value]

ELSE -[Value] END

Type Total

{fixed [Value],[Type] : sum([Value])}

9.0.8 workbook attached.

1 of 1 people found this helpful
• ###### 3. Re: Stem and Leaf type chart?

Quick question.

Does this work on Bin's case, or only work in absolute value case?

May be additional calculation field help to create group of values?

Shin

• ###### 4. Re: Stem and Leaf type chart?

Hey Shin-

Yeah this only looks the same because you were doing bins of 1.  If you wanted to group the values, then bins would be the way to go.  Looks like Joan's sample photo the bins are \$10k.

• ###### 5. Re: Stem and Leaf type chart?

Shin

• ###### 6. Re: Stem and Leaf type chart?

No problem.  I attached my approach using a bin of size 3.

1 of 1 people found this helpful
• ###### 7. Re: Stem and Leaf type chart?

Finally understood what I was missing !!

Still need to learn more and more.  But that's the fun !!

But I'm posting crazy approach which I sometimes feel ashamed..

[Incorrect]

[Correct]

Thanks again.

Shin

• ###### 8. Re: Stem and Leaf type chart?

Haha, I thought it was pretty creative actually!

• ###### 9. Re: Stem and Leaf type chart?

Just one more quick confirmation...

When the situation becomes the case that one circle should show "Ten" or something other than "One", Non-Aggregated Stack Mark "ON" still works???

Thanks,

Shin

• ###### 10. Re: Stem and Leaf type chart?

Hmmm, it might need to change then.  If you had a dimension/group that grouped them into buckets of "ten" then it would work. If you are having to do a table calc or something to do it, it probably wouldn't.

• ###### 11. Re: Stem and Leaf type chart?

Thank you for using your brain for my questions.

Many thanks.

Shin

• ###### 12. Re: Stem and Leaf type chart?

This is such a great solution I wish I could use it!

My problem is that I am blending two separate data sources so LOD calcs are not an option in my case....any suggestions?

• ###### 13. Re: Stem and Leaf type chart?

This is right on the mark...except my data is blended so LOD won't work for me. However, I'm tempted to figure out a database level blend so that I can use this approach!

• ###### 14. Re: Stem and Leaf type chart?

Do you need the total in the tooltip?  That is all I used the LOD for.

1 2 3 Previous Next