Skip to main content
added 21 characters in body
Source Link
rene Mod
  • 92k
  • 17
  • 244
  • 515

No, you can't plot viewcount over time from SEDE.

The viewcount is recorded in the posts table for question types (posttypeid = 1) and that table only holds the last known value.

Significant actions on a post are kept in the posthistory table but a view is not considered to be a significant event and isn't stored there either.

Your only option is to track questions by your self that appear in the hot questions list and their viewcount (which is available from the [Stack API][1]Stack API) and store that in your own datastore at regular intervals for processing later.

[1]: https://api.stackexchange.com/docs/questions-by-ids#order=desc&sort=activity&ids=292366&filter=!8IgyDPPl9-4O(XEMnvmBQ&site=meta&run=true

No, you can't plot viewcount over time from SEDE.

The viewcount is recorded in the posts table for question types (posttypeid = 1) and that table only holds the last known value.

Significant actions on a post are kept in the posthistory table but a view is not considered to be a significant event and isn't stored there either.

Your only option is to track questions by your self that appear in the hot questions list and their viewcount (which is available from the [Stack API][1]) and store that in your own datastore for processing later.

[1]: https://api.stackexchange.com/docs/questions-by-ids#order=desc&sort=activity&ids=292366&filter=!8IgyDPPl9-4O(XEMnvmBQ&site=meta&run=true

No, you can't plot viewcount over time from SEDE.

The viewcount is recorded in the posts table for question types (posttypeid = 1) and that table only holds the last known value.

Significant actions on a post are kept in the posthistory table but a view is not considered to be a significant event and isn't stored there either.

Your only option is to track questions by your self that appear in the hot questions list and their viewcount (which is available from the Stack API) and store that in your own datastore at regular intervals for processing later.

Source Link
rene Mod
  • 92k
  • 17
  • 244
  • 515

No, you can't plot viewcount over time from SEDE.

The viewcount is recorded in the posts table for question types (posttypeid = 1) and that table only holds the last known value.

Significant actions on a post are kept in the posthistory table but a view is not considered to be a significant event and isn't stored there either.

Your only option is to track questions by your self that appear in the hot questions list and their viewcount (which is available from the [Stack API][1]) and store that in your own datastore for processing later.

[1]: https://api.stackexchange.com/docs/questions-by-ids#order=desc&sort=activity&ids=292366&filter=!8IgyDPPl9-4O(XEMnvmBQ&site=meta&run=true