0 Replies Latest reply: Dec 5, 2017 5:36 AM by shikha kumari RSS

    How to solve duplicate data issue in bar graph

    shikha kumari

      Hi,

       

      In my dashboard I have a bar chart with drill down dimension and two measures.

      Dimensions are-  segment IP+Division IP+BU IP+TC IP

       

      And measures are

      IP mapped-   sum({<bkey_account=-{'Not mapped'},[Order family]={'XYZ'}>}[Installed product count])

      IP Not mapped-  sum({<bkey_account={'Not mapped'},[Order family]={'XYZ'}>}[Installed product count])


      Segment IP's are-

       

      DE Science
      DE Medical
      DE Paed

       

      For  BD Science Segment IP, I am getting correct values for all the division IP's in graph, but for other segments values are repeating for all the Diviosion's IP .

       

      Please suggest.