Values showing different in Straight table and Bar chart

[#1]

Hi,

I have a straight table with Dimension Staff member and expressions as below

Number of documents Reviewed= Count(Distinct(Reference))

Number of Failures= count({<Result={'Fail'}>}DISTINCT Reference)

% of Failures= Count({<Result={'Fail'}>} distinct Reference)/Count(Distinct(Reference))

Here Reference contains ID's

I have Bar chart with Dimension Staff member and expression as below

% of Failures= Count({<Result={'Fail'}>} distinct Reference)/Count(Distinct(Reference))

My problem is when I comapred % of Failures values in striaght table and Bar chart it is showing different percentages. Could anyone help me in this. Am I doing anything wring in the expressions? Please help.

Thanks.

[#2]

can you attached your app.

[nilesh_gangurde]

Hi,

You can keep only one expression for % calculation in the Straight table. and chek

-Nilesh

[#4]

Please find attached.

[nilesh_gangurde · Accepted solution]

Hii

PFA

You have to uncheck Relative option in the Expression Tab in Bar chart.

-Nilesh

[#6]

Thanks you are right and it's working.

[#7]

Hi,

Is there any way to get the values correctly without uncheck Relative option in Expression tab because my user wants to have Relative option.

Thanks.

[nilesh_gangurde]

Hi,

Yes you can achiev that by changing the expression.

Use only 1st part of your expression and then check Mark relative option.

then your expression will be as follws:

Count({<Result={'Fail'}>} distinct Reference)

-Nilesh