Line on Second Y Axis not Working as Expected when Drilling Up/Down

[dcadwallader]

Hey,

So, I am looking to create a graph using the data shown in image one.

Date on the shared axis, with the ability to drill up from daily data, through to months, quarters years etc.

On the primary Y axis I am looking for the Daily Inspected and Daily Passed values to be plotted, and the Cumulative Pass Rate to be plotted on the secondary Y axis.

When drilled down to daily the data is appearing as one would expect (Image Two), however when one drills up to monthly the Pass Rate on the secondary axis escalates into the thousands (Image Three). The cumulative pass rate from January through March is 60%, 71%, 69% not 2000%+Image ThreeImage TwoImage One

[HotChilli]

OK. You'll need to decide what you want to do.

You said the cumulative is 60% for January.  Is that the figure for the last day of January or an average or a max or something else?

[dcadwallader]

Yeah - that's the pass rate as the last day of January

[dcadwallader]

I'm relying on the default but am open to suggestion/correction.

It's using SUM - see image below

Image Four

[HotChilli]

Are you using a measure for cumulative pass rate or relying on the default aggregation when you pull it in to the visual?

If so, check if it's using SUM