Count and select

I have created a slice for last 7 days report and names as " 7day reports". From these slice i want to create report through email.
I want the count of the column.
So i have used COUNT(SELECT in word template

But this work in single column only. But i want multiple column. Means i want to know the count of two coloums based criteria

0 5 318
5 REPLIES 5

Steve
Participant V

Like COUNT(SELECT(...)) + COUNT(SELECT(...)) or COUNT(SELECT(...) + SELECT(...))?

This means adding the counts Or is this work with multiple filter count. Like i want count like โ€œtype of work completedโ€ , โ€œtype of work pendingโ€

If type and status is the column what is the formula. The type have more categories

Iโ€™m really not exactly sure what you want. Could you explain further?

Steve
Participant V

Thereโ€™s no good way to do that automatically. Youโ€™ll have to create one virtual column for each specific count you want.

Steve
Participant V

I donโ€™t understand what you mean.

Top Labels in this Space