Average percent

Anonymous — Thu, 04 Sep 2014 18:45:50 GMT

Hi friends,

I have a chart with 1 dimension. I'd like to calculate average reference line based on % for each tags.

How can I do it more dynamically?

Without selecting each tag from the field

=((Count({<[Issue resolution]={'Yes, completely'},[Rating Support tools used]={'Browsing support topics'}>} [Issue resolution])/

Count({<[Rating Support tools used]={'Browsing support topics'}>}TOTAL <[Rating Support tools used]> [Issue resolution]))

+(Count({<[Issue resolution]={'Yes, completely'},[Rating Support tools used]={'MyAccount section'}>} [Issue resolution])/

Count({<[Rating Support tools used]={'MyAccount section'}>}TOTAL <[Rating Support tools used]> [Issue resolution]))

+(Count({<[Issue resolution]={'Yes, completely'},[Rating Support tools used]={'Other'}>} [Issue resolution])/

Count({<[Rating Support tools used]={'Other'}>}TOTAL <[Rating Support tools used]> [Issue resolution]))+

(Count({<[Issue resolution]={'Yes, completely'},[Rating Support tools used]={'QA section'}>} [Issue resolution])/

Count({<[Rating Support tools used]={'QA section'}>}TOTAL <[Rating Support tools used]> [Issue resolution]))+

(Count({<[Issue resolution]={'Yes, completely'},[Rating Support tools used]={'Search tool'}>} [Issue resolution])/

Count({<[Rating Support tools used]={'Search tool'}>}TOTAL <[Rating Support tools used]> [Issue resolution]))+

(Count({<[Issue resolution]={'Yes, completely'},[Rating Support tools used]={'Support videos'}>} [Issue resolution])/

Count({<[Rating Support tools used]={'Support videos'}>}TOTAL <[Rating Support tools used]> [Issue resolution])))

/Count(DISTINCT [Rating Support tools used])

I'd like to use it for calculate SUMPRODUCT like I did it in excel

Please find the attached file.

Thanks,

Re: Average percent

Anonymous — Thu, 04 Sep 2014 19:22:15 GMT

I found out

SUM(COUNT({<[Issue resolution]={'Yes, completely'}>} TOTAL BBB))/

SUM(COUNT({<[Issue resolution]=P()>} TOTAL BBB)

MarcoWedel — Thu, 04 Sep 2014 21:01:32 GMT

Hi,

one solution delivering your excel result of 76% instead:

hope this helps

regards

Marco