8 Replies Latest reply on Jan 17, 2017 12:19 PM by Shinichiro Murakami

    Two Date fields and one measure

    Sri K

      Hi Friends,


      I have 2 date fields(Project start date and Project Finish date) and one measure is count of Projects. I want to display how many projects are started and finished on 2015, 2016 and 2017(quarter wise).


      I have taken two date fields on single axis and showing the values, i have shown lines and getting correct values for all years. When I am trying to filter in Project start date and project finish date as 2015, 2016 and 2017 year values I am getting wrong values.


      Here I am attaching the twbx file for reference, please suggest me how can I show, how many projects are started and how many projects are finished in the 2015 Q1, 2015 Q2, 2015 Q3------ 2017 Q3, 2017 Q4.


      And suggest me different visualization other than line chart.


      More appreciate for helping on this.


      Thanks in Advance.