7 Replies Latest reply on Dec 21, 2016 1:34 PM by Mark Fagan

    How to show new stores added this week versus last week?

    Mark Fagan

      Here is the scenario.  I run weekly dashboards that displays records based on the week-ending date selected in a parameter.  I have over 500 stores and am in the process of creating a dashboard that will show me information about the new weeks data such as record count, new stores added and more...  what I want to show is the names of the NEW stores that were added this week compared to last weeks dataset only. (Once identified I need to go into the data source and flag the new store with additional modifications and categories)  Must be some calc field I can create to accomplish this...

       

      Here is an example of the dataset

       

      We DateStore

      11/12/16    

      11/12/16    

      11/19/16    

      11/19/16    

      11/26/16    

      11/26/16    

      11/26/16    

      A

      B

      A

      B

      A

      B

      C

       

      Here is what I want to show as a result ("C") because it is a new store added for we 11/26/16 that was not there for prior weeks:

       

      Store

       

      C

       

       

       

      Thanks for any direction!

      -Mark