1 Reply Latest reply: Feb 20, 2018 3:44 PM by Digvijay Singh RSS

    Data comparison

    Fabiana Iglesias

      Hi

       

      I need to calculate the value of an expression exclusively for a group of data and compare them with one value; in my case, the solvency ratio for one company and compare these ratio with different sector´s companies

       

      I´m calculating the solvency ratio where:

       

      Solvency ratio = $(vEquity)/$(vAssets) (as a master element)

       

      vAssets = sum({<IDAccount={'10'}>}Money)

      vEquity = sum({<IDAccount={'30'}>}Money)

       

      The groups of companies are like these:

       

         

      IDGeneralTypeIDSystemSystemIDLicenseLicenseIDCompanyCompanyNoCompany
      1111A1A1A1A1
      1212A1A2B1A2
      2121B2B1A2B1
      2222B2B2B2B2
      2223C2B2B2B3

       

       

       

      I need to compare the Solvency ratio of my company (IDGeneral = 1111) against the groups whose IG general starts with '12', '21' and '22' in a bar graph

        • Re: Data comparison
          Digvijay Singh

          You may create one synthetic Dimension in bar chart as - Valuelist('MyCompany','Startswith12','Startswith21','Startswith22')

           

          and measure as -

          Pick(Match(Valuelist('MyCompany','Startswith12','Startswith21','Startswith22'),'MyCompany','Startswith12','Startswith21','Startswith22'),

          Expressionforyourcompany,Expressionfor12,Expressionfor21,Expressionfor22)


          The expessions in above measure can calculate specific values for other groups like -

           

          vAssets12 = sum({<IDGeneral={"12*"}>}Money)

          vEquity12 = sum({<IDGeneral={"12*"}>}Money)