cdp-frontend icon indicating copy to clipboard operation
cdp-frontend copied to clipboard

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

Open evamaxfield opened this issue 3 years ago • 5 comments

Feature Description

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

The "classic" keyword relevance over time plot: image

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

evamaxfield avatar Feb 17 '22 05:02 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.

  • 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

tohuynh avatar Feb 18 '22 01:02 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.

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

evamaxfield avatar Feb 18 '22 18:02 evamaxfield

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?

BrianL3 avatar Feb 20 '22 00:02 BrianL3

Yes exactly that!

evamaxfield avatar Feb 20 '22 01:02 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.

evamaxfield avatar Oct 19 '22 02:10 evamaxfield