Count Ageing Range

[Zaky]

Hi,

I have a table containing the Ageing Range. So now I want to count how many ageing range for each product categorization.

Could anyone can help me on that?

Ageing Date	Ageing Range	SRID	Product Categorization
08/02/19	0 > 2 Days	REQ000001634677	Leasing
08/02/19	0 > 2 Days	REQ000001634680	Leasing
08/02/19	0 > 2 Days	REQ000001634681	Leasing
08/02/19	0 > 2 Days	REQ000001634682	Leasing
08/02/19	3 > 7 Days	REQ000001634683	Disposal
08/02/19	3 > 7 Days	REQ000001634684	Disposal
08/02/19	15 > 30 Days	REQ000001634685	Mainstream NB
08/02/19	15 > 30 Days	REQ000001634686	Mainstream NB
08/02/19	15 > 30 Days	REQ000001634687	Mainstream NB
08/02/19	15 > 30 Days	REQ000001634688	Mainstream NB

The expected result supposed to be like below

By Product Category	0 > 2 Days	3 > 7 Days	15 > 30 Days	Grand Total
Leasing	4			4
Disposal		2		2
Mainstream NB			4	4
Grand Total	4	2	4	10

Thanks

[Anonymous · Accepted solution]

Hi @Zaky,

Create a Matrix Visualisation from the Visualisation panel.

And drag Product Categorization into Rows.

Drag Ageing Range into Columns.

Drag Ageing Range into Values and click on the icon (arrow beside to the filed name) and select Count from the list.

This will work for you.

Regards,

Pavan Vanguri.

[Zaky]

Thank you very much for your help @Anonymous