Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
I found out
SUM(COUNT({<[Issue resolution]={'Yes, completely'}>} TOTAL BBB))/
SUM(COUNT({<[Issue resolution]=P()>} TOTAL BBB)
I found out
SUM(COUNT({<[Issue resolution]={'Yes, completely'}>} TOTAL BBB))/
SUM(COUNT({<[Issue resolution]=P()>} TOTAL BBB)
Hi,
one solution delivering your excel result of 76% instead:
hope this helps
regards
Marco