Hi, Arijit 

Sory for the late reply.

-

I am sorry, but i did not fully understand your use-case.

Could you please show me some screenshots of how this table looks,  

and if you can elaborate a bit more about the approved and rejected values - where are these values going to be stored?

Best will be if you can record a short Video to show us more details about your current table and what results you would like to see.

( It can be any video, for example a ScreenCast , Loom, or anything else)

I assume that you have a column for user ID's ,  and another column for "approved" or "rejected"?

Thank you

And if you send us any sensitive data, make sure to mark reply as PRIVATE - so that only we can see it.

Hi, Arijit 

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

I have a workaround to offer you to present this count data on charts,

but for tables i am not 100% sure if we currently have a built-in solution. Perhaps it can be done with a custom SQL Query.

-

1. For grouping data like this in charts, here is my example.

If i have this table with some users, user ID's and Status column.

Then we have to make additional column that will serve as the "count".

We set a predefined auto-populate editing value to always be 1 in this column.

-

Then we can make a chart from this table, and enable "Chart Grouping".

For this chart example i will only choose column "Status" and column "Count status".

I made a column chart on this example, but you can also make a Pie chart or some other chart types.

Now, if we want to use filtering on the table, to just show data for user ID 1,

we enable "Follow table filtering" on the chart and place table on same page,

then i can filter only user 1 ,  and the chart will follow :

-

If you just want to show "Approved" and "rejected" count, and exclude "open",  you can add a checkbox Filter to the column "Status" , and just select these two :

Of course, you can hide or show columns from table, depending on what you wish users to see.

Additionally, if you just want to leave the filters for the chart and hide the table from the page, there is a CSS workaround ( let me know if you need it).

-

Let me know if perhaps showing this through charts can work for your use-case,

or you require to show the Count in table itself,

then it will be a lot more difficult to achieve a workaround.

Thank you