single value with trellis

[Mike6960]

I am trying to get an single value visualisation with trellis. Somehow I get only one value, while when I use e.g. an Column chart i do get multiple values

My search | stats count by BNK|table count BNK

What am I doing wrong?

[niketn]

@Mike6960 even if you reverse the table fields to |table BNK count it should work. However separate table command is just an overhead. Stats is good enough for Single Value Trellis.

[Mike6960]

Thanks, it works.I think I made an error before, I did not get any options in the 'Split By' in the trellis menu before

[KailA · Accepted solution]

Hello,

Just remove the table count BNK and your trellis should work

[Mike6960]

Thanks, it works.I think I made an error before, I did not get any options in the 'Split By' in the trellis menu before

[KailA]

Great ! Can you Accept this answer to close the question ? Thanks 🙂