How to have access Associated_Products datas to build KPIs ?

How to have access Associated_Products datas to build KPIs ?

Hi, I want to set up a KPI on the 5 best-selling products over different timeframes (week, month, year). To do this, I have datas in the pipeline in the Associated_Products Object, including :
      - productId
      - Quantity
      - Total
      - Created_Time

Unless I'm mistaken, these KPIs are not available in the dashboard, which contains either deals datas or product datas. But any data from Associated_Products Object.

Am I wrong?




  1. "Deal_Name": "FC24-10",
                "Associated_Products": [
                    {
                        "Discount": 0,
                        "$in_merge": false,
                        "$field_states": null,
                        "Created_Time": "2024-01-07T10:52:11+01:00",
                        "Total": 43.5,
                        "Parent_Id": {
                            "name": "FC24-10",
                            "id": "6028338000000518110"
                        },
                        "Product": {
                            "name": "Graham Chemise Stretch Fond Blanc",
                            "id": "6028338000000513962"
                        },
                        "Quantity": 1,
                        "List_Price": 43.5,
                        "id": "6028338000000514724",
                        "$zia_visions": null
                    },
                    {
                        "Discount": 0,
                        "$in_merge": false,
                        "$field_states": null,
                        "Created_Time": "2024-01-07T10:53:31+01:00",
                        "Total": 87,
                        "Parent_Id": {
                            "name": "FC24-10",
                            "id": "6028338000000518110"
                        },
                        "Product": {
                            "name": "Graham Chemise Stretch Fond Blanc",
                            "id": "6028338000000513962"
                        },
                        "Quantity": 2,
                        "List_Price": 43.5,
                        "id": "6028338000000514731",
                        "$zia_visions": null
                    }