AnsweredAssumed Answered

Reports Counting Multiple Fields As 1

Question asked by Kieran Kieran on Oct 26, 2014
Latest reply on Nov 6, 2014 by Kieran Kieran
I am trying to develop a dash let for my team of trainers on their completed assessment rates. Each unit of assessment has its own related date field for marking the completion of the unit. For example
Unit 1 Completed Date
Unit 2 Completed Date
Unit 3 Completed Date

Now it is very easy to run a SQL query to tell me the SUM of all date fields this month. However I was wondering is it possible the the out of box reporting module in sugar?

For example if the above 3 dates where this month, the count would be 3. But in the out of box reporting module no matter how I filter it, I can only get a count of 1. Trying to do it through the rows and columns reporting type seems impossible.

Anyone got any solutions?

Thanks

Outcomes