single stack bar

[manoranjan_d]

hi

all,

below is my data

year	month	dept	AMT	ID
2016	JAN	CSE	100	1
2016	FEB	IT	200	2
2016	MAR	EEE	300	3
2016	APR	CSE	400	4
2015	JAN	CSE	500
2015	FEB	IT	600
2015	MAR	EEE	700
2015	APR	CSE	800	10
2015	MAY	EEE	900	1
2015	JUNE	CSE	1000	12

now i need the single bar chart of null and null values record count. how to achieve it?

where in the single bar it should differentiate the null and non null values

[MK_QSL]

Create a Flag inside Script something like this..

IF(IsNull(ID) or Len(TRIM(ID)) = 0, 'Null','NotNull') as IsNullFlag

Now you can use something like below

COUNT({<IsNullFlag = {'Null'}>}ID)

COUNT({<IsNullFlag = {'NotNull'}>}ID)

[manoranjan_d]

i m asking how to do it in chart of design.

[varshavig12]

Something like this:

exp:1   =count({<ID={""}>}ID)

exp:2    =count(Total ID)-count({<ID={""}>}ID)

[manoranjan_d]

expression i can easily use it, but in the graph how to show it in single bar chart

[manoranjan_d]

yes can u attach the file for me

[manoranjan_d]

varsha can u attach the file for me

[varshavig12]

Try this.

[MK_QSL]

Don't use any dimension..

use two expressions I have suggested

go to Style tab and select stacked..

[manoranjan_d]

so we should use stacked bar right in style ?