Add query relevance timeline to event search (and general search when available)

[evamaxfield]

Feature Description

A clear and concise description of the feature you're requesting.

The "classic" keyword relevance over time plot:

x is time / dates
y is relevance of search query

on hover of the points it shows the meeting that happened to make that query relevant
in the hover details you can click a link to the event

probably want some method for changing the x axis timeline, zoom or or scroll to change dates shown

Use Case

Please provide a use case to help us understand your request in context.

1. it seems fun
2. it provides another method for seeing the contextual history of a query over a council
3. it can help show people that we can do interesting things with our data model -- get them interested in the "analysis" side of CDP

CC @tohuynh

[tohuynh]

• Where does the chart live in the app?
  Another page that is linked in the app bar -- "Trends" or "Data visualization" or whatever title is appropriate. The page consists of a search bar and when there is a query it will consist of the search bar and the chart.

• Another feature to explore: allow users to compare up to 5 queries -- one line in the chart for each query.

---

UI considerations

• Page title -- Explore topics discussed in <muni name>?
• the UI for adding more queries to compare
• see https://trends.google.com/trends/?geo=US for inspirations

[evamaxfield]

• Where does the chart live in the app?
  Another page that is linked in the app bar -- "Trends" or "Data visualization" or whatever title is appropriate. The page consists of a search bar and when there is a query it will consist of the search bar and the chart.

Great question and ideas.

I personally would love to have a chart on rendered on the search page so like right after a user searches it shows. BUT, there could be a button that links to the "trends" page or w.e. we want to call it that allows for adding more queries and such

Another feature to explore: allow users to compare up to 5 queries -- one line in the chart for each query.

Agree. I think in my head the first render shows the various n-grams spawned from the search but they should totally be able to add and remove terms.

---

Page title -- Explore topics discussed in ?

I wouldn't use the word topics, I would use like "Keywords over time" -- when we actually make a topic model we want to keep them separate / not confuse the two terms.

Here is the official google ngram viewer which i think is a bit closer to what we are aiming for: https://books.google.com/ngrams

[BrianL3]

Just for clarification, this is like... what n-grams are showing up in all council meetings, over time? Like, if bike lanes are a popular topic over the summer, and then get overshadowed by rent control in the fall, something like that?

[evamaxfield]

Yes exactly that!

[evamaxfield]

Update on this. We would need an analytics database to really do this properly. The TF-IDF scores over time aren't the most valuable thing.