The identification requests are taking over! (cumulative)

1

Please login or register to vote for this query.

(click on this box to dismiss)

The y-axis is the fraction of total questions asked on the site (as of the date on the x-axis) that have the tag `TagName`.

Anime and Manga

Q&A for anime and manga fans

DECLARE @begin_date datetime = (SELECT MIN(CreationDate) FROM PostHistory);
DECLARE @end_date datetime = (SELECT MAX(CreationDate) FROM PostHistory);

DECLARE @tag nvarchar(max) = ##TagName:string?identification-request##;

WITH dates AS
(
  SELECT @begin_date AS [DateValue]
  UNION ALL
  SELECT DateValue + 1 FROM dates WHERE DateValue + 1 < @end_date
)

SELECT
  d.DateValue AS [Date],
  /*
  (SELECT COUNT(p.Id) 
   FROM Posts AS p 
   WHERE p.PostTypeId = 1 
         AND p.Tags LIKE '%' + @tag + '%'
         AND p.CreationDate < d.DateValue) AS [IdReqs],
  (SELECT COUNT(p.Id) 
   FROM Posts AS p 
   WHERE p.PostTypeId = 1
         AND p.CreationDate < d.DateValue) AS [Total],
  */
  CAST(
    (SELECT COUNT(p.Id) 
     FROM Posts AS p 
     WHERE p.PostTypeId = 1 
           AND p.Tags LIKE '%' + @tag + '%'
           AND p.CreationDate < d.DateValue)
    AS float) / CAST(
    (SELECT COUNT(p.Id) 
     FROM Posts AS p 
     WHERE p.PostTypeId = 1
           AND p.CreationDate < d.DateValue) + 1 -- prevent division by zero
    AS float) AS [Fraction]
FROM
  dates AS d
OPTION (MAXRECURSION 0)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results