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]

Then Replace dimension

Use DRGRSLT Instead of  DRUGRESULT in Block Chart

[MK_QSL]

Or you can use something like this...

[smilingjohn]

Thanks Manish

Actaully

In the Block chart i am using this exprssion "Sum(Aggr(Count( distinct %IncidentKey),DRGRSLT))"

And when i select only Sensitivty in bar chart in the block chart i see only one block that is

Which is matching the bar values

2. When i select Sensitvity i should get like this with tha same value on bar Sensitvity

Thanks

[MK_QSL]

Use below expression in Bar Chart

Sum(Aggr(Count( distinct %IncidentKey),DRGRSLT))

and below expression in Block Chart

Count( distinct %IncidentKey)

[smilingjohn]

Hi Manish ,

If i go with above expression then yes  i get the desired result in bloack chart but the couts in block chart differs compared to Barchart .I think we are very near to achieve

[MK_QSL]

Can you upload the latest file please... Also include a text box showing what result you are looking for if you select Sensitivty ..

[smilingjohn]

Hi Manish

If i select Sensitivity in bar chart  the block chart should show me the break of sensitvity with exact value that of bar chart selected Sensitvity . below is the napshot how it should appear

[smilingjohn]

PLz find the attachment .

Now if you look at  both the charts the values are matching this is what i want .

And when i select Sensitivty in Bar chart then only one block is seen in the Block chart with accurate value , where as it has to show multiple blocks as whon in the snapshot (provided  when i sum up each block the value has to match with the sensitvity bar)

[MK_QSL]

When you select Sensitivity, what value are are looking for in Bar Chart?

If it is 790, then it is wrong..

[smilingjohn]

Hi Manish

That is correct , that is how we count the distinct .And accordingly it needs to be displayed in the Block chart which is also displying , the only problem in the block chart is it is showing only one block with count of 790  , wher as it needs to be displayed in many blocks