How can you use your CMMS for charting, reporting, and analysis (CRA)? You have two options:
Use its built-in CRA tools (if they exist and are robust).
Use Excel for CRA (export data from your CMMS).
Because your CRA is only as good as the data you collect and input to the CMMS, start with good data collection rules. It's normal to
not have good data collection rules in place, so don't assume you have such rules. Your CMMS vendor should be able to help you set these up for your specific needs.
Focus on problems you must solve, not on how much data you can gather.