Hi, as a new user I was trying to take average using a metric but it is always giving me sum. "Select Score BY Date" is my first_metric and second_metric "SELECT AVG(first_metric)". Score is a column with several different tournament dates, I am trying to find the average score for each date but the output is sum of all the scores in that specific date.

Hi Wasiful, AVG function is designed to work with facts(numbers), as also described in our documentation. Could you confirm that "Score" is a fact column, please?

Hi, Score is written as attribute. It contains scores from three different tournament dates. What I have to do is to separate the scores date wise and find average score of each date.

That doesn't seem to be correct, since attributes are non-measurable. Since you are trying to work with some aggregation function(such as AVG), I'd suggest to convert it to the fact instead.

Thank you, That worked well.😇