I'm fairly proficient with Data Table visualizations, but have mostly kept them to 2-3 columns. E.G.
|bucket|count| or something like
Now I'd like to do something a little more complicated. I'd like to bucket the data table as usual, but I'd like many columns. I don't mind if I have to define each one individually, but I want something like
|bucket|count where 'result' field NEGATIVE|count where 'result' field POSITIVE|count where 'accepted' field is ACCEPTED|count where 'accepted' field is REJECTED|.
However, the only way I know to get counts for various fields being a specific value is the query and filters at the top (which would eliminate other values of
accepted). Also, the only way I know how to add more columns is to add more metrics. Is it possible to add a filter to a specific metric? That's the only way I have thought of that might make this work.
Am I overlooking something?