8 Replies Latest reply on Nov 21, 2017 2:09 AM by pinki sharma

    How to make measures using dynamic comparison

    pinki sharma

      Hi All,

       

       

      I have 3 columns in table.

      1. Time

      2. Total Calls

      3. Codec

       

       

      I want to make  timeline view with calls and calls in particular codecs like shown in attached image.

      To implement this right now i am making calculated fields like this -

       

       

      if [Codec]="G711U" then

      ([Calls])

      end

       

       

      Data points are coming right but the problem in this approach is - I am  comparing the codec values with hard coded value.

      This is not right approach because codec value can be anything .I don't know all the values of codec.

       

       

      Could you guys please help me to find resolution of this problem ?

       

       

      Thanks is advance.

       

       

       

       

      Regards,

      Pinki Sharma