0 count for the bar chart


Author
Message
wen ming
wen ming
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)
Group: Forum Members
Posts: 1, Visits: 1
I'm working with a SharePoint 2007 list. And these will be the list data.
UserId LoginDateTime
1 2/2/2013 9:50:00 AM
2 1/2/2013 9:20:00 AM
3 10/2/2013 9:50:00 AM

I need create a simple bar chart to show the user count for 2013 by month. I used the pivot to get the data.

value : =COUNT(Fields!UserId)
group by: =MONTH(Fields!LoginDateTime)

The chart I created only show the Jan, Feb and Oct months. Is there any property or function i can use to show all the month from Jan to Dec. Even the count is 0 for that month.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
wen ming - 11 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search