1 Reply Latest reply on Jan 11, 2019 3:14 AM by sajad.bhat

    I want to create bucketing/bins

    balan view



      I have the data like Date and Asses_date and category, there are two date column and one category. Logic : if asses_date is not matching with Date then its called Inactive.

      So i want to create bucketing like below

      0 to 5 days ----

      5 to 10 days


      in attached file  category a is inactive for 1 day,

      category b is inactive for 6 days


      So result should be below

      0 to 5 days ----1

      5 to 10 days---6

      So bucketing should show the no of days category was inactive.