Not able to find Avg aggregate function in the context menu

Not able to find Avg aggregate function in the context menu

  

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

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.



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




Smita,

Average must be applied to an existing column.

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

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

Smita,

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


Thanks,

JH


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

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,

JH


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

Hi Smita,

What's the Data Type of the Rating attribute?

Cheers,

Paulo

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