Unable to select variables in Trend By

singhkartheek
Kilo Contributor

I'm unable to select variables in Trend By field on reports. Please help me.

1 ACCEPTED SOLUTION

AnveshKumar M
Tera Sage
Tera Sage

Hi @singhkartheek 

Unfortunately you can not select variables in Trend By as this field accepts only Date and Date/Time fields, but the variables store the values as string.

 

Refer my other answer on the same issue here.

 

https://www.servicenow.com/community/service-management-forum/trend-by-variable-in-reporting/m-p/275...

 

Please mark my answer helpful and accept as a solution if it helped 👍✔️

Thanks,
Anvesh

View solution in original post

3 REPLIES 3

AnveshKumar M
Tera Sage
Tera Sage

Hi @singhkartheek 

Unfortunately you can not select variables in Trend By as this field accepts only Date and Date/Time fields, but the variables store the values as string.

 

Refer my other answer on the same issue here.

 

https://www.servicenow.com/community/service-management-forum/trend-by-variable-in-reporting/m-p/275...

 

Please mark my answer helpful and accept as a solution if it helped 👍✔️

Thanks,
Anvesh

Thanks Anvesh!

 

It makes sense.

AnveshKumar M
Tera Sage
Tera Sage

Hello @singhkartheek 

Hope you are doing well!

 

Can you please mark my answer helpful and accept as a solution if it helped, and it will help other users 👍✔️

Thanks,
Anvesh