Current Events > boss: i want you to filter out the first week of every month and give back to me

Topic List
Page List: 1
No_U_L7
06/01/21 7:54:05 PM
#1:


what do you give your boss?

1. a table consisting of the data from the first week of every month
2. a table consisting of the data from the last 3 weeks of every month
---
... Copied to Clipboard!
MedeaLysistrata
06/01/21 7:55:50 PM
#2:


No_U_L7 posted...
what do you give your boss?
Questions requesting further info I guess

---
"Why is ontology so expensive?" - JH
[Is this live?][Joyless planet...]
... Copied to Clipboard!
jsb0714
06/01/21 7:56:06 PM
#3:


2
... Copied to Clipboard!
pastaman44
06/01/21 8:20:06 PM
#4:


The real answer would be questions. I do this sort of thing all the time. Normally asking to "filter out" something means to remove something, so it would be 2. Except that that's now how weeks work in normal reports, you either do a Day, Week, Year hierarchy or you do a Day, Month, Quarter, Year hierarchy.

Months can have 5 weeks and obviously don't always start a the beginning of the week so filtering out any number of weeks from a month is stupid.

---
pastaman44 - I can't think of anything to say.
I rule the Atari 2600 Pac-Man board
... Copied to Clipboard!
yunalenne10
06/01/21 8:21:03 PM
#5:


No_U_L7 posted...
2. a table consisting of the data from the last 3 weeks of every month


---
"The more beautiful and pure a thing is, the more satisfying it is to corrupt it." - Rule 43
... Copied to Clipboard!
No_U_L7
06/01/21 8:22:40 PM
#6:


pastaman44 posted...
The real answer would be questions. I do this sort of thing all the time. Normally asking to "filter out" something means to remove something, so it would be 2. Except that that's now how weeks work in normal reports, you either do a Day, Week, Year hierarchy or you do a Day, Month, Quarter, Year hierarchy.

Months can have 5 weeks and obviously don't always start a the beginning of the week so filtering out any number of weeks from a month is stupid.


Oops, the actual event was something super esoteric so I dumbed it down. Make it first 3 days of the week then or whatever makes sense
---
... Copied to Clipboard!
No_U_L7
06/01/21 8:50:55 PM
#7:


Bump, seems like 2 is the winner so far
---
... Copied to Clipboard!
ConfessPlease
06/01/21 8:54:31 PM
#8:


MedeaLysistrata posted...
Questions requesting further info I guess
2 but also ask

---
The Heart Wants What It Wants
... Copied to Clipboard!
Topic List
Page List: 1