Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

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.