7 Replies Latest reply: Sep 6, 2016 1:56 PM by Christian Vetter RSS

    Change line chart style interactively (remove dimension)

    Christian Vetter

      Hi all,

      this is my data:

      Country

      MonthItemsSold
      1Jan12
      1Feb15
      1Mar17
      1Apr3
      1May17
      1Jun18
      2Jan15
      2Feb17
      2Mar19
      2Apr16
      2May18
      2Jun12

       

      I show this data in a line chart. Month and Country are the dimension, ItemsSold is displayed on the y axis (accumulated).

      Now I am looking for a way to change the style of the line chart so that the country dimension is somehow removed and the ItemsSold of all countries get accumulated per month, e.g. for January, the values shown in the graph should be 27, instead of 12 and 15.

      1. How can I define to accumulate per month?

      2. Is there a way to let the user interactively switch between these two styles?

       

      Thank you,

       

      Christian