How can create two dimensional filter containing Parent Field in X axis and Child field in Y axis

Question

Hi team,

I have a Cascading List field, containing some parent fields and related child fields.

I need to create a dashboard, with  two dimensional filter, containing Parent Value in the X Axis and Child Values in Y Axis.

How is it possible?

Can we have some other filters in which we have this possibilty?

Thanks,

L.

Nic Brough -Adaptavist- · Answer

You can't do this because a cascading select only really holds one value - the second half of it (the child field) is the value.  So if you put the list in as a group-by in a statistic gadget, you'll get an axis that gives you all the parent and child values, grouped together.

The cascading select field is a single field, not a dependent pair.

John Funk · Answer

Hi Lucia,

No, this is not possible because the values of the fields used by the X and Y axes must be in the same issue.