Hello, In my use case, I have a table of data in which I am counting the number of student IDs per school in selected grades to see the participation per school in a given week. The filters applied on the table are of “week” and “grade”. I need to be able to calculate the percentage of active stu…

How to avoid some filters while maintaining others in a visual

Ying_Wang March 29, 2022, 10:14pm 11

the calculated field = distinctCountOver({student_id}, [School], PRE_AGG)
grade filter:

week filter:

2 Likes

Topic		Replies	Views
Query on Filter Q&A	4	311	March 21, 2023
Have some filters apply to my calculated field but not others Q&A filters , calculations , Business-Intelligence-Engineer	6	315	August 5, 2024
Create runningCount that will not be affected by filter Q&A filters , calculations , Business-Intelligence-Engineer	7	58	September 9, 2024
Calculated field should be constant if i change the filters Q&A developer , dashboard-embed	5	94	September 13, 2024
How to create a SumOver function in QS that subjects to only chosen filters Q&A filters , calculations	15	1405	August 25, 2023