Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
proctors
Creator
Creator

Line Chart not showing all relevant data and always = 100%

For some reason, my line chart is =100% even though the actual data is around 71%.  I'm expecting at some variation in the line. What gives?

Expression: =count({<[CSSRS Completed at First Ever Visit] = {'1'}>} VISIT_KEY)/count({<[CSSRS Completed at First Ever Visit]={'1', '0'}>}  VISIT_KEY)

Sample data

Visit_KeyEnc. DateProviderCSSRS Completed at First Ever Visit
1015941/30/2017B0
1195481/4/2019S0
1073107/27/2017B1
1078038/14/2017B1
1078128/15/2017S1
1080338/29/2017S1
1138914/12/2018S1

QV chart.png

Labels (1)
2 Solutions

Accepted Solutions
sunny_talwar

Not seeing any 0's for the month of Apr, July, and Aug... only 0s are in Jan... which is why all you see 100%

View solution in original post

sergio0592
Specialist III
Specialist III

So, try to uncheck "Supress zero value" in the presentation tab of chart properties.

Suppress.jpg

View solution in original post

2 Replies
sunny_talwar

Not seeing any 0's for the month of Apr, July, and Aug... only 0s are in Jan... which is why all you see 100%

sergio0592
Specialist III
Specialist III

So, try to uncheck "Supress zero value" in the presentation tab of chart properties.

Suppress.jpg