7 Replies Latest reply: Aug 12, 2016 6:50 AM by Nishanthi Rajendran RSS

    Line Chart - dynamic calculation of dimension without any selection

    Nishanthi Rajendran

      count({<[Derived Demand Status]={'Open','Coverage External','Coverage Internal','Internally Proposed'},[RR Start Date]={"<=$(=vNextMonth)"}>}[RR Sub-Request Id])

       

      In vNextMonth ( variable used at front end ), we have the first day of the starting month i.e, if it is June then vNextMonth contains 01-07-2016

       

      By creating a Line Chart and having Months in the dimension , the values are correct only if we select a month from the filter pane . Or otherwise the value is not popping out properly. Any solution that it should take dynamically ?