Discussion count spreadsheet by James

[rangle]

Hello.

I have been using the Discussion Count Spreadsheet by James for quite some time and it's fabulous. However, all of the sudden the count stopped including the professor/teacher. How can I get the program to incorporate the teacher's discussion count as well as students?

[James · Accepted solution]

@Chris_Hofer, thanks for tagging me.

@rangle,

Is the instructor information on the Data sheet? If so, it's a problem with the pivot table.

You may have a filter to select only students and not teachers. Edit the pivot table and check the filters. If the pivot table controls on the right side are closed, you'll need to go to the bottom of the pivot table and click the Edit button to get them back.

A second potential issue is related to pivot tables. Pivot tables don't update if you have filters applied. Edit the Pivot Table configuration, remove the filter, and set it back if necessary.

I had a table like this on my copy of the spreadsheet where I checked your issue. It downloaded all of the information correctly, including teachers, but it was an old course. I had a filter set to active students and the enrollments were all completed, so nothing was showing. I changed the filter and then information came back.

If the instructor information is not contained on the Data page, that's a different issue; one I'm not able to duplicate.

My guesses in that case are that the instructor didn't make any posts or that the Discussion Redesign has affected things somehow. I would start with the filters in the pivot table.

[Chris_Hofer]

Hi there, @rangle ...

I am tagging @James Jones in this post so that he can respond to you.

[rangle]

Thank you--I wasn't sure how to do that.

[Chris_Hofer]

@rangle ...

No worries!  Just type the @ symbol, and you can tag people or even tag documents here in the Community if you happen to know what the title of the document or discussion thread is.  It will create a link to the user's profile or a link to the document or discussion thread.  Pretty slick!

[rangle]

Thanks!

[James · Accepted solution]

@Chris_Hofer, thanks for tagging me.

@rangle,

Is the instructor information on the Data sheet? If so, it's a problem with the pivot table.

You may have a filter to select only students and not teachers. Edit the pivot table and check the filters. If the pivot table controls on the right side are closed, you'll need to go to the bottom of the pivot table and click the Edit button to get them back.

A second potential issue is related to pivot tables. Pivot tables don't update if you have filters applied. Edit the Pivot Table configuration, remove the filter, and set it back if necessary.

I had a table like this on my copy of the spreadsheet where I checked your issue. It downloaded all of the information correctly, including teachers, but it was an old course. I had a filter set to active students and the enrollments were all completed, so nothing was showing. I changed the filter and then information came back.

If the instructor information is not contained on the Data page, that's a different issue; one I'm not able to duplicate.

My guesses in that case are that the instructor didn't make any posts or that the Discussion Redesign has affected things somehow. I would start with the filters in the pivot table.

[rangle]

Hi James,

Thank you for your response. I am not very techie and actually don't know how to do what you're suggesting I do. How do I locate the filters? Thanks so much!

[James · Accepted solution]

@rangle 

It's the first day of class for me and I don't have much time to respond right now. If you go to the original post for the discussion count spreadsheet, there is a video in the instructions section of the post. It's only about 2 minutes long and starting about 1:25, it talks about how to set the filter. Could you see if that helps?

[rangle]

Absolutely James--thank you!

[rangle]

Hi James,

I just realized I was on the wrong tab at the bottom---I was on Report instead of Data. For some reason the my name (instructor) only shows up when I'm under the Data tab. Thanks so much for your help and I hope I didn't take too much time!