Taking average of submission

  • Profile Image
    Smondoville
    Asked on May 06, 2013 at 01:53 AM

    I have a vendor submission form where vendor are rated based on their perfomance. The users can enter their rating of each vendor. Even the user can submit same vendor multiple times with different rating.

    What i need is the average of rating of each vendors. This can be a report. How i can achieve this?

  • Profile Image
    EltonCris
    Answered on May 06, 2013 at 08:19 AM

    Hi,

    Sorry to say but we do not have the option you are looking for on the reports feature. I can see few report links under your form, wouldn't that suffice? Let us know your thoughts. Thank you!

  • Profile Image
    Smondoville
    Answered on May 06, 2013 at 08:21 AM

    That would never sufice, none of the reports are giving options to take averate of sum the rating of the vendors :-( 

  • Profile Image
    Welvin
    Answered on May 06, 2013 at 10:28 AM

    Hi,

    You may also consider creating fields for each vendor (the vendor as the field label), I think this method will work and let you sum up the ratings. The Matrix Field will do that.

    Please try that.

    Thanks

  • Profile Image
    Smondoville
    Answered on May 06, 2013 at 11:02 AM

    I might have 1000 vendors, so that not a feasible solution. 

     

    I really wonder why you guys not implemented group by,order by, sum aggregate function.. which any reports will have, this is the basics of any reports that really sad that no such feature for these report :-(

  • Profile Image
    Welvin
    Answered on May 06, 2013 at 11:05 AM

    Hi,

    Please create a separate thread requesting such functions so we can escalate that to our developers. We can do that for you but we prefer it this way, so you will be notified for the updates regarding the request.

    Thanks