Not able to find Avg aggregate function in the context menu

Post Closed

Smita Dalai

Question

Hi,

I am trying to use the Average () in the context menu, but I am not getting any option for it. Kindly help me with it. I am attaching the screenshot FYI.

Thanks,

Smita

11 Apr 2018

João Heleno

MVP

Hello Smita

You can use Average in groups of similar data.

So you must first do a Group By and then choose another column to apply the Average.

11 Apr 2018

1 reply

11 Apr 2018

Show thread

Hide thread

Smita Dalai

João Heleno wrote:

Hello Smita

You can use Average in groups of similar data.

So you must first do a Group By and then choose another column to apply the Average.

Hello Joao

I tried with your suggested solution. But still facing the same issue.

1st I tried to group the rating value and then created a new attribute "RatingAvg". I am not getting any options for "average" aggregation. Kindly help me with this.

Thanks

Smita

Context menu.png

11 Apr 2018

João Heleno

MVP

Smita,

Average must be applied to an existing column.

You added a new calculated field and it won't work.

11 Apr 2018

1 reply

11 Apr 2018

Show thread

Hide thread

Smita Dalai

João Heleno wrote:

Smita,

Average must be applied to an existing column.

You added a new calculated field and it won't work.

Hi Joao

Thanks for the information. But initially I tried with the existing column "Rating". going wrong. Please correct me where I am going wrong.

Thanks

11 Apr 2018

João Heleno

MVP

Smita,

Please provide some feedback. Did you managed to go forward or are you still having problems?

Thanks,

11 Apr 2018

Smita Dalai

Hi Joao

Thanks for the information. But initially I tried with the existing column "Rating". Please correct me where I am going wrong.

Thanks

Smita

11 Apr 2018

João Heleno

MVP

Dear Smiti,

I explained why you weren't seeing the average.

Also, I don't know what are you trying to achieve.

Whatever it is:

1. Do a Group By in Column X.

2. Do Average in Column Y.

Columns X and Y are different columns. One is X. The other is Y.

Adapt this information to your problem.

Cheers,

11 Apr 2018

Smita Dalai

Hi Joao

What I am trying to achieve is mentioned below.

1. I want to calculate the average star rating for an application.

2. I have the existing attribute "rating". I have created "count" attribute from "rating" attribute.

3. I am trying to create another attribue which will show average rating but unable to create it since the "average" is not showing.

Thanks

Smita

11 Apr 2018

1 reply

19 Mar 2019

Show thread

Hide thread

Sowndarya Subramanian

Smita Dalai wrote:

Hi Joao

What I am trying to achieve is mentioned below.

1. I want to calculate the average star rating for an application.

2. I have the existing attribute "rating". I have created "count" attribute from "rating" attribute.

3. I am trying to create another attribue which will show average rating but unable to create it since the "average" is not showing.

Thanks

Smita

Smita did you achieved your part..I'm still not getting that average func

19 Mar 2019

Paulo Duarte Ferreira

Staff

Hi Smita,

What's the Data Type of the Rating attribute?

Cheers,

Paulo

13 Apr 2018

1 reply

13 Apr 2018

Show thread

Hide thread

Smita Dalai

Paulo Ferreira wrote:

Hi Smita,

What's the Data Type of the Rating attribute?

Cheers,

Paulo

Hi Paulo,

The Data type for rating attribute is "Integer".

Thanks,

Smita

13 Apr 2018

Sowndarya Subramanian

hello,

Can anyone please clarify my doubt..

Im also not able to get the average function.

Thanks,

Sowndarya S

mycourse.png

19 Mar 2019

Paulo Duarte Ferreira

Staff

Hi Sowndarya,

What is the data type of the UserMovieRating.Rating attribute? Is it Integer or Decimal?

If it is and it still doesn't work, can you share your module so that I can take a look?

Regards,

Paulo Ferreira

19 Mar 2019

Kilian Hekhuis

MVP

Since Sawndarya already created a new topic for this, I'll close this one.

19 Mar 2019