Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to calculate the sum using the prior number which is aggregated by CDE and DimensionA.
Now I am trying to calculate cumulative observations, which is
A Completeness 25000
A Validity 26000 (25000+1000)
A Accuracy 26500.(25000+1000+500)
I got this using the expression:
RangeSum(Above(Total aggr(sum([Ruleset Failing Records]),[Associated DQ Dimension]CDE Name]),0,RowNo()) .
When I select Accuracy I get 500, instead of 26500.
Can anyone cme across this situation?
Thanks in advance!
Message was edited by: Varun Reddy
I don't understand the point of using Aggr() function if you have both your Aggr() dimensions as the chart dimension? What exactly are you trying to do? Do you have more dimensions then the ones you are showing or what is the requirement?
I don't see option to upload.
This is what I see. Can you navigate me, I will upload.
Check here:
Sunny,
I don't have any other dimensions. I have added my QVW and source file. Please take a look.
Check the attached
RangeSum(Above(Sum({<[DQ Dimesnion]>}Failed), 0, RowNo())) * Avg(1)
Thanks for the response. But, It is showing 26500 for all the selections.
You used a sort expression which needed to be fixed as well
Match(Only({1}[DQ Dimesnion]), 'Completeness', 'Validity', 'Accuracy')
Thanks Sunny,
It's working
Cheers,
VK
Robin,
Thanks for your response
Cheers,
VK