Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Group by in Data Visualization presents error "Selected field is invalid"

Greg Patrick
Tera Contributor

I'm trying to create a Data Visualization, in particular a Pivot Table, that shows me a list of people who have raised requests of a particular type. I want to be able to capture in the Pivot Table a date from a variable that was captured on the form. However, when I attempt to do this, I get the "Selected field is invalid" error. Is the issue that you can't use variables for the purpose of Group By?

2 REPLIES 2

Greg Patrick
Tera Contributor

Further playing around I've worked out that I can use some variables in a Pivot Table, but not all. Is there some kind of limitation on what types of variables can be utilised in this manner?

BurtCrepeault
Tera Contributor

I also have this problem under Xanadu, I can't seem to be able to use date fileds in Group by.