Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 columns in a table
1) StoryID and 2) StoryPoints
StoryID has 44 values out of which 28 values are distinct.
Now I want to find the sum of story points of all distinct StoryId's.
ie., sum(of StoryPoints (of all distinct StoryID))
because Sum of all Story Points = 258
and Sum(of StoryPoints (of all distinct StoryID)) = 166 [Which is desirable]
Looking for help and suggestions.
Thanks in advance
May be this
Sum(Aggr([Story Points], Story_Id))
or
Sum(Aggr(Avg([Story Points]), Story_Id))
or
Sum(Aggr(Min([Story Points]), Story_Id))
or
Sum(Aggr(Max([Story Points]), Story_Id))
or
Sum(Aggr(Sum(DISTINCT [Story Points]), Story_Id))