Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create a Dimension with set analysis to accomplish a "Compatibility map" using the Tree map visualization.
Once a "TASKNUMBER" is selected, I want to see all other TASKNUMBERS that share at least one of the same "ACCESS", "ZONE" and "PREPARATION" attributes.
Here is what I have so far.
aggr(ONLY({1<TASKNUMBER=, (Select all TASKNUMBERS regardless of selections)
ACCESS= p(ACCESS),
//(Select all possible ACCESS Values BASED ON SELECTION)
ZONE= p(ZONE),
//(Select all possible ZONE Values BASED ON SELECTION)
PREPARATION=P(PREPARATION)>}TASKNUMBER)
//(Select all possible PREPARATION Values BASED ON SELECTION)
,TASKNUMBER)
Perhaps this?
Aggr(Only({<TASKNUMBER = E({<ACCESS = P(ACCESS), ZONE = P(ZONE), PREPARATION = P(PREPARATION)>} TASKNUMBER)>} TASKNUMBER), TASKNUMBER)