Forum Discussion
Helper VCounting ELA and MATH
I have an issue and am having trouble wrapping my head around it. I am trying to count students absent in English and Math classes. The issue here is the database places students absent per period on a row to row basis. I have created a sample here. The original one is over a million rows.
I was wondering if there is any way I can create a column that counts number of students absent in MATH and ELA. I know I can do table. But I need to be looking more like the picture below (red font is where I want the calculation) and was wondering if someone could help.
3 Replies
- HotChilli
Community Champion
The simplest way might be to drag 'School ID' on to a table visualisation twice. Make one 'Don't Summarize' . Make the other 'Count'
Then expand the filter pane and drag Subject on to 'Add data fields here' then tick ELA and MATH in basic filtering.
- stevedep
Memorable Member
Hi,
The solution is available in the other equally named post.
Br
