Create report with specific y-axis data

[NamanChaturvedi]

Hi
I have a requirement where I have to create a report for this Sample Data table.
Report should be like - > users have worked on what all projects + how many hrs they have spend on which project

I am not able to get the working hrs on the y-axis (Also working hrs column is of String type ).

[SanjivMeher]

Did you try a multipivot report which should give you the expected results?

[AndersBGS]

Hi @NamanChaturvedi ,

The reason you can't have the working hours on Y axis (summarized) is due to the reason that the field is a string field and not an integer field. A possible solution could be to create a new integer field and then copy the value from string to integer via script, and then report on the new field. You can see how it is done here: https://www.servicenow.com/community/developer-forum/how-to-convert-field-value-from-string-to-integ...

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders