Record count in database view

[fkameka]

How to create a record count in database view? I can't do this with core reports.

The record should include these fields

Header 1	Header 2	Header 3	Header 4	Header 5
Question	Date	Person	Result= yes	Result= No

[Community Alums]

// getCount : function(){

var queryString = 'state=1'

var gr = new GlideAggregate('incident_db_view'); //GlideAggregate query

gr.addAggregate('count');

gr.orderByAggregate('count');

gr.addEncodedQuery(queryString);

//gr.groupBy('priority');

gr.query();

var incidentCount;

while(gr.next()){

  incidentCount = gr.getAggregate('count');

}

gs.log(incidentCount);

//return incidentCount;

// }

[Tarish]

https://community.servicenow.com/community?id=community_question&sys_id=192517551b3d78540b8a9979b04bcbd0

can you help me with this question?