Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Here is the background to my question. We are uploading field data about various moth species caught by trap. These traps are checked every month, but not always on the same day of the month.The columns are date, trap number and total moths caught. I would like to use a calculated column to show the total moths caught for each month.

Once I have the correct formula from my moth data list I can then quite easily chart it by total moths caught by month.

I know the formula would have to have YEAR and MONTH otherwise I would be adding January 2012 and January 2013 etc.

Can anyone help?

share|improve this question
add comment

2 Answers 2

If you need to visually show (to chart) the total moths caught for each month, you can try the Nevron Chart web part and its pivot engine.

You can group by Date and sum the total moths caught as Value (if needed, you can use an XY chart):
Category grouping: =Fields!Date
Value: =SUM(Fields!Total_Moths_Caught)

enter image description here

Full disclosure: I am working at Nevron Software and I have been assisting with the development of the Chart web part based on user requirements.

share|improve this answer
add comment

A calculated column wouldn't make sense for what you're trying to accomplish. A calculated column is applied per item not per list, so it wouldn't be able to total multiple items.

The right solution depends on how you are wanting to chart these. If using Excel, then you can easily group the totals with a Pivot Chart using the list in its current form. Most of the other charting options can do something similar.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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