Get the count of a category in a time interval

[tc5613213]

Hi all, this is the relationship that I just drag to a workpage. Is there any way that I can get the number of ocurrence of each category (i.e. column 3) to get some thing like:

column1           column 2           column 3
20/04/2016       12:00:00 AM      Residence: (count)

                                                    Business affairs: (count)
Anyone can provide some hint? Thanks

[Markus_Re]

Hi @tc5613213,

this could be done inside the visual without the need of complex calculations:

In your case i would remove the third column (those numbers, 668,1332,1683,...) from the table.

That should give you a row for each category on each distinct date.

Now you can drag the field "category" into the visual again, but this time change the type from "no summarize" to "count".

Hope this helps.

Best regards,

Markus

Did this answer your question? Mark my post as a solution!