Blank Values representation in Bar Charts

[sagar_vij99]

Is it possible to show NA as bar in a bar chart for a dimension when a field has blanks in it..?

Example :

Process,Internal_Errors,External_Errors

Construction,10,8

Casualty,5

IPC,6,7

Now Process is my dimension and sum(Internal_Errors),sum(External_Errors) are my expressions.

is it possible that chart shows me 2 different bars for each value in process(dimension) and in case of Casualty one bar will show data point value 5 and other bar shows NA..?

*I can replace blank values with NA in the data if required.

Any help or suggestion is appreciated..

[Anil_Babu_Samineni]

Like this?

[sagar_vij99]

Anil this will also work, how did you manage to bring NA.??

It would be great if i can get this NA next to Blue bar in the chart.

something like this, kindly ignore the numbers in the chart :

[Anil_Babu_Samineni]

I have enabled the Text on Axis feature for that expression. And i used below expression

If(sum(External_Errors)=0, 'NA', Sum(External_Errors))