Forum Discussion
Cumulative % by month
It's the required training - not really relevant to the issue at hand except to understand where a denominator is coming from.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
I'm looking to chart cumulative training data without the underlying data adding up the way it is now when charted (see original post). I think the way to do this is to obtain the max value of a given month and the latest overall value (highlighted rows in my sample data).
I'd like to understand if my thought process is accurate for how to chart my data so it appears something like this, where each user's cumulative completion is charting toward 100%:
And if my thought process is accurate, how to get that data via a measure or caluclated column as that's where I'm stuck. Or if there's a better solution for what I'm trying to do, I'm open to that!