2 Replies Latest reply on Nov 8, 2018 3:42 AM by Priyanka Jose

    Graph to show new vistors compared to previous weeks data only

    Priyanka Jose



      I want to create a bar chart that shows new visitors count only by comparing it with the previous weeks data.

      I tried doing this :

      created calculated field ] :   [cc_new_REPAET]

      SUM(IF ([Record Created date]) = { FIXED [GUI]:max(([Record Created date]))-7} THEN 1 ELSE

      0 end

      and then created this: to get bew visitors too this week compared to previous week(ignore rest of the dates)


      IF  { FIXED [Record Created date],[GUI]:[cc_new_REPAET]} = 1 THEN






      But it isn't helping. any thoughts?