Forum Discussion

PolarBear's avatar
PolarBear
Helper I
6 years ago
Solved

Consecutive Weeks frequency has increased & consecutive weeks ranked in Top 10

I need to create either a table, column or calculated measure to determine the following metrics:

  • Rank of request (based off of avg. response time, highest to lowest)
  • Consecutive Week's that the avg. response time has increased (weeky avg. response time is being compared to the prior 3 month avg. response time)
  • Consecutive Week's that the request has been in the top 10

I have a fact table that contains each request by time (timestamp formatted to date) and the response time of the request. I also have a date table.