« first day (245 days earlier)      last day (1873 days later) » 

2:28 PM
@MartinSleziak Your downvotes statistics probably should be normalized to account for changes in traffic. For instance, the downvotes / upvotes ratio would make more sense as a measure, in my opinion. — Federico Poloni 43 mins ago
If I want to calculate ratio between total number of downvotes and total number of downvotes, is this a reasonable way to do that: ROUND(1.0*SUM(CASE WHEN VoteTypeId=3 THEN 1 ELSE 0 END)/SUM(CASE WHEN VoteTypeId=2 THEN 1 ELSE 0 END),3) AS ratio
 
 
6 hours later…
8:21 PM
@Martin that formula looks fine to me.
 

« first day (245 days earlier)      last day (1873 days later) »