Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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_Key | Enc. Date | Provider | CSSRS Completed at First Ever Visit |
101594 | 1/30/2017 | B | 0 |
119548 | 1/4/2019 | S | 0 |
107310 | 7/27/2017 | B | 1 |
107803 | 8/14/2017 | B | 1 |
107812 | 8/15/2017 | S | 1 |
108033 | 8/29/2017 | S | 1 |
113891 | 4/12/2018 | S | 1 |
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%
So, try to uncheck "Supress zero value" in the presentation tab of chart properties.
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%
So, try to uncheck "Supress zero value" in the presentation tab of chart properties.