Is it possible to have a continuous timeline on the primary x-axis?
Example Data:
I would like to create a Clustered Bar chart where there's a continous timeline from Nov 2010 to Feb 2011 on the x-axis and it shows the number of issues opened and resolved by the end of the month for each month based on the DateCreated and DateClosed values.
Thank you.
Hello Wiewiek,In the example data you provided, it looks like Issue ID 2 should have DateCreated for 2010. However, we would suggest the following approach for your requirement:
1. Once you connect to your data source from the Chart Designer, go to the Pivot tab.2. From the Data Groupings – Categories tab create a new category.In Data Groupings – Categories – General tab, set the following expression in the Label field: =FIRST(YEAR(Fields!DateCreated)) + "/" + FIRST(MONTH(Fields!DateCreated))In the Group By section, add two fields and set the following expressions consecutively:=YEAR(Fields!DateCreated)=MONTH(Fields!DateCreated)To sort the entries correctly, in Data Groupings – Categories – Sorting tab, add two fields and set the following expressions consecutively:=YEAR(Fields!DateCreated)=MONTH(Fields!DateCreated)3. From the Data Groupings – Series tab, drag and drop the Status data set field to create a new series grouping:4. From the Data Groupings – Values tab, add a new Value and set the following expression for the Data Values field: =Fields![RowCount]Based on your sample data, this will generate the following chart:
Best Regards,Nevron Support Team