Edward,

Assuming that every time you display an extra dimension of the hierarchy, new rows are added to the view.

And assuming you have an idea on the number of rows the view will contain at each level of the hierarchy,

you can compute the size() of the view (nb of rows)  and based on the result select to dimension to be used for the color.

In your example, you could use a calculation

if size() <= 4 then ATTR( [Tool Type] )

elseif size() > 4   and size() <=  7 then ATTR( [Tool Name]  )

end

compute using table down

In your real scenario, you may not have the precise values of each dimension size but you may be able to guess the boundaries

and return the dimension if the result is between those boundaries.

Michel

Edward,

Just add a    elseif size() >  X then  ATTR(Date)      where  X  is the maximum possible number of Tool Type/Tool Name groups.

The challenge does not come from the date dimension but from the  estimation of the number of   Tool Type-Tool Name  combination.

Let say that when  Tool Name is Exploded, you have 100 rows. If each tools have an avg of 2 dates, then the size() would be 200 when date is exploded.

So if you put  150  for X,  you could still add 50 tools  and the solution would still work.

But again , this is not a perfect solution,  it implies some guessing ,  and may need some adjustments in time  according to the dataset growth.

ps: my name is Michel Caissie,   Michael Casey  is another person.

Well this is different.

You can try to compute the number of date per Tool Type,  sum those dates  and compare it with the size()

Color would become

if size()<= MIN( [Day per Tool Type] )then ATTR( [Tool Type] )

else ATTR( [Tool Name]  )

end

where Day per Tool Type is

{SUM({FIXED [Tool Type]: COUNTD( DATETRUNC('day', [Activity Date] ) )})}