This content has been marked as final.
Show 3 replies
-
1. Re: Simple ratio calculation?
Tracy RodgersJun 18, 2012 12:34 PM (in response to Albert.Birck)
Hi Albert,
Would you be able to repost your workbook saving it as a twbx file?
-Tracy
-
2. Re: Simple ratio calculation?
Albert.Birck Jun 18, 2012 11:49 PM (in response to Tracy Rodgers)Sorry, here is the tbwx file.... :-)
Thanks!
Albert
-
Hours per hit.twbx.zip 11.7 KB
-
-
3. Re: Simple ratio calculation?
Jonathan DrummeyJun 19, 2012 9:21 AM (in response to Albert.Birck)
Hi Albert,
This is a case where reshaping the data makes the analysis more difficult. To get a text table to show Hits, Hours, and the Ratio, you need three calculated fields:
Hits w/formula IF [KPI] = "Hits" Then [Value] END
Hours w/formula IF [KPI] = "Hours" Then [Value] END
Hours:Hits w/formula SUM([Hours])/SUM([Hits])
Then you can use Measure Names/Values to create the text table, as in the attached.
Jonathan
-
Hours per hit jtd edit.twbx.zip 45.6 KB
-