google sheets – How to link to source cell from filter output

I have a simple query that outputs columns A and B of a project dataset, when the value in column A is not empty:

QUERY(Projects!A2:B, “SELECT A,B WHERE A<>””)

This creates an easy to scan highlight of the important project data (in my case, project name and next action item). However, the project details are in another tab, so if I want to examine the project, I have to copy the name, go to the tab, and search for the project.

It would be super nice if the output of the QUERY could automatically hyperlink to the source data. Or maybe there is a hotkey I can press to jump to the source. Does this feature exist?

google sheets – Query or filter the data when using date time format

Googlesheet: https://docs.google.com/spreadsheets/d/1hO_KatnkP58wuF6I7kwtlGgCI6xM6ubopgCwuYMXXIU/edit?usp=sharing

Sheet2

In cell A2 I have:
=QUERY(Sheet1!A1:Q, “Select * where B >= datetime ‘”&TEXT($A$1,”MM-DD-YYYY HH:mm:ss”)&”‘”)

In cell A1 I have:
6/17/2020 10:53:22 AM

Sheet1:
Column A (user) and B (date and time)
User1 6/17/2020 10:53:22 AM
User2 6/17/2020 10:53:22 AM
User3 6/17/2020 11:10:55 AM
User4 6/17/2020 11:33:57 AM
User5 6/24/2020 10:47:34 AM
User6 6/25/2020 4:50:39 AM
User7 6/24/2020 4:00:24 AM
User8 7/4/2020 5:44:25 AM
User9 7/4/2020 7:08:29 AM
User10 7/4/2020 8:49:24 AM
User11 7/3/2020 7:36:46 AM

The expected output in A2 Sheet2 is:
User1 6/17/2020 10:53:22 AM
User2 6/17/2020 10:53:22 AM

but the query I used outputs all of the data from Sheet 1.

Hope someone can help me…

filter – In a grouped list, how to display items of an intersection of two groups

Provided I have a category which gives x non mutually exclusive options.
I have a list of items which can be tagged with several of these mutually non exclusive options.

  • Item 1
  • Item 2
  • Item 3
  • Group C …

A user can now select one/several of the options so they retrieve a list of items according to each options they selected and the union of these options, if needed.

  • Group A — selected
  • Group B — selected
  • Group C

I have a constraint when it comes to displaying the result: the items must be grouped under the options they are tagged with.

This is where I am faced with a choice to make in order to display the items which are tagged with several of the select options – hence are at the intersection of several groups.

The alternatives are: display each items several times, one under each group they belong to, like so:

Or display a group for each intersection of groups

  • Group A
  • Group B
  • Group A + B

Solution 1 result in a duplication of the content (the item), solution 2, a duplication of the meta-information (the categories).

Now, this was an imaginary explanation. My real case implies 5 categories each with between 3-5 options and two nested grouping based on 2 of these categories. As a result, whichever solution comes with a big overload of duplicated information – just think of the possible combination of groups.
Nonetheless, I would like to have your opinions and knowledge on which would be the worse of two evils out of these two solutions ?

I might add that the value proposition I am working with for this content is partly, the number of items of content. Hence, albeit being more readable, I believe that solution 1 could be perceived as bearing disingenuity as it increase that number. Solution 2 would be worse in terms of readability though.

Of course, I am also investigating alternatives to grouping altogether but would like to put this problem out there for reflexion and see if someone comes with different angles than mine.

sets – Bloom filter like data structure supporting iteration

I am wondering whether there exists a data structure similiar to a bloom filter in the sense that it is an approximate finite set representation (allows for false positives, but no false negatives) and supports:

  • constant time complexity union of two sets
  • constant time complexity insertion of an element

but also allows for efficient iteration over the approximate elements in the set, i.e. iterate over all elements that are either actually in the set or false positives with a time complexity that is linear in the number of elements in the set

google cloud platform – how to filter log entries by timestamp in gcloud logging command line

Any one knows how to filter log entries by timestamp in gcloud logging command line? From google cloud site – https://cloud.google.com/logging/docs/reference/tools/gcloud-logging, I learned to read logs by command

gcloud logging read “resource.type=gce_instance AND logName=projects/[PROJECT_ID]/logs/syslog AND textPayload:SyncAddress” –limit 10 –format json

I want to know how to filter by timestamp. I need to read logs in a particular period.

thanks