How to count specific data in the table

[Uk]

Hello , I need a help,

I have an output report data like this.

How to count  the number of Verified, Invalid, and Unknown

in table of each months . Thanks

[TeeSee1]

COUNT(FILTER("table name here", [NOTE]="VERIFIED")) would be the expression.

Depending on your table structure, create a VC for each month and have

COUNT(FILTER("table name here", AND([MONTH]="JANUARY",[NOTE]="VERIFIED"))) as the app formula.

[Uk]

Thanks it's really helpful.  It works anayway, But How if I wanna count based on ID, Month and Note.

For example.

Joe, on February,  has Verified = 1, Invalid = 1, Unknown = 1

on January, has Verified = 3, Invalid = 1, Unknown = 0

Thanks,

[TeeSee1]

You have to create an expression for each combination of what you want to count.

You might want to create a separate table to contain summary rows, one per user, so you can create your report off of this.

I am not very knowledgeable in report creation within AppSheet.

Hopefully some others can provide more insight there.

[Uk]

Thanks for fast response. I will try more 👍

[TeeSee1 · Accepted solution]

@Uk 

In my attempt to learn a bit more about reports in AppSheet., I created a demo app to do what you, I believe, want to do.

https://www.appsheet.com/Template/mobilepreview?appId=bcda4f2b-06a2-4697-9138-022fcfb565d7

You can see the internals here - App named REPORTS

https://www.appsheet.com/portfolio/3401559

Here is a report generated

https://drive.google.com/file/d/1su62cWWwFdj-fRwkcspgyn6aVJeGzJar/view?usp=sharing

Here is the gDoc template

https://docs.google.com/document/d/1QPfi0KbMMLP5YxJ43e_IqsRGgypd-b6XxlBIq-0h8PE/edit?usp=sharing

The key is to create a summary table (I called it COUNTS).

Hope this provide you with more insight.

Cheers

[Uk]

wow that's amazing , Actually you are the expert one . Thank you so much. it's really helpful 👍

[Uk]

Hello , @TeeSee1 do you  have any idea how to make them page number 
?

[TeeSee1]

https://help.appsheet.com/en/articles/5280407-using-google-docs-templates#h_634395b4f9

Page Breaks are supported but not page numbers...

EDITED

A sample output

https://drive.google.com/file/d/1fPa0GrBTV5L8zA6q4AAL3H7gqpskgmIS/view?usp=sharing