5 Replies Latest reply on Dec 20, 2017 3:06 PM by Norbert Maijoor

    Previous three days & Next three days

    Sean Conner

      Hi Everyone,

       

      I have an ask. When a user selects a date, the view should be showing the previous three days, the selected day and the next three days.

       

      Let's say, if the user is selecting 12/14/2017. The view should display (on a line chart) 12/11/2017,12/12/2017,12/13/2017,12/14/2017(user selected date), 12/15/2017,12/16/2017,12/17/2017. The measure here is Sales.

       

      So on X-axis, it has to display seven days of data(Sales). This has to be dynamic, meaning the user can select any date. The view has to show the previous three and the next three days of the selection.

       

      Please help.

       

      Thanks,

      Sean.