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

      Hey,

       

      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

          "New"

      ELSE

          "Return"

      END

       

      But it isn't helping. any thoughts?

       

      Thanks:)