Profile Picture

0 count for the bar chart

Posted By wen ming 11 Years Ago

0 count for the bar chart

Author
Message
wen ming
Posted 11 Years Ago
View Quick Profile
Forum Newbie

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
Last Active: 11 Years Ago
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.



Similar Topics


Reading This Topic

1 active, 1 guest, 0 members, 0 anonymous.
No members currently viewing this topic!