Continuous timeline as primary x-axis


Author
Message
Wiewiek Sunarko
Wiewiek Sunarko
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)
Group: Forum Members
Posts: 6, Visits: 1

Is it possible to have a continuous timeline on the primary x-axis?

Example Data:

Issue IDStatusDateCreatedDateClosed
1Closed11/15/201012/20/2010
2Closed11/23/201101/15/2011
3Open01/08/2011
4Closed01/12/201101/18/2011
5Closed01/13/201101/16/2011
6Open01/13/2011
7Open02/01/2011
8Open02/02/2011
9Cancelled02/05/201102/06/2011

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.


Reply
Nevron Support
Nevron Support
Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)
Group: Administrators
Posts: 3.1K, Visits: 4.2K

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


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search