| Time |
Nick |
Message |
| 01:08 |
|
bshum joined #evergreen |
| 06:54 |
|
collum joined #evergreen |
| 07:29 |
|
kworstell_isl joined #evergreen |
| 07:29 |
|
kworstell-isl joined #evergreen |
| 08:04 |
|
BDorsey joined #evergreen |
| 09:04 |
|
dguarrac joined #evergreen |
| 09:16 |
|
Dyrcona joined #evergreen |
| 09:40 |
|
mantis1 joined #evergreen |
| 12:01 |
|
jihpringle joined #evergreen |
| 14:35 |
Dyrcona |
Hm... I want to get the average of holds captured per day of the week for each hour...I think I need a window function. |
| 14:38 |
Dyrcona |
This feels like too much for a Friday afternoon. :) |
| 14:41 |
Dyrcona |
Why are holds being captured at 2:00 AM? |
| 14:44 |
Dyrcona |
Oh, wait. That's the hold targeter. I don't want capture_time, anyway. I want shelf_time. |
| 14:44 |
Dyrcona |
It is too much for a Friday afternoon. |
| 15:50 |
Dyrcona |
Think I can do the average thing with a CTE or selecting from a query. |
| 15:51 |
Dyrcona |
I don't really need the information now, but I'm still curious. |
| 15:58 |
Dyrcona |
yes, that works. |
| 15:59 |
Dyrcona |
Except that this average does not count missing entries as 0. |
| 16:00 |
Dyrcona |
Which it should to be correct.... |
| 16:02 |
Dyrcona |
That's the tricky part with SQL: finding stuff that's not there. |
| 16:03 |
Dyrcona |
Ooh, "grouping sets" |
| 16:08 |
Dyrcona |
I think what I want is the count of holds put on the shelf at a given hour divided by the number of days represented in the sample, but that's still not quite right. |
| 16:08 |
Dyrcona |
And, I probably want to switch to action.all_hold_request. |
| 16:09 |
Dyrcona |
Meh, whatever. I 've already solved the problem of picking a time of day to run something so that it will be least likely to cause a disruption. |
| 16:10 |
Dyrcona |
Happy weekend, #evergreen! |
| 16:10 |
* Dyrcona |
poofs out. |
| 16:20 |
csharp_ |
@hate AI bots |
| 16:20 |
pinesol |
csharp_: The operation succeeded. csharp_ hates AI bots. |
| 17:02 |
|
mantis1 left #evergreen |
| 19:16 |
|
dmoore_doppel joined #evergreen |
| 20:55 |
|
dmoore_beta joined #evergreen |
| 21:12 |
|
dmoore joined #evergreen |
| 22:17 |
|
dmoore_doppel joined #evergreen |
