Bar Chart

[#1]

How to hide the dimension if the value of the expression is null or zero in bar chart..

Thank you

[sunny_talwar]

May be try checking 'Suppress Zero Values' on the presentation tab of the chart properties

[#3]

Tried but no use..can we make the text color white conditionally for the dimension..

[#4]

Dimensions:

Month(Complete)

Accountable

Complexity

Expression:Count(Complete)

I need to disable the name in accountable for example ''barywhitlow'' in first group of bars

[sunny_talwar]

Would you be able to share the application?

[Anonymous]

Did you try creating a calculated dimension? Something like if(Count(Complete) >0, Accountable,). The result of this expression depends on the dimensions you have in the chart. Also, using Dimension Limit allow us to control the no. of dimensions to be visible but the options there may not be suitable for the use case there. Give a try.

[satishkurra]

Seems like this is a blank value instead of NULL.

Please try the below in load script:

Where

len(trim(ColumnName)) > 0

Or

In Calculated dimension

=if(len(trim(ColumnName)) > 0, 'NULL','ColumnName')

Thanks

Satish

[sfatoux72]

You cannot create asymetric bar chart.

''barywhitlow'' appears in the first group, because it have a value in the second group.

You can use the following trick:

• Create a calculated dimension ( Month & ' - ' & Accountable ) instead of using dimensions Month and Accountable
• Use expression to sort this calculated dimension correctly

The presentation won't be the same, but you will have only bars with data.

If it's good for you, you could creat this dimension directly in the load script

[rwunderlich]

When you have multiple dimensions, The value will show in all groups if there is at least one non-zero value in any group. Barry has data in February, so Barry will show for all months. The groups are always made symmetrical. And no, I don't think there is a way to color Barry's background white in just Jan.

Perhaps someone else knows a data trick.

-Rob

[#10]

Thank you fatoux i will try and let u know ...