Sum non numeric column then sort that "sum" by day/Month/Year

[Mopyd]

I am trying to make a report from Labtech. i want to be able to see how many computers were add to Labtech daily/Monthly/Yearly.

Then be able to sort that by client name. 

I have the dates they were added, the computer name and the client.  So i need to be able to add the computer names to get a numerical count. Then use that numerical count to be able to report how many computers were added to Labtech on any given day/month/year.

[ibarrau]

Hi, You don't even need a filter. You can add a filter of clients and create a bar char with dates as X axis and Computer as values (then count is by default)

Regards,

[Greg_Deckler · Accepted solution]

Measure = COUNT([ComputerName])