We have created a database view for the intent of reporting on sc_task durations. In the reporting module when the database view is chosen as the table and trying to add variables I can access them via dot walking in the available columns and move to the selected but when I run the report they disappear from the selected columns and I cannot figure out why. Here are the tables that are in the database view:
metric_definition
metric_instance
sc_task
Assistance is appreciated. Thanks!
