I have a set of entries.
One of the fields is the date (_date).
Another field is the name of a building (_Building): A,B,C, etc.
When the building was active, there is an entry with the date and the name of the building.
When there is no entry for a specicif date and a specific building, it means the building was not active.
I want to plot the number of buildings active per day.
For that I have the Date field on the X axis, and values are "Count of _Building".
This works perfectly.
Now, if I want to see the sum of the days each building was active each month, I group the _Date per Month.
Because my data goes for 18 months (March 2010 to August 2011), I also need to group the _Date per year so I do not "superimpose" the months of different years (I would otherwise for example end up with March 2010 + March 2011).
This works fine.
BUT, I end up with a chart which goes from January 2010 to December 2011.
I would like to have my X axis going from March 2010 to August 2011. (so get rid of Jan 10, Feb 10, Sept 11, Oct 11, Nov 11, and Dec 11)
If I filter/untick some months, it removes the month but for ALL the years.
I could I deal with that ?
PS: Some months do not record any active building, so I used the "Show items with no data" option of the Filed Settings (tab "Layout & Print") of _Date.