Hi Team,
The issue was on the report where multiple sheets had similar names with columns having different column types.
Example --> Report with 200 sheets where 20 sheets have similar names and contains columns with the same name but different type so it will appear twice in the report column option but it would be very difficult to change column type manually one by one by going through each sheet.
As a future enhancement, I would like to see the sheet path on the report column option as illustrated below.
Sheeth path --> Workspace name/folder/sheet_name.
It would be helpful to know if all columns of data are acutally being used. So a way to see which reports (or at least a count of reports) a column of data has been added to.