Show/hide rules in trellised barchart visualization

[Paolo Monti]

Hi everyone, I hope someone can help with this issue I've been struggling a lot with.

 

My data set looks as follows:

 

Family Customer Value

A X 15

A Y 20

A Z 5

B X 2

B Y 7

B Z 9

C X 4

C Y 9

C Z 3

D X 5

D Y 8

D Z 1

 

 

I'd like a very simple trellis, made by two barcharts, with "value" on the y-axis, and series by customers", showing the values for the "top-2" families, being them ranked on the values of "Customer" Y.

 

 

I cannot find a proper show/hide setting to make that happen.

 

My last tentative was:

 

Show top-2 defined as follows:

 

Sum(if([customer]=Y,[Value],0))

 

 

This show hide/rule properly shows the top 2 families trellis, however hides all the other "customers" from the barcharts.

 

 

Any suggestion

[David Boot-Olazabal]

Hello Paolo,

I am not sure if I understand correctly your request. I have added a dxp file in which I have trellised your data, based on customer C.

The first bar chart shows the top 2 families, the second bar chart shows all families. But I am not sure if either one is what you are looking for. So if you can have a look at the attached dashboard and tell us what it is you are looking for, then we can see if that can be done in Spotfire.

Kind regards,

David Boot-Olazabal