November 20, 2013 at 9:43 am
Hi
I have a report that shows the time it took to do jobs as well as the time it was predicted the job would take. So...
ActualTime=1
PredTime=4
I want a gauge to show the % of jobs that were completed within their predicted time. Thing is, I can't work out the formula.
Can anyone help?
Olly
December 2, 2013 at 9:28 pm
Kind of an old post, but this is how i did it.
1. Add a calculated field to the dataset.
2. Function: OnTime=IIf(Fields!Actual.Value<=Fields!Predicted.Value,1,0)
3. Add a tablix to the report
4. 1st column: Actual, 2nd: Predicted, 3rd: OnTime (the calculated column)
5. Add a summary row, change the expression for the cell to:
=SUM(Fields!OnTime.Value)/COUNT(Fields!Actual.Value)
December 2, 2013 at 9:29 pm
Kind of an old post, but this is how i did it.
1. Add a calculated field to the dataset.
2. Function: OnTime=IIf(Fields!Actual.Value<=Fields!Predicted.Value,1,0)
3. Add a tablix to the report
4. 1st column: Actual, 2nd: Predicted, 3rd: OnTime (the calculated column)
5. Add a summary row, change the expression for the cell to:
=SUM(Fields!OnTime.Value)/COUNT(Fields!Actual.Value)
Then just change the formatting of the cell in step 5 to Percent. Right-click, Textbox Properties > Number > Percentage > Decimal Places
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply