6 Replies Latest reply: Jun 19, 2017 2:17 AM by Phalgun Parvathaneni RSS

    Aggregating and Calculating Dimension

    Phalgun Parvathaneni

      Hello,

       

      I have the sample data loaded in the following qvf. What I'd like to do is create a calculated dimension according to the following logic:

      Aggregate the data by the field 'Code'

      1.If variable=1, then in aggregated data, If Var1>0 even for one record, give the output as 'Yes', otherwise 'No'.

      2.If variable=2, then in aggregated data, If Var2>0 even for one record, give the output as 'Yes',otherwise 'No'.

      3.If variable=3, then in aggregated data, If Var3>0 even for one record, give the output as 'Yes', otherwise 'No'.


      What I'd like to show in the pie chart finally the distinct count of Codes that fall under 'Yes' and 'No'.


      stalwar1 Please help me out.


      TIA!