The CreatorCon Call for Content is officially open! Get started here.

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