Home » Questions » Collating most viewed Questions?

Collating most viewed Questions?

1
0

I’m running a website and we use the Sabai Discuss plugin. We have multiple cities and in each city multiple venues and in each venue the same 4 questions which have user generated answers.

By looking at the website front end I can see how many views each question has, ie

city 1  – venue 1 – question 1 – 1234 views
city 1  – venue 1 – question 2 – 400 views
city 1  – venue 1 – question 3 – 6000 views
city 1  – venue 1 – question 4 – 1645 views

city 2  – venue 3 – question 1 – 8443 views
city 2  – venue 3 – question 2 – 3421 views
city 2 – venue 3 – question 3 – 1231 views
city 2  – venue 3 – question 4 – 7125 views

etc, etc.  We have hundreds of cities with hundreds of venues so thousands of questions / answers.

I want to run a process that collects the statistics on which questions have the most amount of views. Some sort of output that looks like:

city 2  – venue 3 – question 1 – 8443 views
city 2  – venue 3 – question 4 – 7125 views
city 1  – venue 1 – question 3 – 6000 views
city 2  – venue 3 – question 2 – 3421 views
city 1  – venue 1 – question 4 – 1645 views
city 1  – venue 1 – question 1 – 1234 views
city 2 – venue 3 – question 3 – 1231 views
city 1  – venue 1 – question 2 – 400 views

Can someone suggest how I can do this? I have thousands of questions/answers and I don’t want to manually go through every venue and collate that way. Surely theres a process I can run that would output this somewhere/somehow?

 

All help appreciated!

Cheers 🙂

Text field
Collating most viewed Questions?
Checkboxes
Label 3
Radio buttons
Label 1
Date field
March 22, 2017 12:57 am
  • You must to post comments
0
0

No answer to this.

  • You must to post comments
Showing 1 result
Your Answer
Guest Author
Post as a guest by filling out the fields below or if you already have an account.
Name*
E-mail*
Website
CAPTCHA*
Enter the characters shown on the image.