Service desk Reports

[shwetha gowda]

Hi,

 

Kindly let us know the formula to get the count of tickets raised in service desk.

 

The reports are generated with the incident and serial No

But need to know the count of tickets raised in reports of Service desk.

 

Thanks

[Legacy User]

Use the SUM from the formulas provided

[shwetha gowda]

Hi,

 

The SUM function when provided prompts for the value to be added inside.

=SUM()

 

The No of tickets count which is raised, needs to be added and shown. 

If I give =SUM(Rowindex()) it gives incorrect value.

 

Kindly let me know which variable needs to be added,inside parenthesis.

 

Since its urgent, request your help on this.

 

Thanks

Shwetha Gowda

Tata Consultancy Services

Mailto: [e-mail]

Website: http://www.tcs.com

[Raghu Rudraraju]

Hi Shwetha,

 

Out of the box universe already offers several such measures in the Measures classes. Example -> Incidents -> Incident Analysis -> Incident Measures

 

Maybe something similar can be used for your counts ?

 

_R

[shwetha gowda]

Hi,

 

Can you please let us know if there is any function that can be added to calculate the values.

 

Thanks

Shwetha Gowda

Tata Consultancy Services

Mailto: [e-mail]

Website: http://www.tcs.com

[Pradeep_p]

Hi Shwetha,

 

Please check this 

 

=Count([Ref Num])

 

[Raghu Rudraraju]

That's a good idea Pradeep_p

 

Thank you for sharing the screenprint as well.

 

_R