📊 Report : Analysis of completion rates by suppliers

In a nutshell

This job allows you to export a report of completion rates by suppliers.

📥 Download the latest version of this jobs.

⌛ Time to setup: 1 minute.

Result

• Each column: Supplier
• Height of the column: Total number of products of the supplier
• Color of the segment: Completion rate of attributs of the supplier

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_SUPPLIER_KEY: The supplier key
• TODO_CLASSIFICATION_KEY: The classification key of the classification that must be analysed
• TODO_SCREEN_KEY: The screen key
• TODO_OUTPUT: output file name, best pratice: account_screen.html

{
  "schema": "1.0",
  "key": "rapport_:_analyse_du_taux_de_completion_par_fournisseur",
  "title": "Rapport : Analyse du taux de complétion par 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": "xslt_metrics_json",
      "description": "Generate metrics json",
      "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": "supplier",
            "select": "'TODO_SUPPLIER_KEY'"
          },
          {
            "name": "classification",
            "select": "'TODO_CLASSIFICATION_KEY'"
          },
          {
            "name": "screen",
            "select": "'TODO_SCREEN_KEY'"
          }
        ],
        "xslt": "file://assets/columns_generate_metrics.xslt",
        "fileName": "columns_metrics.xml"
      }
    },
    {
      "name": "file-transformation-xslt",
      "taskReferenceName": "xslt_columns_html",
      "description": "Generate html report columns",
      "optional": false,
      "type": "SUB_WORKFLOW",
      "inputParameters": {
        "mode": "FILE",
        "file": "file://assets/empty.xml",
        "params": [
          {
            "name": "metrics_url",
            "select": "${xslt_metrics_json.output.file}"
          },
          {
            "name": "index_url",
            "select": "file://assets/columns.html"
          }
        ],
        "xslt": "file://assets/columns_html.xslt",
        "fileName": "TODO_OUTPUT.html"
      }
    }
  ],
  "outputParameters": {
    "file": "${xslt_columns_html.output.file}"
  }
}