How Can I Get The Data Of a Column

Ask the community
,
1

I want to get all data of a column.

1352×672 38.1 KB

I am trying to get this column data and get the average of this column then I’ll .text it to a text element.

2

Do you use DATASETs?

If NOT, then you can make a QUERY…
Something like this one…

import wixData from 'wix-data';

  wixData.query("myCollection")
  .find()
  .then( (results) => {
    if(results.items.length > 0) {
      let firstItem = results.items[0]; //see item below
    } else {
      // handle case where no matching items found
    }
  } )
  .catch( (err) => {
    let errorMsg = err;
  } );
3

I’ll ttry it now!

4

Now it’s getting the items BUT

1371×852 41.5 KB

I want to get just generalRatings and find the average of all ? How can I get just generalRatings or how can I get the result I mean average of generalRatings.

5

@loeix
Average = (4+4+4,5+3,3) / 4 …, right?
How you can get the total of “generalRating” ?

You can do it by a loop, or take a look at this one solution from J.D. …
https://www.wix.com/corvid/forum/community-discussion/solved-getting-sum-of-items-obtained-from-a-query

6

@russian-dima Someone did it for me but thanks for reply again