Clickable Bar without dimension

[#1]

Hi Team,

Below is my table and chart. If I click the bar, it should show it individually. I took 3 expressions each has count(field) but no dimensions.

Table:

LOAD * Inline [

ID1,ID2,ID3,Date

1,18,31,12/12/2014

29,15,31,11/12/2015

10,13,1,10/12/2015

12,13,1,11/19/2015

];

Please suggest

[rwunderlich · Accepted solution]

The only thing I can think of is to load a data island with a proxy dimension and use that as the chart dim.

LOAD * INLINE [

ProxyDim

1

2

3

]

;

Then use ProxyDim as the Dimension, and an expression of:

Pick(ProxyDim

,count(ID1)

,count(ID2)

,count(ID3)

)

You can color the background as:

=color(ProxyDim)

Not sure how to get a legend if you need one. See attached.

-Rob

[#3]

Thanks so much Rob, that was wonderful