Example: I entered 10 items in a list this month and now I would like to see the number 10 display in another web part in another page. I don't want to see the individual items I just want to display something like this:

Current Month submission = 10

Each item has a different date time stamped on a custom field.

  • Do you want SharePoint OOTB solution or custom code? – Rustam Ismagilov Apr 1 '16 at 14:34
  • I prefer OOTB but if custom code is easier I can do that as well. – F.Rosario Apr 1 '16 at 20:26
  • I should have elaborated a little more than what I did. I am creating a splash page. I was tasked to create a little web part about 205 Pixels wide that would display abstract information from another SharePoint survey list. They want to display the number of submissions that were completed during the current month. The display on the web part will be as follows: "Current Month Count 10 Submissions" it is just counting the number of items submitted for the current month. – F.Rosario Apr 5 '16 at 19:11
  • Can you use JavaScript to get the data and render it on the splash page? – IMTheNachoMan Apr 29 '16 at 21:09

Try using Group BY in a view:

1) Create a calculated column to obtain the month

2) Create a view and group by the calculated column. Use option "collapsed groups"

  • Thank You, this works but it is only part of the solution. – F.Rosario Apr 5 '16 at 19:15
  • Yes because you can not order by the rank. – Juan Pablo Pussacq Laborde Apr 5 '16 at 19:21

There is Total section in list view section, but you would need entering current month in view filter and there will be items in view...

So, there is simple custom Javascript solution with SharePoint JSOM:

  1. Use JS to query SharePoint for list items by CAML: https://msdn.microsoft.com/en-US/en-en/library/office/jj163201.aspx "Retrieve items from a list" section. You should set date start and date end variables and use them in your CAML, here is the nice post: CAML Query with Date Range

  2. Use collListItem.get_count(); to get items count and then add value to your HTML.

Hope this helps, welcome to ask any questions.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.