Expression

[smilingjohn]

Hi All

In the attachment i have 2 charts One is bar graph and the other is Block chart.

I have derived.

If u look at the bar chart the dimesnions (Sensitivity, resistant,Internediate ect) are derived from Drugresult .

Required :

If i clik any one content say Sensitivity whose output count is =790,

And accordingly the Block charts show only for sensitvity , but the numbers dont match.

Can any one suggest me that what Expression do in need to add under block char so that the count of both the charts remain same.

Thanks

[MK_QSL]

You can show 790 in Bar chart but not in Block Chart... I think you still didn't understood my example provided above.

If you simply use COUNT(Distinct output).. it will not work because you have more than one DRUGRESULT for single output.

Consider 8/1/2015|BSGA|1595953... For this output you have 6 Different DRUGRESULT.

So if you select this output, you will get 6 different blocks in block chart which will give you count 6 but

your bar chart would give you 1.

If you select Particularly 8/1/2015|BSGA|1595953, your Bar chart count will be 1.. but your block chart can't be one because there are 6 different DRUGRESULT.

[smilingjohn]

Hi Manish

Yes  I understand that .

But when i slect only sensitivty in bar chart which is 790 , and in block chart  only one block appears that is <2 SN  .

So why it is showing only one block with the same value as in the bar ,
Is it not possible to show multiple blocks ? Now it is calcultaing all blcoks and showing within single block

If this is not possible than i will close this call .

Thanks Manish for your precious time and support

[MK_QSL]

CHECK