4 Replies Latest reply on Jul 8, 2016 7:19 AM by Rahul Upadhye

    Is it possible to create bar chart with a count of records with dates that fall in certain ranges?

    Nicole Robitaille

      Hopefully my explanation makes sense because I cannot post the workbook.

       

      I have a data file that is a list of contact names and emails. The list also includes multiple date dimensions for example, Beacame a lead date, Became a Customer date, Became a Sales Qualified Lead date, etc. I want to create a bar chart that shows within a certain range of time, how many contacts became each lead category. I am having a hard time creating a bar chart where each bar is its own dimension and the data is a count of emails with dates in the specified range.

       

      Does anyone know if this is possible? I can't pivot the data.

       

      -Nicole