i have 84 fields in my index and i am trying to build a line chart using following fields.
- mt_closed_cases.dv_case_cta_flag - This is string filed contains only two values either 'Y' or 'N'
- fiscal month - it contains month names in string format.
- Case Category - This is string filed
So my requirement is, to build a line chart with following
count( mt_closed_cases.dv_case_cta_flag='Y') / count(mt_closed_cases.dv_case_cta_flag) by fiscal month
could you please help me