social_kpi_lite_node_views.yml in Open Social 8.6

modules/custom/social_node_statistics/content/block_content/social_kpi_lite_node_views.yml

File

modules/custom/social_node_statistics/content/block_content/social_kpi_lite_node_views.yml

values:
  type: kpi_analytics
  info: 'KPI Analytics: Node views'
  uuid: 9bf461b4-8ef9-4af4-bc84-a97a82f447d9
fields:
  field_kpi_datasource: drupal_kpi_datasource
  field_kpi_query: >
    SELECT created, count FROM
    (
        SELECT
            FROM_UNIXTIME(n.timestamp, '%Y-%m') AS created,
            COUNT(n.nid) AS count

        FROM node_statistics n
        WHERE FROM_UNIXTIME(n.timestamp, '%Y-%m')
            BETWEEN
                FROM_UNIXTIME(UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 MONTH)), '%Y-%m')
            AND
                FROM_UNIXTIME(UNIX_TIMESTAMP(CURDATE()), '%Y-%m')

        GROUP BY FROM_UNIXTIME(n.timestamp, '%Y-%m')
    ) AS source
    GROUP BY created, count;
  field_kpi_data_formatter:
  -
    value: three_months_timeline_kpi_data_formatter
  field_kpi_visualization: morris_bar_graph_kpi_visualization
  field_kpi_chart_labels:
  -
    value: 'Views'
  field_kpi_chart_colors:
  -
    value: '#29abe2'
  body:
  -
    format: basic_html
    value: >
      Amount of views tracked for content across the community.