<commit_before>strategy: SPECIFIC
collections:
  google_search:
    columns:
      - _time:
          category: null
          type: TIMESTAMP
      - _user:
          category: null
          type: LONG
      - search_term:
          category: null
          type: STRING
      - category:
          category: null
          type: STRING
reports:
  - slug: category
    category: null
    name: Google search category
    query: |-
      SELECT "category", count(*) as count FROM collection."google_search" 
      where category is not null and _time between {date[0]} and {date[1]}
      GROUP BY 1 having count(*) > 10 ORDER BY 2 desc
    shared: false
    options:
      chartType: pie
      limit: 1000
      enableStatistics: true
      tableOptions:
        enabled: true
      chartOptions: {}
      variables:
        - multiple: true
          name: date
          options: {}
          defaultValue: last_year
          type: date-range
      columnOptions:
        - displayFormat: null
          tableOptions:
            cellOptions: {}
          chartOptions: {}
        - displayFormat: null
          tableOptions:
            cellOptions: {}
          chartOptions: {}
      segments: []
      measures:
        - 1
      dimensions:
        - 0
    queryOptions: {}
  - slug: google_search_by_year
    category: null
    name: Google search by year
    query: >-
      SELECT date_part('year', _time) as year, count(*) FROM
      collection."google_search" group by 1
    shared: false
    options:
      chartType: line
      limit: 1000
      enableStatistics: true
      tableOptions:
        enabled: true
      chartOptions:
        showLabels: false
      variables: []
      segments: []
      measures:
        - 1
      dimensions:
        - 0
      columnOptions:
        - displayFormat: null
          tableOptions:
            cellOptions: {}
        - displayFormat: null
          tableOptions:
            cellOptions:
              statistics: relative
            formatNumbers: true
    queryOptions: {}
dashboards:
  - name: Personal
    items:
      - id: 581
        name: Google Searches
        directive: report
        options:
          reportSlug: category
          sizeX: 6
          sizeY: 1
          aggregation: null
          values: {}
          row: 0
          col: 0
        refreshInterval: null
        data: null
        lastUpdated: null
<commit_msg>Update google-seach-history.yaml<commit_after>strategy: SPECIFIC
reports:
  - slug: category
    category: null
    name: Google search category
    query: |-
      SELECT "category", count(*) as count FROM collection."google_search" 
      where category is not null and _time between {date[0]} and {date[1]}
      GROUP BY 1 having count(*) > 10 ORDER BY 2 desc
    shared: false
    options:
      chartType: pie
      limit: 1000
      enableStatistics: true
      tableOptions:
        enabled: true
      chartOptions: {}
      variables:
        - multiple: true
          name: date
          options: {}
          defaultValue: last_year
          type: date-range
      columnOptions:
        - displayFormat: null
          tableOptions:
            cellOptions: {}
          chartOptions: {}
        - displayFormat: null
          tableOptions:
            cellOptions: {}
          chartOptions: {}
      segments: []
      measures:
        - 1
      dimensions:
        - 0
    queryOptions: {}
  - slug: google_search_by_year
    category: null
    name: Google search by year
    query: >-
      SELECT date_part('year', _time) as year, count(*) FROM
      collection."google_search" group by 1
    shared: false
    options:
      chartType: line
      limit: 1000
      enableStatistics: true
      tableOptions:
        enabled: true
      chartOptions:
        showLabels: false
      variables: []
      segments: []
      measures:
        - 1
      dimensions:
        - 0
      columnOptions:
        - displayFormat: null
          tableOptions:
            cellOptions: {}
        - displayFormat: null
          tableOptions:
            cellOptions:
              statistics: relative
            formatNumbers: true
    queryOptions: {}
dashboards:
  - name: Personal
    items:
      - id: 581
        name: Google Searches
        directive: report
        options:
          reportSlug: category
          sizeX: 6
          sizeY: 1
          aggregation: null
          values: {}
          row: 0
          col: 0
        refreshInterval: null
        data: null
        lastUpdated: null

{'fraction_non_alphanumeric': 0.0740414279418246, 'fraction_numerical': 0.011458792419568091, 'mean_word_length': 1.55, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2965359', 'n_tokens_mistral': 1242, 'n_tokens_neox': 1180, 'n_words': 358}