Support grouping by and aggregating on same function

Created on 16 December 2024, about 1 month ago

Support grouping by and aggregating on same function.

✨ Feature request
Status

Active

Version

1.0

Component

Code

Created by

πŸ‡¨πŸ‡¦Canada nikathone Ontario

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

  • Issue created by @nikathone
  • πŸ‡¨πŸ‡¦Canada nikathone Ontario
  • πŸ‡¨πŸ‡¦Canada nikathone Ontario
  • πŸ‡ΊπŸ‡ΈUnited States andileco

    This branch breaks the following view:

    uuid: 6edba00a-a65d-4289-87ce-f5c7cf75812e
    langcode: en
    status: true
    dependencies:
      module:
        - views_csv_source
    id: dpi_digital_identity
    label: 'DPI - Digital Identity'
    module: views
    description: ''
    tag: ''
    base_table: csv
    base_field: ''
    display:
      default:
        id: default
        display_title: Default
        display_plugin: default
        position: 0
        display_options:
          title: 'DPI - Digital Identity'
          fields:
            value:
              id: value
              table: csv
              field: value
              relationship: none
              group_type: group
              admin_label: ''
              entity_type: null
              entity_field: null
              plugin_id: views_csv_source_field
              label: Country
              exclude: false
              alter:
                alter_text: false
                text: ''
                make_link: false
                path: ''
                absolute: false
                external: false
                replace_spaces: false
                path_case: none
                trim_whitespace: false
                alt: ''
                rel: ''
                link_class: ''
                prefix: ''
                suffix: ''
                target: ''
                nl2br: false
                max_length: 0
                word_boundary: true
                ellipsis: true
                more_link: false
                more_link_text: ''
                more_link_path: ''
                strip_tags: false
                trim: false
                preserve_tags: ''
                html: false
              element_type: ''
              element_class: ''
              element_label_type: ''
              element_label_class: ''
              element_label_colon: true
              element_wrapper_type: ''
              element_wrapper_class: ''
              element_default_classes: true
              empty: ''
              hide_empty: false
              empty_zero: false
              hide_alter_empty: true
              key: Country
              trusted_html: false
            value_1:
              id: value_1
              table: csv
              field: value
              relationship: none
              group_type: group
              admin_label: ''
              plugin_id: views_csv_source_field
              label: 'Claim of digital (or electronic) ID'
              exclude: false
              alter:
                alter_text: false
                text: ''
                make_link: false
                path: ''
                absolute: false
                external: false
                replace_spaces: false
                path_case: none
                trim_whitespace: false
                alt: ''
                rel: ''
                link_class: ''
                prefix: ''
                suffix: ''
                target: ''
                nl2br: false
                max_length: 0
                word_boundary: true
                ellipsis: true
                more_link: false
                more_link_text: ''
                more_link_path: ''
                strip_tags: false
                trim: false
                preserve_tags: ''
                html: false
              element_type: ''
              element_class: ''
              element_label_type: ''
              element_label_class: ''
              element_label_colon: true
              element_wrapper_type: ''
              element_wrapper_class: ''
              element_default_classes: true
              empty: ''
              hide_empty: false
              empty_zero: false
              hide_alter_empty: true
              key: 'Claim of digital (or electronic) ID'
              trusted_html: false
            value_2:
              id: value_2
              table: csv
              field: value
              relationship: none
              group_type: group
              admin_label: ''
              plugin_id: views_csv_source_field
              label: Region
              exclude: false
              alter:
                alter_text: false
                text: ''
                make_link: false
                path: ''
                absolute: false
                external: false
                replace_spaces: false
                path_case: none
                trim_whitespace: false
                alt: ''
                rel: ''
                link_class: ''
                prefix: ''
                suffix: ''
                target: ''
                nl2br: false
                max_length: 0
                word_boundary: true
                ellipsis: true
                more_link: false
                more_link_text: ''
                more_link_path: ''
                strip_tags: false
                trim: false
                preserve_tags: ''
                html: false
              element_type: ''
              element_class: ''
              element_label_type: ''
              element_label_class: ''
              element_label_colon: true
              element_wrapper_type: ''
              element_wrapper_class: ''
              element_default_classes: true
              empty: ''
              hide_empty: false
              empty_zero: false
              hide_alter_empty: true
              key: Region
              trusted_html: false
          pager:
            type: none
            options:
              offset: 0
              items_per_page: null
          exposed_form:
            type: basic
            options:
              submit_button: Apply
              reset_button: true
              reset_button_label: Reset
              exposed_sorts_label: 'Sort by'
              expose_sort_order: true
              sort_asc_label: Asc
              sort_desc_label: Desc
          access:
            type: none
            options: {  }
          cache:
            type: tag
            options: {  }
          empty: {  }
          sorts: {  }
          arguments: {  }
          filters:
            value_select:
              id: value_select
              table: csv
              field: value_select
              relationship: none
              group_type: group
              admin_label: ''
              plugin_id: views_csv_source_filter_select
              operator: in
              value: {  }
              group: 1
              exposed: true
              expose:
                operator_id: value_select_op
                label: Region
                description: ''
                use_operator: false
                operator: value_select_op
                operator_limit_selection: false
                operator_list: {  }
                identifier: value_select
                required: false
                remember: false
                multiple: false
                remember_roles:
                  authenticated: authenticated
                  anonymous: '0'
                  administrator: '0'
                reduce: false
              is_grouped: false
              group_info:
                label: ''
                description: ''
                identifier: ''
                optional: true
                widget: select
                multiple: false
                remember: false
                default_group: All
                default_group_multiple: {  }
                group_items: {  }
              key: Region
              empty_cell_behavior: none
              multi_value_cell_separator: ''
            value_select_1:
              id: value_select_1
              table: csv
              field: value_select
              relationship: none
              group_type: group
              admin_label: ''
              plugin_id: views_csv_source_filter_select
              operator: in
              value: {  }
              group: 1
              exposed: true
              expose:
                operator_id: value_select_1_op
                label: 'Income Classification'
                description: ''
                use_operator: false
                operator: value_select_1_op
                operator_limit_selection: false
                operator_list: {  }
                identifier: value_select_1
                required: false
                remember: false
                multiple: false
                remember_roles:
                  authenticated: authenticated
                  anonymous: '0'
                  administrator: '0'
                reduce: false
              is_grouped: false
              group_info:
                label: ''
                description: ''
                identifier: ''
                optional: true
                widget: select
                multiple: false
                remember: false
                default_group: All
                default_group_multiple: {  }
                group_items: {  }
              key: 'Income classification'
              empty_cell_behavior: none
              multi_value_cell_separator: ''
          style:
            type: table
            options:
              grouping: {  }
              row_class: ''
              default_row_class: true
              columns:
                value: value
              default: '-1'
              info:
                value:
                  sortable: false
                  default_sort_order: asc
                  align: ''
                  separator: ''
                  empty_column: false
                  responsive: ''
              override: true
              sticky: false
              summary: ''
              empty_table: false
              caption: ''
              description: ''
          row:
            type: fields
          query:
            type: views_csv_source_query
            options:
              csv_file: 'https://docs.google.com/spreadsheets/d/1PSGB9QXLAHSBJczbim0vUaO2wZb8xAJ8RBaZAvNRlc4/export?format=csv&gid=300844355#gid=300844355'
              headers: ''
              request_method: get
              request_body: ''
              show_errors: true
          relationships: {  }
          group_by: true
          header: {  }
          footer: {  }
          display_extenders: {  }
        cache_metadata:
          max-age: -1
          contexts:
            - 'languages:language_interface'
            - url
          tags: {  }
      attachment_1:
        id: attachment_1
        display_title: Attachment
        display_plugin: attachment
        position: 1
        display_options:
          fields:
            value_1:
              id: value_1
              table: csv
              field: value
              relationship: none
              group_type: group
              admin_label: ''
              plugin_id: views_csv_source_field
              label: 'Claim of digital (or electronic) ID'
              exclude: false
              alter:
                alter_text: false
                text: ''
                make_link: false
                path: ''
                absolute: false
                external: false
                replace_spaces: false
                path_case: none
                trim_whitespace: false
                alt: ''
                rel: ''
                link_class: ''
                prefix: ''
                suffix: ''
                target: ''
                nl2br: false
                max_length: 0
                word_boundary: true
                ellipsis: true
                more_link: false
                more_link_text: ''
                more_link_path: ''
                strip_tags: false
                trim: false
                preserve_tags: ''
                html: false
              element_type: ''
              element_class: ''
              element_label_type: ''
              element_label_class: ''
              element_label_colon: true
              element_wrapper_type: ''
              element_wrapper_class: ''
              element_default_classes: true
              empty: ''
              hide_empty: false
              empty_zero: false
              hide_alter_empty: true
              key: 'Claim of digital (or electronic) ID'
              trusted_html: false
            value:
              id: value
              table: csv
              field: value
              relationship: none
              group_type: count
              admin_label: ''
              entity_type: null
              entity_field: null
              plugin_id: views_csv_source_field
              label: Count
              exclude: false
              alter:
                alter_text: false
                text: ''
                make_link: false
                path: ''
                absolute: false
                external: false
                replace_spaces: false
                path_case: none
                trim_whitespace: false
                alt: ''
                rel: ''
                link_class: ''
                prefix: ''
                suffix: ''
                target: ''
                nl2br: false
                max_length: 0
                word_boundary: true
                ellipsis: true
                more_link: false
                more_link_text: ''
                more_link_path: ''
                strip_tags: false
                trim: false
                preserve_tags: ''
                html: false
              element_type: ''
              element_class: ''
              element_label_type: ''
              element_label_class: ''
              element_label_colon: true
              element_wrapper_type: ''
              element_wrapper_class: ''
              element_default_classes: true
              empty: ''
              hide_empty: false
              empty_zero: false
              hide_alter_empty: true
              key: Country
              trusted_html: false
          pager:
            type: none
            options:
              offset: 0
          defaults:
            group_by: false
            fields: false
          group_by: true
          display_extenders: {  }
          displays:
            page_1: page_1
          inherit_exposed_filters: true
        cache_metadata:
          max-age: -1
          contexts:
            - 'languages:language_interface'
            - url
          tags: {  }
      page_1:
        id: page_1
        display_title: Page
        display_plugin: page
        position: 1
        display_options:
          fields:
            value:
              id: value
              table: csv
              field: value
              relationship: none
              group_type: group
              admin_label: ''
              entity_type: null
              entity_field: null
              plugin_id: views_csv_source_field
              label: Country
              exclude: false
              alter:
                alter_text: false
                text: ''
                make_link: false
                path: ''
                absolute: false
                external: false
                replace_spaces: false
                path_case: none
                trim_whitespace: false
                alt: ''
                rel: ''
                link_class: ''
                prefix: ''
                suffix: ''
                target: ''
                nl2br: false
                max_length: 0
                word_boundary: true
                ellipsis: true
                more_link: false
                more_link_text: ''
                more_link_path: ''
                strip_tags: false
                trim: false
                preserve_tags: ''
                html: false
              element_type: ''
              element_class: ''
              element_label_type: ''
              element_label_class: ''
              element_label_colon: true
              element_wrapper_type: ''
              element_wrapper_class: ''
              element_default_classes: true
              empty: ''
              hide_empty: false
              empty_zero: false
              hide_alter_empty: true
              key: Country
              trusted_html: false
            value_1:
              id: value_1
              table: csv
              field: value
              relationship: none
              group_type: group
              admin_label: ''
              plugin_id: views_csv_source_field
              label: 'Claim of digital (or electronic) ID'
              exclude: false
              alter:
                alter_text: false
                text: ''
                make_link: false
                path: ''
                absolute: false
                external: false
                replace_spaces: false
                path_case: none
                trim_whitespace: false
                alt: ''
                rel: ''
                link_class: ''
                prefix: ''
                suffix: ''
                target: ''
                nl2br: false
                max_length: 0
                word_boundary: true
                ellipsis: true
                more_link: false
                more_link_text: ''
                more_link_path: ''
                strip_tags: false
                trim: false
                preserve_tags: ''
                html: false
              element_type: ''
              element_class: ''
              element_label_type: ''
              element_label_class: ''
              element_label_colon: true
              element_wrapper_type: ''
              element_wrapper_class: ''
              element_default_classes: true
              empty: ''
              hide_empty: false
              empty_zero: false
              hide_alter_empty: true
              key: 'Claim of digital (or electronic) ID'
              trusted_html: false
            value_2:
              id: value_2
              table: csv
              field: value
              relationship: none
              group_type: group
              admin_label: ''
              plugin_id: views_csv_source_field
              label: 'Status of Implementation'
              exclude: false
              alter:
                alter_text: false
                text: ''
                make_link: false
                path: ''
                absolute: false
                external: false
                replace_spaces: false
                path_case: none
                trim_whitespace: false
                alt: ''
                rel: ''
                link_class: ''
                prefix: ''
                suffix: ''
                target: ''
                nl2br: false
                max_length: 0
                word_boundary: true
                ellipsis: true
                more_link: false
                more_link_text: ''
                more_link_path: ''
                strip_tags: false
                trim: false
                preserve_tags: ''
                html: false
              element_type: ''
              element_class: ''
              element_label_type: ''
              element_label_class: ''
              element_label_colon: true
              element_wrapper_type: ''
              element_wrapper_class: ''
              element_default_classes: true
              empty: ''
              hide_empty: false
              empty_zero: false
              hide_alter_empty: true
              key: 'Status of implementation'
              trusted_html: false
            value_3:
              id: value_3
              table: csv
              field: value
              relationship: none
              group_type: group
              admin_label: ''
              plugin_id: views_csv_source_field
              label: 'Collects or uses biometric data'
              exclude: false
              alter:
                alter_text: false
                text: ''
                make_link: false
                path: ''
                absolute: false
                external: false
                replace_spaces: false
                path_case: none
                trim_whitespace: false
                alt: ''
                rel: ''
                link_class: ''
                prefix: ''
                suffix: ''
                target: ''
                nl2br: false
                max_length: 0
                word_boundary: true
                ellipsis: true
                more_link: false
                more_link_text: ''
                more_link_path: ''
                strip_tags: false
                trim: false
                preserve_tags: ''
                html: false
              element_type: ''
              element_class: ''
              element_label_type: ''
              element_label_class: ''
              element_label_colon: true
              element_wrapper_type: ''
              element_wrapper_class: ''
              element_default_classes: true
              empty: ''
              hide_empty: false
              empty_zero: false
              hide_alter_empty: true
              key: 'Collects or uses biometric data'
              trusted_html: false
          defaults:
            group_by: false
            fields: false
          group_by: false
          display_extenders: {  }
          path: dpi/digital-identity
        cache_metadata:
          max-age: -1
          contexts:
            - 'languages:language_interface'
            - url
          tags: {  }
    
    
  • πŸ‡¨πŸ‡¦Canada nikathone Ontario
  • Pipeline finished with Skipped
    about 1 month ago
    #382312
  • πŸ‡ΊπŸ‡ΈUnited States andileco

    This fixes it for me - thank you!

  • Automatically closed - issue fixed for 2 weeks with no activity.

Production build 0.71.5 2024