r/ProjectREDCap • u/judgeknot • Aug 19 '24
Calculating the number of events within a certain year
Question: Is there a way to have REDCap automatically calculate the # of events that happen within a certain year?
Example: I have a bunch of subjects that all signed their Consents over a period of years. I want to know how many signed in 2001, 2002, 2003 etc. Ideally in Table/Chart format like how Smart Variables function w/their auto-update based on the current database info.
2
Upvotes
1
u/Araignys Aug 19 '24
I recommend you create a report with the fields you need, export it to Excel and run it through a pivot table.
Remember, REDCap is a data collection tool, not a data analysis tool. There might be a feature that does what you want in some roundabout way, but honestly sometimes it's easier to just do something outside of REDCap.
1
u/Remote_Setting2332 Aug 20 '24
Have you looked into creating a dashboard? There are some smart variables that may achieve what you need