I'm using Sol_Flag as calculated dimension. It has three filters - Created, Reused and Updated. But I need values In Stacked Bar chart only for Created and Reused. If am using Cal dimension as =if ( Sol_flag =' Created' or 'Reused', Sol_flag, null()), QA will not pass. As QA person said better to avoid using Cal Dimension always. The other way is I should create a new field in script as below
=if ( Sol_flag =' Created' or 'Reused', Sol_flag, null()) as Sol_flag1. How to create this field in script. If am creating by keeping the Sol_flag as original and next line as new field, am getting error - Sol_flag field not found.
Please provide some insights on how to achieve this.