topic Re: Trellis chart of multiple charts per dimension in App Development

Trellis chart of multiple charts per dimension

L_VN — Fri, 06 Sep 2024 14:09:11 GMT

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?

Re: Trellis chart of multiple charts per dimension

Kushal_Chawda — Fri, 06 Sep 2024 15:34:23 GMT

@L_VN Is there any measure you are using or just two dimensions you want in Table?

Re: Trellis chart of multiple charts per dimension

L_VN — Fri, 06 Sep 2024 18:15:21 GMT

In the real life scenario I also want other fields too but no measure, mainly just a bunch of dimensions.

Re: Trellis chart of multiple charts per dimension

Kushal_Chawda — Fri, 06 Sep 2024 20:02:43 GMT

@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.

Re: Trellis chart of multiple charts per dimension

L_VN — Mon, 09 Sep 2024 08:23:21 GMT

This is done in the master visualization item. If more columns are to be added they all need to include the filtering. Thank you!

Re: Trellis chart of multiple charts per dimension

Kushal_Chawda — Mon, 09 Sep 2024 08:25:51 GMT

@L_VN Indeed. you need to create a same calculated dimension for all other dimensions