Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a bar chart and set as master visualization, and want to use it in the trellis container.
even if the bar chart is ok, the trellis container won't show any data.
could you pls check what's wrong with it?
bar hight: sum({<[Actual/Forecast]={'Actual'}>}[Value(CNY)])/1000000
I had the same issue.
I found a solution that work for me.
If I added the Dimension of the Trellis Container as a calculated Dimension and then use this dimension for the container it worked.
Best
Thanks for your sharing~
And, I found one tip that, if the measure is the sum function, there's some difference:
OK to show the data: Sum(if( condition , field ))
Can't show data: Sum({<condition>}field)
Thanks !
I also found why a calculated dimension worked for me.
In fact the issue is that when you add a dimension, it sometimes put the equal sign before de set analysis which broke it.
Example :
sum({<[dimension] = {'A'}>} Sales) = WORKS
sum({<=[dimension] = {'A'}>} Sales) = DOESN'T WORKS
I thinks they should get rid of the equal sign when they inject the dimension in the measure to solve this issue.