Forum Discussion

JimJim's avatar
JimJim
Responsive Resident
8 years ago
Solved

Average

Hello,   I am trying (and failing) to work out the average execution time of a report. I have a fact table called ReportExecution in the following (simplified) format:   Date          ReportName ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    So, maybe create a new column in your fact table:

     

    TotalTime = [ReportCount] * [AverageTime]

    Then create a measure like:

     

    MyAverage = DIVIDE(SUM([TotalTime]),SUM([ReportCount]))

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

So, maybe create a new column in your fact table:

 

TotalTime = [ReportCount] * [AverageTime]

Then create a measure like:

 

MyAverage = DIVIDE(SUM([TotalTime]),SUM([ReportCount]))

 

 

  • JimJim's avatar
    JimJim
    Responsive Resident
    8 years ago

    Excellent, thank you.