📊 Report : Analysis of completion rates by category, sub-categories and suppliers

In a nutshell

This job allows you to export a report of completion rates by category, sub-categories and suppliers.

📥 Download the latest version of this jobs.

⌛ Time to setup: 1 minute.

Result

• Each segment: Category/sub-categories/supplier
• Size of the segment: Total number of products within the category
• Color of the segment: Completion rate of attributs within the category

Quick Setup

1. Download the last version of this job, available here
2. Update the file job.json by replacing all elements below:

• TODO_TABLE_KEY: The table key (in export items and export table)
• TODO_ACCOUNT_NAME: Name of the current account
• TODO_CLASSIFICATION_KEY: The classification key of the classification that must be analysed
• TODO_SUPPLIER_KEY: The supplier key
• TODO_SCREEN_KEY: The screen key
• TODO_OUTPUT: output file name, best pratice: account_screen.html

{
  "schema": "1.0",
  "key": "rapport_analyse_de_completion_par_categorie",
  "title": "Rapport : Analyse de complétion par catégorie/fournisseur",
  "tasks": [
    {
      "name": "table-export-items",
      "taskReferenceName": "table_export_items",
      "description": "Export items",
      "optional": false,
      "type": "SUB_WORKFLOW",
      "inputParameters": {
        "tableKey": "TODO_TABLE_KEY",
        "mode": "ALL",
        "fileName": "items.xml"
      }
    },
    {
      "name": "table-export-schema",
      "taskReferenceName": "table_export_schema",
      "description": "Export table schema",
      "optional": false,
      "type": "SUB_WORKFLOW",
      "inputParameters": {
        "tableKey": "TODO_TABLE_KEY",
        "mode": "ACTIVE",
        "fileName": "table.xml"
      }
    },
    {
      "name": "file-transformation-xslt",
      "taskReferenceName": "file_transformation_xslt_metrics_xml",
      "description": "Generate metrics xml",
      "optional": false,
      "type": "SUB_WORKFLOW",
      "inputParameters": {
        "mode": "FILE",
        "file": "${table_export_schema.output.file}",
        "params": [
          {
            "name": "items_url",
            "select": "${table_export_items.output.file}"
          },
          {
            "name": "account",
            "select": "'TODO_ACCOUNT_NAME'"
          },
          {
            "name": "classification",
            "select": "'TODO_CLASSIFICATION_KEY'"
          },
          {
            "name": "supplier",
            "select": "'TODO_SUPPLIER_KEY'"
          },
          {
            "name": "screen",
            "select": "'TODO_SCREEN_KEY'"
          }
        ],
        "xslt": "file://assets/generate_xml_data.xslt",
        "fileName": "result.xml"
      }
    },
    {
      "name": "file-transformation-xslt",
      "taskReferenceName": "file_transformation_xslt_metrics_json",
      "description": "Transform in json",
      "optional": false,
      "type": "SUB_WORKFLOW",
      "inputParameters": {
        "mode": "FILE",
        "file": "${file_transformation_xslt_metrics_xml.output.file}",
        "xslt": "file://assets/xml_to_json.xslt",
        "fileName": "result.json"
      }
    },
    {
      "name": "file-transformation-xslt",
      "taskReferenceName": "file_transformation_xslt_html",
      "description": "Generate html report",
      "optional": false,
      "type": "SUB_WORKFLOW",
      "inputParameters": {
        "mode": "FILE",
        "file": "file://assets/empty.xml",
        "params": [
          {
            "name": "metrics_url",
            "select": "${file_transformation_xslt_metrics_json.output.file}"
          },
          {
            "name": "index_url",
            "select": "file://assets/index.html"
          }
        ],
        "xslt": "file://assets/html.xslt",
        "fileName": "TODO_OUTPUT.html"
      }
    }
  ]
}