6 Replies Latest reply on Feb 1, 2018 8:42 PM by Shinichiro Murakami

    Need help creating a histogram grouped into bins based on max date per week

    Darwin Natapradja



      As stated in the long title, I need help creating a histogram with count of ID divided into bins of points an ID has based on its max date that week.

      Here's a sample of the data and the logic it should use to get to the final goal:


      Grouped into the week number, and get the current balance for each ID based on the max date each week.

      Finally, the histogram should reflect the ID count for each bin of current balance based from the max date above. The histogram must have the ability to filter by week number.

      Please let me know if the steps or explanations aren't clear. Help is deeply appreciated! Thanks in advance.