2 Replies Latest reply: Nov 15, 2016 6:26 AM by Riyaz IM RSS

    Line Chart - 2 views

    Riyaz IM

      Hello Friends,

       

      Need your help in resolving a problem. I've 2 columns in a sheet where I need get a view per day

       

      Data looks like below. I need to plot a line graph DATE in X-axis and COUNT of ID in Y-axis. For 01-Jan CREATED LINE should give 2, 02-Jan should give 1. Similarly CLOSED LINE for 01-Jan should give 1

       

      ID        CREATED_DATE        CLOSED_DATE

      ----------------------------------------------------------------------

      100        01-Jan                            01-Jan

      101        01-Jan                            02-Jan

      102        02-Jan                            03-Jan