Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Then Replace dimension
Use DRGRSLT Instead of DRUGRESULT in Block Chart
Or you can use something like this...
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
Use below expression in Bar Chart
Sum(Aggr(Count( distinct %IncidentKey),DRGRSLT))
and below expression in Block Chart
Count( distinct %IncidentKey)
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
Can you upload the latest file please... Also include a text box showing what result you are looking for if you select Sensitivty ..
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
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)
When you select Sensitivity, what value are are looking for in Bar Chart?
If it is 790, then it is wrong..
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