Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello. I am looking to create a trellis chart consisting of tables of order details per organisation (where Flag = 1), but I am struggling to limit each table to only consist of order for that organisation.
My script looks like this:
F:
[
Organisation, Order, Flag
Organisation1, A, 1
Organisation1, B, 0
Organisation1, C, 1
Organisation2, D, 0
Organisation2, E, 1
Organisation3, F, 0
Organisation3, G, 1
Organisation4, H, 0
];
I want a trellis consisting of tables like:
Organisation1:
Order: A
Order: C
Organisation2:
Order: E
Organisation3:
Order: G
My dimension in both my trellis and the chart is: Aggr(Only({<Flag={1}>} Organisaton), Organisation).
It works in that we get a trellis chart of only Orgs 1-3, but each table has all the orders with the Flag = 1. I want each table to only include one Organisation.
I've looked into the advanced mode but have not been able to make it work.
Could someone help me?
@L_VN try below
Create a table with below calculated dimension for orders. Uncheck Include NULL values option.
=aggr(only({<Flag={1}$(vDimSet)>}Order),Order)
Setup trellis container with advanced mode on.
@L_VN Indeed. you need to create a same calculated dimension for all other dimensions
@L_VN Is there any measure you are using or just two dimensions you want in Table?
In the real life scenario I also want other fields too but no measure, mainly just a bunch of dimensions.
@L_VN try below
Create a table with below calculated dimension for orders. Uncheck Include NULL values option.
=aggr(only({<Flag={1}$(vDimSet)>}Order),Order)
Setup trellis container with advanced mode on.
This is done in the master visualization item. If more columns are to be added they all need to include the filtering. Thank you!
@L_VN Indeed. you need to create a same calculated dimension for all other dimensions