« first day (98 days earlier)      last day (2506 days later) » 

Aurora0001
Aurora0001
2:54 PM
Congratulations to our first six Fanatics:
 
 
2 hours later…
Aurora0001
Aurora0001
4:33 PM
Want to see how many posts you've contributed as a percentage of the site's posts?
Modify this one with your details: data.stackexchange.com/iot/query/641692/…
On the y-axis, 0 = 0% and 1 = 100%
Also, the SQL on that is horrible, but it works, so meh
 
anonymous2
anonymous2
4:49 PM
@Aurora0001 What are timestep and timeIterations?
 
Aurora0001
Aurora0001
It will loop every timestep days, for (timeIterations * timestep) days
e.g. Every 5 days for 5*20 days
 
anonymous2
anonymous2
Any idea what I'm doing wrong?
 
Aurora0001
Aurora0001
@anonymous2 Try editing this one with your details
I think the first one is the old version of the query
 
Sean Houlihane
Sean Houlihane
same for me. I can see Aurora's, but not my own (unless I modify UID in the 2nd link)
 
anonymous2
anonymous2
That worked.
@SeanHoulihane Yep, same here.
 
Aurora0001
Aurora0001
4:52 PM
Edited to fix that :P
Just modify my version; the original one runs the query but doesn't output it because I forgot to add a SELECT * FROM @NewTable;
 
anonymous2
anonymous2
@Aurora0001, not very encouraging. Highest I've gotten is .04%. :) Thanks for the share!
 
Aurora0001
Aurora0001
@anonymous2 You mean 4%, I assume
 
anonymous2
anonymous2
@Aurora0001 Oh, I suppose.
That makes more sense.
 
Aurora0001
Aurora0001
I was too lazy to introduce a * 100
 
anonymous2
anonymous2
Also explains why you were only at 1.4. ;)
JK, OC.
 
Aurora0001
Aurora0001
4:55 PM
 

« first day (98 days earlier)      last day (2506 days later) »