Forum Discussion
Count Ageing Range
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
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.
2 Replies
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.
Thank you very much for your help Anonymous
