Custom TSV fields show in seconds and do not honor the time-varying unit conversion (hours) at attribute level in MUX Reporting chart widgets
STEPS TO REPRODUCE:
- Go to Classic PPM > Administration > Studio > Objects
- Create a custom TSV "MyETC"
Time-varying unit conversion set to Hours
- Provide and API Attribute ID and Include it in the DWH
- Create a project > Add a team member > Create a task and assign the Staff member
- On the Per period metrics for the assignment populate ETC and the Custom TSV
- Run the Load DWH job
- In MUX > Reporting
- Create a copy of Assignments across Investments Data Provider
- Add the custom TSV "MyETC" created to the same.
- Create a report and add a few widgets: table, bar, column ...
- Filter down to the project assignments of the project we created in Step 4
- "ETC" and "MyETC" per period metric data is displayed
- Set the Unit of Measure of the report to Hours
Expected Results: Custom TSV fields show in hours and honor Studio 'Time-varying unit of conversion' setting for Hours
Actual Results: Custom TSV fields show in seconds and do not honor Studio 'Time-varying unit of conversion' setting for Hours ...