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

[kaushiknsolanki]

Hi,

The reason is one output has multiple DRUGRESULT and thus they are getting counted more then 1 where as your Bar chart shows a distinct against the DRGRSLT.

Regards,

Kaushik Solanki

[sunny_talwar]

I think the issue is related to the distinct count. In your bar chart it is showing the distinct count by DRGRSLT which after selection is just for one value. Whereas the block chart still has multiple dimensions and the count is distinct for each value within your dimension. The problem is that two dimensions can count a distinct value once for each of value. So if you sum up all the count, you will end up having more than the actual distinct count.

[MK_QSL]

Change expressions as below

=SUM(Aggr(Count(Distinct output),DRUGRESULT))

[smilingjohn]

Hi Manish Thanks for your reply

It shoult be count only , i tried with sum it works perfectly , whatever the dimension i select accordindly the values are same in the both charts .

But when i replace sum with  count the values are very less .

Can you please look into this

[smilingjohn]

Hi Sunny

If you look the sript i have merged in that way , wherever ther is "SN " it should be Sensitivty  and so on ,

I think you understood what i mean to say . for both the charts the value should match for count , It cannot be sum

[MK_QSL]

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.

[smilingjohn]

Yes  i do agree

And you formula works other way that is

Under block chart i used this formula = 'Sum(Aggr(Count(Distinct output),DRGRSLT))' which gives the me the exact count  of each individual as that in the bar charts but the problem is ,it is not showing all the blocks for sensitivity .

If i get that then iam good to go .

I hope u can provide me with some solution

[MK_QSL]

What do you mean by now showing all the blocks for sensitivity? Please clarify by an example.

You don't have to change the expression for Block Chart.. Only use the expression suggested for Bar Chart.

[smilingjohn]

Ok  i understand , But iam trying to match the values of block chart with bar chart .

In bar chart if i select Sensitivty , then it shows only one block , rather it should show multiple blocks for sensitivyt and so on .

Thanks