is it possible to calculate average speed using the reports?

Officially Answered

Follow

New post

Giovani S Ouro Preto

• December 15, 2020 19:52

Hello there!

 

I've created some reports to know how many hours my team is spending on each project we're working on (based on azure tags fields) like this:

 

$apply=filter(contains(CustomStringField1, 'TOTEM 4.1.0') and contains(CustomStringField1, 'HMLG'))/aggregate(TrackedItself with sum as PeriodLength)&customFields=System.Tags

 

however, I was seeing the OData docs and it's still cloudy in my mind if is it possible to create a simple indicator of average speed (total of time spent / total work itens retrieved by the query).

 

Is it possible to have this average speed using the reports odata query?

 

thanks a lot

Giovani

0

• 

  Andrea Moro

  • January 15, 2021 14:28

  Hi Giovani,

  Thank-you for reaching out. Our APIs do support mathematical operations, you can find more information here.

  This should help you with what you are trying to achieve, however should you have any more questions don't hesitate to reach out again!

  Kind Regards,

  Andrea
  Product Owner - www.7pace.com

   

  0

  Comment actions Permalink

Please sign in to leave a comment.