2 Replies Latest reply on Sep 26, 2012 12:32 AM by Rajini S

    Drill-down & Drill-up with different calculation for each level

    Rajini S

      Hi All,

      I have a requirement to use different calculation for each hierchy when apply drill-down or drill-up for a time dimension. Time dimension have till minute level data and I have to use calculation for each level as below when drill-down or drill-up,

       

      Minute  99.9/100

      Hour     (99.9/100)*60

      Day      (99.9/100)*1440

      Week   (99.9/100)*10080

      Month  (99.9/100)*43200    (Month level have to calculate no. of days properly like 28, 29, 30 or 31 days)

      Quarter(99.9/100)*129600   (Quarter level have to calculate no. of days properly like 90, 91 days)

      Year    (99.9/100)*6220800  (Year level have to calculate no. of days properly for year or leaf year)

       

      How to do this hierarchy calculation in Tableau? Could you please share your idea ?

       

      Best Regards,

      Rajini