9 Replies Latest reply: Sep 28, 2016 2:46 AM by Eric Hannert RSS

    bar chart: time dimension - let user switch dim to year or month

    Eric Hannert

      Hi comm,

       

      i have the following problem.

      In my bar chart i show the performance for every day, there is in the database.

      so for example

      day1 50%

      day2 75%

      day3 43%

      day4 100%

       

      and so on.

      Now i want to change the dimension so be in month or even in years.

      the dateformat has the years and month like YYYY.MM.DD.

      So is there a way to make the Dimension be drilled up to month from the date. Like 2014.9.26 =>2014.9 => 2014.

      Maybe using KPI or something.

       

      Hope someone has an idea or a solution.

      Thanks in advance

      -Eric