Line Graph

[#1]

Hi All,

I am trying to create the following line graph:

Where Number of Completed Work Orders are compared to the Avg days to complete those work orders with the points your see above.

Avg Days      # of Work Orders

5                             100

30                             76

60                             40

90                             20

100                           10

I know I have seen this done in a post but cant locate it right now.  Any help would be awesome.

Thanks,

David

[sunny_talwar]

Is Avg days coming from your data? or is that a calculated dimension?

[#3]

It is a calculated field in my load statement:

NetWorkDays(RequestDate,ActualCompletionDate)) as DaysAged,

I am also using:

Interval(ActualCompletionDate-[RequestDate],'D') as DaysToComplete,

David

[sunny_talwar]

If everything is precalculated in the script, then may be as attached

[#5]

Did you use # Completed Work Tickets as the dimension and Completed Ticket as Expression?

[#6]

Sorry I did not see your attachment.  The number of work orders is not stored in the Load statement.

David

[sunny_talwar]

Would you be able to share some raw data? Aggregated data makes it difficult to get a sample across.

[#8]

I have attached my file.  Let me know if this makes sense.

[sunny_talwar]

How would you go about calculating # of Work Days based on DaysAged dimension?

[#10]

This is how I do it in a straight table.  I am trying to figure out how to do it in a graph.