Spotfire Ideas Portal
I have a treemap with variables for size, color and hierarchy (MultiSelectListBox). I would like the label of the hierarchy + the label of the color/size value.
Initially I have <$map("${Hierarchy}", " nest")> that work.
So I tried <$map("${Hierarchy} & ${Axis.Color.Expression}", " nest")>
but it doesn't aggregate over ${TreillisBy},${Hierarchy}.
Adding the over clause doesn't work anymore.
I tried for my main color kpi so: NetSales/Sales
<$map("${Hierarchy} & String(Sum(NetSales) over (${TreillisBy},${Hierarchy})/Sum(Sales) over (${TreillisBy},${Hierarchy}))", " nest")>
but when TreillisBy is null it doesn't work.
Hello Guillaume, and thank you for this idea. Apology for the long overdue review, this idea was not visible in the Spotfire Ideas workspace until today.
How is your hierarchy setup ? Is it from a hierarchy column created outside the visualization ? or the hierarchy is directly setup from the visualization ?