Question: Creating a calculated measure from a dimension

[mb_me]

Hi everyone, new here and first of what I'm sure will be many questions from me.

I have an app which contains a dimension called 'elapsed time until...'. What I need is a way to calculate what the average is of that dimension.

Specifically, I have transaction data which can be categorized by Team, Case #, case rating, and elapsed time until first reply.

I need the average elapsed time until first reply by team and average elapsed time for each possible rating. 

Any hints? Thanks in advance everyone.

[hic]

You have a field called "Elapsed time". If you use this in a chart (bar chart, table, etc.), you can get what you want. Probably, you should choose "Team" as chart dimension, and Avg("Elapsed time") as measure in the chart. 

So, a field is really not a dimension unless you use it as such in a chart.

See also https://community.qlik.com/t5/Design/Dimensions-and-Measures/ba-p/1473017

[mb_me · Accepted solution]

Thank you for the quick reply! I figured out my answer. The dimension "elapsed time" was a calculation off multiple fields, as you were saying. So I opened the expression editor and copied the function. Adding it as a measure (so I could do the avg function), I just opened the expression editor again in the measures area and simply added the 'avg' function to the beginning of it all. 

Thank you for the support - this got me heading down the right path 🙂