1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Salesforce administrators, implementation experts, developers and anybody in-between

-- Popular questions requiring answers
-- Users coming from search engines

select top 25
Id as [Post Link],
datediff(d, CreationDate, getdate()) as AgeDays,
Score, ViewCount, AnswerCount,
ViewCount / (AnswerCount + 1) as Views2Answers
--( ViewCount / AgeDays ) as ViewsPerDay
from Posts
where
  PostTypeId = 1 and
  AcceptedAnswerId is null and
  ClosedDate is null and
  CommunityOwnedDate is null and
  CreationDate > '2017-02-01'
--  AnswerCount = 0
order by ViewCount desc

view current version

edited mar 3 17

created dec 21 13 Anton.