code count by entire case #1242
|
Hello! Is there a way to get the code count for whole cases? In the code count by case report option, it still divides it by file. I'd like to know code frequency by case as in all of the case's files combined. |
Replies: 2 comments 2 replies
|
Hi, at the moment, no. But I will look into this, and I think the easiest way will be for me to add a SQL query, in the Reports > Database Queries. I should be able to do this over the next few days. |
|
Amazing! |
|
OK. |
|
Thank you! Much appreciated! |
OK.
Go to Reports > Database Queries
Then copy and paste the text in the below file into the top section, and press the play button.
If you have only coded text, its easy, as you will only have one code per row per case.
But if you have coded text, images and/or A/V, you might see multiple rows of the same code per case, and you would then have to add those row counts up yourself.
codes count by case.txt