2 Replies Latest reply: Feb 27, 2017 5:08 AM by Matteo Demartini RSS

    "Time Dimension based on a user-defined selection

    Matteo Demartini

      Dear all,

       

      I have to design a line chart to track the global trend in terms of revenues of a list of projects

      My first dimension is time, the second one is Project description (I need a line for each project).

       

      The hard comes since I am requested to create a kind of dynamic chart:

      - the user will select a single period (YearMonth)

      - the selection made will determine the related value of revenues

      - the user will have to determine the time range of the chart (min: selected period less x months; max:selected period plus y months)

      - revenues will have to remain constantly equal to the value of the selected period all over this fictional time range, unless the project has ended or not started yet (I am given the start and the end date as well)

       

       

      I am considering to use a couple of input boxes to let the user choose the time range.

       

      Any idea??

       

      I attach a visual rendering of the issue (the yellow line indicates the selected period)

       

      Many thanks!