Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Running Totals Based Upon Teams In Data

Hi, I'm trying to get running totals based upon teams, so, what I mean is, how many calls a team has got where the value is a count. This needs to be a count of ID based upon a team, then the process...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks, this is what the data looks like, I need running totals instead of the default ones so that I can get the percentage right.

 

As you can see from the image, when trying to get a percentage across the rows, this is what I get. If I try by columns, then it gives the following.

 

It needs to be from 'MyWorkList Case'[First Time Fix] / 'MyWorkList Case'[ID] * 100. ID needs to be total calculated by team as well as First Time Fix. Hope it makes sense?

 

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

Anonymous If I am understanding you, you are looking for percent completed first time, not running total. 

 

You cannot do this with the show values as. You will need to create a new measure: 

 

Percent First Time = DIVIDE( COUNT( 'MyWorkList Case'[First Time Fix]) , COUNT( 'MyWorkList Case'[ID] ) )

 

Format it as a percent (You don't need to multiply by 100). 

 

Then add this to the matrix visual in your screenshot. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi kallie, thanks for this, but when I add it as an additional column, I get ann error with my visual.