1 Reply Latest reply on Jan 8, 2018 10:27 AM by Michel Caissie

    Alternative to LOD

    Shruthi B S

      Hi People,

       

      Could anybody suggest me an alternative to Fixed LOD calculation as my current dataset is very huge and using LOD has become a big challenge. i have attached a sample twbx file for reference. Here i have used Fixed calc to achieve desired output. I want to know any other way to achieve without using fixed function.

      The requirement is total cost at Geo/ area level where LP<>0 and Sale=0.

       

      Regards,

      Shruthi

        • 1. Re: Alternative to LOD
          Michel Caissie

          Shruthi,

           

          You can add [SO] and [Month] on the Detail shelf.

           

          Next you can compute [Fixed (wo lod)] with

          WINDOW_SUM( SUM(if [Sale]=0 and [LP]<>0 then [Cost] END) )

          compute using  SO, Month, Geo ,  deepest  restarting every SO.

           

          Next you can aggregate it with

          WINDOW_SUM( [Fixed(wo lod)] )

          /

          WINDOW_SUM(COUNTD([SO]))

          compute using Geo, Month, SO , deepest  restarting every Geo.

           

          note: the division by the countd(SO) is because we have SO on the Detail, so we get a bar for every SO. I edited the Color and added a border in order to see a single bar.

           

          To get the label on top , I used a reference line using only the WINDOW_SUM( [Fixed(wo lod)] ) value.

           

          See in the attached

           

          Michel