You are here

social_kpi_lite_node_views.yml in Open Social 8.4

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
View source
  1. values:
  2. type: kpi_analytics
  3. info: 'KPI Analytics: Node views'
  4. uuid: 9bf461b4-8ef9-4af4-bc84-a97a82f447d9
  5. fields:
  6. field_kpi_datasource: drupal_kpi_datasource
  7. field_kpi_query: >
  8. SELECT created, count FROM
  9. (
  10. SELECT
  11. FROM_UNIXTIME(n.timestamp, '%Y-%m') AS created,
  12. COUNT(n.nid) AS count
  13. FROM node_statistics n
  14. WHERE FROM_UNIXTIME(n.timestamp, '%Y-%m')
  15. BETWEEN
  16. FROM_UNIXTIME(UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 MONTH)), '%Y-%m')
  17. AND
  18. FROM_UNIXTIME(UNIX_TIMESTAMP(CURDATE()), '%Y-%m')
  19. GROUP BY FROM_UNIXTIME(n.timestamp, '%Y-%m')
  20. ) AS source
  21. GROUP BY created, count;
  22. field_kpi_data_formatter:
  23. -
  24. value: three_months_timeline_kpi_data_formatter
  25. field_kpi_visualization: morris_bar_graph_kpi_visualization
  26. field_kpi_chart_labels:
  27. -
  28. value: 'Views'
  29. field_kpi_chart_colors:
  30. -
  31. value: '#29abe2'
  32. body:
  33. -
  34. format: basic_html
  35. value: >
  36. Amount of views tracked for content across the community.