I am trying to build a data table visualization which will provide data with "filters" sub-aggregation in different columns in a single file.
When I use "Split Table" within buckets, I get as many files as the number of filters.
When I use "Split Rows", it gives me data in a single file, which is what I want, but I want them in different columns not in different rows.
How can I get this in different columns like this?
|SHAPE |RDC1 |RDC2 |RDC3 |RDC4 |
|0022princess|2400 |2501 |2475 |2492 |