Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Cybb9870
Contributor II
Contributor II

Trellis container doesn't show data

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?

Cybb9870_0-1622448653431.png

bar hight:  sum({<[Actual/Forecast]={'Actual'}>}[Value(CNY)])/1000000

Cybb9870_1-1622448733371.png

 

3 Replies
AlexTheTRex
Contributor II
Contributor II

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

 

 

Cybb9870
Contributor II
Contributor II
Author

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)

AlexTheTRex
Contributor II
Contributor II

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.