Elenco di Cubo

sitearea_footfallcounting_minute

Descrizione Memorizza il livello dei minuti contapersone dati
Nome cubo sitearea_footfallcounting_minute
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'minuto'.

minuto, ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. FC01_1_SOMMA
  2. FC01_1_MAX
  3. FC01_1_MIN
  4. FC01_1_AVG
  5. FC02_1_SOMMA
  6. FC02_1_MAX
  7. FC02_1_MIN
  8. FC02_1_AVG
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (stringa)
  3. NomeArea (stringa)
  4. BranchId (stringa)
  5. BranchCode (stringa)
  6. BranchName (stringa)
  7. CompanyId (stringa)
  8. CompanyName (stringa)
  9. isoperating (stringa)
  10. FC01_1 (int)
  11. FC02_1 (int)

sitearea_footfallcounting_hour

Descrizione Store livello orario contapersone dati
Nome cubo sitearea_footfallcounting_hour
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è "ora".

ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. FC01_1_SOMMA
  2. FC01_1_MAX
  3. FC01_1_MIN
  4. FC01_1_AVG
  5. FC02_1_SOMMA
  6. FC02_1_MAX
  7. FC02_1_MIN
  8. FC02_1_AVG
  9. FC03_1_SOMMA
  10. FC03_1_MAX
  11. FC03_1_MIN
  12. FC03_1_AVG
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (stringa)
  3. NomeArea (stringa)
  4. BranchId (stringa)
  5. BranchCode (stringa)
  6. BranchName (stringa)
  7. CompanyId (stringa)
  8. CompanyName (stringa)
  9. isoperating (stringa)
  10. FC01_1 (int)
  11. FC02_1 (int)
  12. FC03_1 (doppio)

sitegroup_footfallcounting_day

Descrizione Livello giornaliero del gruppo del sito contapersone dati
Nome cubo sitegroup_footfallcounting_day
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'giorno'.

giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. FC01_1_SOMMA
  2. FC01_1_MAX
  3. FC01_1_MIN
  4. FC01_1_AVG
  5. FC02_1_SOMMA
  6. FC02_1_MAX
  7. FC02_1_MIN
  8. FC02_1_AVG
  9. FC03_1_SOMMA
  10. FC03_1_MAX
  11. FC03_1_MIN
  12. FC03_1_AVG
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (stringa)
  3. NomeArea (stringa)
  4. BranchId (stringa)
  5. BranchCode (stringa)
  6. BranchName (stringa)
  7. SiteGroupId (stringa)
  8. NomeGruppoSito (stringa)
  9. CompanyId (stringa)
  10. CompanyName (stringa)
  11. isoperating (stringa)
  12. FC01_1 (int)
  13. FC02_1 (int)
  14. FC03_1 (doppio)

sitegroup_footfallcounting_hour

Descrizione Livello orario del gruppo del sito contapersone dati
Nome cubo sitegroup_footfallcounting_hour
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è "ora".

ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. FC01_1_SOMMA
  2. FC01_1_MAX
  3. FC01_1_MIN
  4. FC01_1_AVG
  5. FC02_1_SOMMA
  6. FC02_1_MAX
  7. FC02_1_MIN
  8. FC02_1_AVG
  9. FC03_1_SOMMA
  10. FC03_1_MAX
  11. FC03_1_MIN
  12. FC03_1_AVG
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (stringa)
  3. NomeArea (stringa)
  4. BranchId (stringa)
  5. BranchCode (stringa)
  6. BranchName (stringa)
  7. SiteGroupId (stringa)
  8. NomeGruppoSito (stringa)
  9. CompanyId (stringa)
  10. CompanyName (stringa)
  11. isoperating (stringa)
  12. FC01_1 (int)
  13. FC02_1 (int)
  14. FC03_1 (doppio)

site_footfallcounting_15minuti

Descrizione Memorizza il livello dei minuti del sito contapersone dati che sono aumentati fino a 15 minuti
Nome cubo site_footfallcounting_15minuti
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'minuto'.

minuto, ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. FC01_1_SOMMA
  2. FC02_1_SOMMA
  3. SO01_1_SOMMA
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. BranchId (stringa)
  3. BranchCode (stringa)
  4. BranchName (stringa)
  5. CompanyId (stringa)
  6. CompanyName (stringa)
  7. isoperating (stringa)
  8. IsSiteVerificato (corda)
  9. DataVerificataSito (datetime come stringa)
Corpo - Esempio JSON
{
    "interrogazione": {
        "le misure": [
            "site_footfallcounting_15minute.FC01_1_SUM",
            "site_footfallcounting_15minute.FC02_1_SUM",
            "site_footfallcounting_15minute.SO01_1_SUM"
        ],
        "dimensioni": [
            "site_footfallcounting_15minute.CompanyId",
            "site_footfallcounting_15minute.CompanyName",
            "site_footfallcounting_15minute.BranchId",
            "site_footfallcounting_15minute.BranchName"
        ],
        "filtri": [
            {
                "member": "site_footfallcounting_15minute.CompanyId",
                "operatore": "uguale",
                "i valori": [
                    "12345"
                ]
            },
            {
                "member": "site_footfallcounting_15minute.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            },
           {
                "member": "site_footfallcounting_15minute.isoperating",
                "operatore": "uguale",
                "i valori": [
                    "vero"
                ]
            },
           {
                "member": "site_footfallcounting_15minute.IsSiteVerificato",
                "operatore": "uguale",
                "i valori": [
                    "vero"
                ]
            }
        ],
        "timeDimensions": [
            {
                "dimension": "site_footfallcounting_15minute.Time",
                "intervallo di date": [
                    "2022-01-01T00:00:00.000",
                    "2022-01-02"
                ],
                "granularità": "minuto"
            }
        ],
        "ordine": [
            [
                "site_footfallcounting_15minute.BranchId",
                "asc"
            ],
            [
                "site_footfallcounting_15minute.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta - Esempio JSON
{
 
    ...
 
    "dati": [
        {
            "site_footfallcounting_15minute.CompanyId": "12345",
            "site_footfallcounting_15minute.CompanyName": "DemoCompany",
            "site_footfallcounting_15minute.BranchId": "22222",
            "site_footfallcounting_15minute.BranchName": "DemoBranch",
            "site_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000",
            "site_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000",
            "site_footfallcounting_15minute.FC01_1_SUM": 0,
            "site_footfallcounting_15minute.FC02_1_SUM": 0,
            "site_footfallcounting_15minute.SO01_1_SUM": 0
        },
        {
            "site_footfallcounting_15minute.CompanyId": "12345",
            "site_footfallcounting_15minute.CompanyName": "DemoCompany",
            "site_footfallcounting_15minute.BranchId": "22222",
            "site_footfallcounting_15minute.BranchName": "DemoBranch",
            "site_footfallcounting_15minute.Time.minute": "2022-01-01T09:00:00.000",
            "site_footfallcounting_15minute.Time": "2022-01-01T09:00:00.000",
            "site_footfallcounting_15minute.FC01_1_SUM": 5,
            "site_footfallcounting_15minute.FC02_1_SUM": 2,
            "site_footfallcounting_15minute.SO01_1_SUM": 1
        },
        {
            "site_footfallcounting_15minute.CompanyId": "12345",
            "site_footfallcounting_15minute.CompanyName": "DemoCompany",
            "site_footfallcounting_15minute.BranchId": "22222",
            "site_footfallcounting_15minute.BranchName": "DemoBranch",
            "site_footfallcounting_15minute.Time.minute": "2022-01-01T09:30:00.000",
            "site_footfallcounting_15minute.Time": "2022-01-01T09:30:00.000",
            "site_footfallcounting_15minute.FC01_1_SUM": 3,
            "site_footfallcounting_15minute.FC02_1_SUM": 4,
            "site_footfallcounting_15minute.SO01_1_SUM": 0
        }
    ],
 
    ...
 
}

site_footfallcounting_30minuti

Descrizione Memorizza il livello dei minuti del sito contapersone dati che sono aumentati fino a 30 minuti
Nome cubo site_footfallcounting_30minuti
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'minuto'.

minuto, ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. FC01_1_SOMMA
  2. FC02_1_SOMMA
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. BranchId (stringa)
  3. BranchCode (stringa)
  4. BranchName (stringa)
  5. CompanyId (stringa)
  6. CompanyName (stringa)
  7. isoperating (stringa)
Corpo - Esempio JSON
{
    "interrogazione": {
        "le misure": [
            "site_footfallcounting_30minute.FC01_1_SUM",
            "site_footfallcounting_30minute.FC02_1_SUM"
        ],
        "dimensioni": [
            "site_footfallcounting_30minute.CompanyId",
            "site_footfallcounting_30minute.CompanyName",
            "site_footfallcounting_30minute.BranchId",
            "site_footfallcounting_30minute.BranchName"
        ],
        "filtri": [
            {
                "member": "site_footfallcounting_30minute.CompanyId",
                "operatore": "uguale",
                "i valori": [
                    "12345"
                ]
            },
            {
                "member": "site_footfallcounting_30minute.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            },
            {
                "member": "site_footfallcounting_30minute.isoperating",
                "operatore": "uguale",
                "i valori": [
                    "vero"
                ]
            }
        ],
        "timeDimensions": [
            {
                "dimension": "site_footfallcounting_30minute.Time",
                "intervallo di date": [
                    "2022-01-01T00:00:00.000",
                    "2022-01-02"
                ],
                "granularità": "minuto"
            }
        ],
        "ordine": [
            [
                "site_footfallcounting_30minute.BranchId",
                "asc"
            ],
            [
                "site_footfallcounting_30minute.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta - Esempio JSON
{
 
    ...
 
    "dati": [
        {
            "site_footfallcounting_30minute.CompanyId": "12345",
            "site_footfallcounting_30minute.CompanyName": "DemoCompany",
            "site_footfallcounting_30minute.BranchId": "22222",
            "site_footfallcounting_30minute.BranchName": "DemoBranch",
            "site_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000",
            "site_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000",
            "site_footfallcounting_30minute.FC01_1_SUM": 0,
            "site_footfallcounting_30minute.FC02_1_SUM": 0
        },
        {
            "site_footfallcounting_30minute.CompanyId": "12345",
            "site_footfallcounting_30minute.CompanyName": "DemoCompany",
            "site_footfallcounting_30minute.BranchId": "22222",
            "site_footfallcounting_30minute.BranchName": "DemoBranch",
            "site_footfallcounting_30minute.Time.minute": "2022-01-01T09:00:00.000",
            "site_footfallcounting_30minute.Time": "2022-01-01T09:00:00.000",
            "site_footfallcounting_30minute.FC01_1_SUM": 5,
            "site_footfallcounting_30minute.FC02_1_SUM": 2
        },
        {
            "site_footfallcounting_30minute.CompanyId": "12345",
            "site_footfallcounting_30minute.CompanyName": "DemoCompany",
            "site_footfallcounting_30minute.BranchId": "22222",
            "site_footfallcounting_30minute.BranchName": "DemoBranch",
            "site_footfallcounting_30minute.Time.minute": "2022-01-01T09:30:00.000",
            "site_footfallcounting_30minute.Time": "2022-01-01T09:30:00.000",
            "site_footfallcounting_30minute.FC01_1_SUM": 3,
            "site_footfallcounting_30minute.FC02_1_SUM": 4
        }
    ],
 
    ...
 
}

area_footfallcounting_15minuti

Descrizione Livello minuto dell'area del negozio contapersone dati che sono aumentati fino a 15 minuti
Nome cubo area_footfallcounting_15minuti
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'minuto'.

minuto, ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. FC01_1_SOMMA
  2. FC02_1_SOMMA
  3. SO01_1_SOMMA
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (stringa)
  3. NomeArea (stringa)
  4. BranchId (stringa)
  5. BranchCode (stringa)
  6. BranchName (stringa)
  7. CompanyId (stringa)
  8. CompanyName (stringa)
  9. isoperating (stringa)
Corpo - Esempio JSON
{
    "interrogazione": {
        "le misure": [
            "area_footfallcounting_15minute.FC01_1_SUM",
            "area_footfallcounting_15minute.FC02_1_SUM", 
            "area_footfallcounting_15minute.SO01_1_SUM"
        ],
        "dimensioni": [
            "area_footfallcounting_15minute.CompanyId",
            "area_footfallcounting_15minute.CompanyName",
            "area_footfallcounting_15minute.BranchId",
            "area_footfallcounting_15minute.BranchName",
            "area_footfallcounting_15minute.AreaId",
            "area_footfallcounting_15minute.AreaName"
        ],
        "filtri": [
            {
                "member": "area_footfallcounting_15minute.CompanyId",
                "operatore": "uguale",
                "i valori": [
                    "12345"
                ]
            },
            {
                "member": "area_footfallcounting_15minute.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            },
           {
                "member": "area_footfallcounting_15minute.isoperating",
                "operatore": "uguale",
                "i valori": [
                    "vero"
                ]
            }
        ],
        "timeDimensions": [
            {
                "dimensione": "area_footfallcounting_15minute.Time",
                "intervallo di date": [
                    "2022-01-01T00:00:00.000",
                    "2022-01-02"
                ],
                "granularità": "minuto"
            }
        ],
        "ordine": [
            [
                "area_footfallcounting_15minute.BranchId",
                "asc"
            ],
            [
                "area_footfallcounting_15minute.AreaId",
                "asc"
            ],
            [
                "area_footfallcounting_15minute.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta - Esempio JSON
{
    ...
 
    "dati": [
        {
            "area_footfallcounting_15minute.CompanyId": "12345",
            "area_footfallcounting_15minute.CompanyName": "DemoCompany",
            "area_footfallcounting_15minute.BranchId": "22222",
            "area_footfallcounting_15minute.BranchName": "DemoBranch",
            "area_footfallcounting_15minute.AreaId": "-1",
            "area_footfallcounting_15minute.AreaName": null,
            "area_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000",
            "area_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000",
            "area_footfallcounting_15minute.FC01_1_SUM": 0,
            "area_footfallcounting_15minute.FC02_1_SUM": 0,
            "area_footfallcounting_15minute.SO01_1_SUM": 0
        },
        {
            "area_footfallcounting_15minute.CompanyId": "12345",
            "area_footfallcounting_15minute.CompanyName": "DemoCompany",
            "area_footfallcounting_15minute.BranchId": "22222",
            "area_footfallcounting_15minute.BranchName": "DemoBranch",
            "area_footfallcounting_15minute.AreaId": "10101",
            "area_footfallcounting_15minute.AreaName": "DemoArea1",
            "area_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000",
            "area_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000",
            "area_footfallcounting_15minute.FC01_1_SUM": 0,
            "area_footfallcounting_15minute.FC02_1_SUM": 0,
            "area_footfallcounting_15minute.SO01_1_SUM": 0
        },
        {
            "area_footfallcounting_15minute.CompanyId": "12345",
            "area_footfallcounting_15minute.CompanyName": "DemoCompany",
            "area_footfallcounting_15minute.BranchId": "22222",
            "area_footfallcounting_15minute.BranchName": "DemoBranch",
            "area_footfallcounting_15minute.AreaId": "20202",
            "area_footfallcounting_15minute.AreaName": "DemoArea2",
            "area_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000",
            "area_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000",
            "area_footfallcounting_15minute.FC01_1_SUM": 0,
            "area_footfallcounting_15minute.FC02_1_SUM": 0,
            "area_footfallcounting_15minute.SO01_1_SUM": 0
        }
    ],
 
    ...
 
}

area_footfallcounting_30minuti

Descrizione Livello minuto dell'area del negozio contapersone dati che sono aumentati fino a 30 minuti
Nome cubo area_footfallcounting_30minuti
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'minuto'.

minuto, ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. FC01_1_SOMMA
  2. FC02_1_SOMMA
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (stringa)
  3. NomeArea (stringa)
  4. BranchId (stringa)
  5. BranchCode (stringa)
  6. BranchName (stringa)
  7. CompanyId (stringa)
  8. CompanyName (stringa)
  9. isoperating (stringa)
Corpo - Esempio JSON
{
    "interrogazione": {
        "le misure": [
            "area_footfallcounting_30minute.FC01_1_SUM",
            "area_footfallcounting_30minute.FC02_1_SUM"
        ],
        "dimensioni": [
            "area_footfallcounting_30minute.CompanyId",
            "area_footfallcounting_30minute.CompanyName",
            "area_footfallcounting_30minute.BranchId",
            "area_footfallcounting_30minute.BranchName",
            "area_footfallcounting_30minute.AreaId",
            "area_footfallcounting_30minute.AreaName"
        ],
        "filtri": [
            {
                "member": "area_footfallcounting_30minute.CompanyId",
                "operatore": "uguale",
                "i valori": [
                    "12345"
                ]
            },
            {
                "member": "area_footfallcounting_30minute.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            },
           {
                "member": "area_footfallcounting_30minute.isoperating",
                "operatore": "uguale",
                "i valori": [
                    "vero"
                ]
            }
        ],
        "timeDimensions": [
            {
                "dimensione": "area_footfallcounting_30minute.Time",
                "intervallo di date": [
                    "2022-01-01T00:00:00.000",
                    "2022-01-02"
                ],
                "granularità": "minuto"
            }
        ],
        "ordine": [
            [
                "area_footfallcounting_30minute.BranchId",
                "asc"
            ],
            [
                "area_footfallcounting_30minute.AreaId",
                "asc"
            ],
            [
                "area_footfallcounting_30minute.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta - Esempio JSON
{
    ...
 
    "dati": [
        {
            "area_footfallcounting_30minute.CompanyId": "12345",
            "area_footfallcounting_30minute.CompanyName": "DemoCompany",
            "area_footfallcounting_30minute.BranchId": "22222",
            "area_footfallcounting_30minute.BranchName": "DemoBranch",
            "area_footfallcounting_30minute.AreaId": "-1",
            "area_footfallcounting_30minute.AreaName": null,
            "area_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000",
            "area_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000",
            "area_footfallcounting_30minute.FC01_1_SUM": 0,
            "area_footfallcounting_30minute.FC02_1_SUM": 0
        },
        {
            "area_footfallcounting_30minute.CompanyId": "12345",
            "area_footfallcounting_30minute.CompanyName": "DemoCompany",
            "area_footfallcounting_30minute.BranchId": "22222",
            "area_footfallcounting_30minute.BranchName": "DemoBranch",
            "area_footfallcounting_30minute.AreaId": "10101",
            "area_footfallcounting_30minute.AreaName": "DemoArea1",
            "area_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000",
            "area_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000",
            "area_footfallcounting_30minute.FC01_1_SUM": 0,
            "area_footfallcounting_30minute.FC02_1_SUM": 0
        },
        {
            "area_footfallcounting_30minute.CompanyId": "12345",
            "area_footfallcounting_30minute.CompanyName": "DemoCompany",
            "area_footfallcounting_30minute.BranchId": "22222",
            "area_footfallcounting_30minute.BranchName": "DemoBranch",
            "area_footfallcounting_30minute.AreaId": "20202",
            "area_footfallcounting_30minute.AreaName": "DemoArea2",
            "area_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000",
            "area_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000",
            "area_footfallcounting_30minute.FC01_1_SUM": 0,
            "area_footfallcounting_30minute.FC02_1_SUM": 0
        }
    ],
 
    ...
 
}

sitearea_footfallcounting_minute_accumulate

Descrizione Memorizza il livello dei minuti contapersone dati accumulati
Nome cubo sitearea_footfallcounting_minute_accumulate
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'minuto'.

minuto, ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. FC05_1_MAX
  2. FC05_1_MIN
  3. FC05_11_MAX
  4. FC05_11_MIN
  5. SO05_1_MAX
  6. SO05_1_MIN
  7. SO05_11_MAX
  8. SO05_11_MIN
  9. SO05_12_MAX
  10. SO05_12_MIN
  11. SO05_21_MAX
  12. SO05_21_MIN
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (stringa)
  3. NomeArea (stringa)
  4. BranchId (stringa)
  5. BranchCode (stringa)
  6. BranchName (stringa)
  7. CompanyId (stringa)
  8. CompanyName (stringa)
  9. FC05_1 (int)
  10. FC05_11 (int)
  11. SO05_1 (int)
  12. SO05_11 (int)
  13. SO05_12 (int)
  14. SO05_21 (int)
Corpo - Esempio JSON
{
    "interrogazione": {
        "le misure": [
            "sitearea_footfallcounting_minute_accumulate.SO05_1_MAX"
        ],
        "dimensioni": [
            "sitearea_footfallcounting_minute_accumulate.CompanyId",
            "sitearea_footfallcounting_minute_accumulate.CompanyName",
            "sitearea_footfallcounting_minute_accumulate.BranchId",
            "sitearea_footfallcounting_minute_accumulate.BranchName",
            "sitearea_footfallcounting_minute_accumulate.AreaId",
            "sitearea_footfallcounting_minute_accumulate.AreaName"
        ],
        "filtri": [
            {
                "member": "sitearea_footfallcounting_minute_accumulate.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "12345"
                ]
            },
            {
                "member": "sitearea_footfallcounting_minute_accumulate.AreaId",
                "operatore": "uguale",
                "i valori": [
                    "1111"
                ]
            }
        ],
        "timeDimensions": [
            {
                "dimension": "sitearea_footfallcounting_minute_accumulate.Time",
                "intervallo di date": [
                    "2022-02-01T00:00:00.000",
                    "2022-02-02"
                ],
                "granularità": "minuto"
            }
        ],
        "ordine": [
            [
                "sitearea_footfallcounting_minute_accumulate.Time",
                "discesa"
            ]
        ],
        "limite": 1
    }
}
Risposta - Esempio JSON
{
 
    ...
 
    "dati": [
        {
            "sitearea_footfallcounting_minute_accumulate.CompanyId": "10101",
            "sitearea_footfallcounting_minute_accumulate.CompanyName": "DemoCompany",
            "sitearea_footfallcounting_minute_accumulate.BranchId": "12345",
            "sitearea_footfallcounting_minute_accumulate.BranchName": "DemoBranch",
            "sitearea_footfallcounting_minute_accumulate.AreaId": "1111",
            "sitearea_footfallcounting_minute_accumulate.AreaName": "DemoArea",
            "sitearea_footfallcounting_minute_accumulate.Time.minute": "2022-02-01T23:50:00.000",
            "sitearea_footfallcounting_minute_accumulate.Time": "2022-02-01T23:50:00.000",
            "sitearea_footfallcounting_minute_accumulate.SO05_1_MAX": 84
        }
    ],
 
    ...
 
}

sitearea_buscounting_minute

Descrizione Memorizza i dati di conteggio del bus a livello di minuto del sito e dell'area
Nome cubo sitearea_buscounting_minute
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'minuto'.

minuto, ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. FC01_1_SOMMA
  2. FC01_1_MAX
  3. FC01_1_MIN
  4. FC01_1_AVG
  5. FC02_1_SOMMA
  6. FC02_1_MAX
  7. FC02_1_MIN
  8. FC02_1_AVG
  9. SO01_1_SOMMA
  10. SO01_1_MAX
  11. SO01_1_MIN
  12. SO01_1_MEDIA
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. Ora di inizio programmata (datetime come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  3. Data e ora di arrivo effettive (datetime come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  4. ID zona (corda)
  5. NomeArea (corda)
  6. BranchId (stringa)
  7. BranchCode (stringa)
  8. BranchName (stringa)
  9. CompanyId (stringa)
  10. CompanyName (stringa)
  11. FC01_1 (int)
  12. FC02_1 (int)
  13. SO01_1 (int)
Corpo - Esempio JSON {
        "richiesta": {
        "le misure": [
            "sitearea_buscounting_minute.FC01_1_SUM",
            "sitearea_buscounting_minute.FC02_1_SUM",
            "sitearea_buscounting_minute.SO01_1_SUM"
        ],
        "dimensioni": [
            "sitearea_buscounting_minute.TripId",
            "sitearea_buscounting_minute.ScheduledStartTime",
            "sitearea_buscounting_minute.Time",
            "sitearea_buscounting_minute.ActualArrivalDateTime",
            "sitearea_buscounting_minute.CompanyId",
            "sitearea_buscounting_minute.CompanyName",
            "sitearea_buscounting_minute.BranchId",
            "sitearea_buscounting_minute.BranchName",
            "sitearea_buscounting_minute.AreaId",
            "sitearea_buscounting_minute.AreaName"
        ],
        "timeDimensions": [
            {
                "dimensione": "sitearea_buscounting_minute.Time",
                "intervallo di date": [
                    "2022-03-10T00:00:00.000",
                    "2022-03-11"
                ],
                "granularità": "minuto"
            }
        ],
    "filtri": [
            {
                "member": "sitearea_buscounting_minute.CompanyId",
                "operatore": "uguale",
                "i valori": [
                    "12345"
                ]
            },
            {
                "member": "sitearea_buscounting_minute.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            },
            {
                "member": "sitearea_buscounting_minute.AreaId",
                "operatore": "uguale",
                "i valori": [
                    "1101/XNUMX",
                    "2202"
                ]
            },
            {
                "member": "sitearea_buscounting_minute.AreaName",
                "operatore": "uguale",
                "i valori": [
                    "Area1",
                    "Area2"
                ]
            }
        ],
        "ordine": [
            [
                 "sitearea_buscounting_minute.TripId",
                 "asc"
            ],
            [
                 "sitearea_buscounting_minute.AreaId",
                 "asc"
            ],
            [
                 "sitearea_buscounting_minute.ScheduledStartTime",
                 "asc"
            ]
        ]
    }
}
Risposta - Esempio JSON
{
 
    ...
 
    "dati": [
        {
            "sitearea_buscounting_minute.TripId": "D5975107-F39E-49BC-A975-4016011EA0E7",
            "sitearea_buscounting_minute.StationId": "61025D6D-94A9-4DDE-AE23-BAD5D93BCC03",
            "sitearea_buscounting_minute.ScheduledStartTime": "2022-03-10T18:12:00.000",
            "sitearea_buscounting_minute.Time": "2022-03-10T18:18:46.000",
            "sitearea_buscounting_minute.ActualArrivalDateTime": "2022-03-10T18:18:46.000",
            "sitearea_buscounting_minute.CompanyId": 12345,
            "sitearea_buscounting_minute.CompanyName": "Company1",
            "sitearea_buscounting_minute.BranchId": 11111,
            "sitearea_buscounting_minute.BranchName": "Branch1",
            "sitearea_buscounting_minute.AreaId": 1101,
            "sitearea_buscounting_minute.AreaName": "Area1",
            "sitearea_buscounting_minute.Time.minute": "2022-03-10T18:18:00.000",
            "sitearea_buscounting_minute.FC01_1_SUM": 8,
            "sitearea_buscounting_minute.FC02_1_SUM": 6,
            "sitearea_buscounting_minute.SO01_1_SUM": 2
        },
        {
            "sitearea_buscounting_minute.TripId": "D5975107-F39E-49BC-A975-4016011EA0E7",
            "sitearea_buscounting_minute.StationId": "2D931974-2423-457C-B057-92BD31B5E9FF",
            "sitearea_buscounting_minute.ScheduledStartTime": "2022-03-10T18:14:00.000",
            "sitearea_buscounting_minute.Time": "2022-03-10T18:21:10.000",
            "sitearea_buscounting_minute.ActualArrivalDateTime": "2022-03-10T18:21:10.000",
            "sitearea_buscounting_minute.CompanyId": 12345,
            "sitearea_buscounting_minute.CompanyName": "Company1",
            "sitearea_buscounting_minute.BranchId": 11111,
            "sitearea_buscounting_minute.BranchName": "Branch1",
            "sitearea_buscounting_minute.AreaId": 1101,
            "sitearea_buscounting_minute.AreaName": "Area1",
            "sitearea_buscounting_minute.Time.minute": "2022-03-10T18:21:00.000",
            "sitearea_buscounting_minute.FC01_1_SUM": 0,
            "sitearea_buscounting_minute.FC02_1_SUM": 0,
            "sitearea_buscounting_minute.SO01_1_SUM": 2
        },
        {
            "sitearea_buscounting_minute.TripId": "D5975107-F39E-49BC-A975-4016011EA0E7",
            "sitearea_buscounting_minute.StationId": "E24E9D16-D6D9-432D-ABC8-A9D71C1A4FB1",
            "sitearea_buscounting_minute.ScheduledStartTime": "2022-03-10T18:15:00.000",
            "sitearea_buscounting_minute.Time": "2022-03-10T18:22:02.000",
            "sitearea_buscounting_minute.ActualArrivalDateTime": "2022-03-10T18:22:02.000",
            "sitearea_buscounting_minute.CompanyId": 12345,
            "sitearea_buscounting_minute.CompanyName": "Company1",
            "sitearea_buscounting_minute.BranchId": 11111,
            "sitearea_buscounting_minute.BranchName": "Branch1",
            "sitearea_buscounting_minute.AreaId": 1101,
            "sitearea_buscounting_minute.AreaName": "Area1",
            "sitearea_buscounting_minute.Time.minute": "2022-03-10T18:22:00.000",
            "sitearea_buscounting_minute.FC01_1_SUM": 3,
            "sitearea_buscounting_minute.FC02_1_SUM": 0,
            "sitearea_buscounting_minute.SO01_1_SUM": 5
        }
    ],
 
    ...
 
}

site_area_1d_joined_data

Descrizione Dati del sito e dell'area con metriche diverse
Nome cubo
site_area_1d_joined_data
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'giorno'.

giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. PFC01_11
  2. PFC02_11
  3. PFC01_3011
  4. PFC01_5011
  5. PFC27
  6. SWA04
  7. SWA05
  8. SWA06
  9. SWA07
  10. PWA01
  11. SWA02
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. OperateDate (dataora come stringa)
  3. AreaId (stringa)
  4. NomeArea (stringa)
  5. BranchId (stringa)
  6. BranchName (stringa)
  7. BranchCode (stringa)
  8. CompanyId (stringa)
  9. CompanyName (stringa)
  10. AreaGroupId (stringa)
  11. AreaGroupName (stringa)
  12. SiteGroupId (stringa)
  13. SiteGroupdName (stringa)
Settori

Segmenti disponibili per filtrare i dati:

  1. IsAreaLevel: utilizzare questo segmento per eseguire query sui dati a livello di area
  2. IsSiteLevel: utilizzare questo segmento per eseguire query sui dati a livello di sito

*L'esecuzione di query sui dati a livello di sito senza utilizzare IsSiteLevel può causare la restituzione di dati errati.

Corpo - Esempio JSON
{
    "richiesta": {
        "le misure": [
            "site_area_1d_joined_data.PFC01_11",
            "site_area_1d_joined_data.PWA01",
            "site_area_1d_joined_data.SWA02",
            "site_area_1d_joined_data.PFC27",
            "site_area_1d_joined_data.SWA04",
            "site_area_1d_joined_data.SWA06"
        ],
        "dimensioni": [
            "site_area_1d_joined_data.CompanyId",
            "site_area_1d_joined_data.NomeAzienda",
            "site_area_1d_joined_data.BranchId",
            "site_area_1d_joined_data.BranchName",
            "site_area_1d_joined_data.Time"
        ],
        "filtri": [
            {
                "membro": "site_area_1d_joined_data.BranchId",
                "operatore": "uguale",
                "valori": [
                    "1"
                ]
            }
        ],
        "timeDimensions": [
            {
                "dimensione": "site_area_1d_joined_data.Time",
                "intervallo di date": [
                    "2024-01-19T00:00:00.000000",
                    "2024-01-20T23:59:59.000000"
                ],
                "granularità": "giorno"
            }
        ],
        "segmenti": [
           "site_area_1d_joined_data.IsSiteLevel"
        ],
        "ordine": {
            "site_area_1d_joined_data.Time": "asc"
        }
    }
}
Risposta - Esempio JSON
{
 
    ...
 
 
"dati":
[
        {
            "site_area_1d_joined_data.CompanyId": 1,
            "site_area_1d_joined_data.CompanyName": "Società demo",
            "site_area_1d_joined_data.BranchId": 1,
            "site_area_1d_joined_data.BranchName": "Centro commerciale",
            "site_area_1d_joined_data.Time": "2024-01-19T00:00:00.000",
            "site_area_1d_joined_data.Time.day": "2024-01-19T00:00:00.000",
            "site_area_1d_joined_data.PFC01_11": 4958,
            "site_area_1d_joined_data.PWA01": 6060,
            "site_area_1d_joined_data.SWA02": 0.45,
            "site_area_1d_joined_data.PFC27": 1234.56,
            "site_area_1d_joined_data.SWA04": 0.66,
            "site_area_1d_joined_data.SWA06": 0.34
        },
        {
            "site_area_1d_joined_data.CompanyId": 1,
            "site_area_1d_joined_data.CompanyName": "Società demo",
            "site_area_1d_joined_data.BranchId": 1,
            "site_area_1d_joined_data.BranchName": "Centro commerciale",
            "site_area_1d_joined_data.Time": "2024-01-20T00:00:00.000",
            "site_area_1d_joined_data.Time.day": "2024-01-20T00:00:00.000",
            "site_area_1d_joined_data.PFC01_11": 4929,
            "site_area_1d_joined_data.PWA01": 7070,
            "site_area_1d_joined_data.SWA02": 0.41,
            "site_area_1d_joined_data.PFC27": 706.61,
            "site_area_1d_joined_data.SWA04": 0.21,
            "site_area_1d_joined_data.SWA06": 0.79
        }
  ],
 
    ...
 
}

site_area_1h_joined_data

Descrizione Dati del sito e dell'area con metriche diverse
Nome cubo
site_area_1h_joined_data
Granularità temporali

La granularità temporale per questo cubo è "ora". Utilizza site_area_1d_joined_data per granularità temporali più ampie.

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. PFC01_11
  2. PFC02_11
  3. PFC01_3011
  4. PFC01_5011
  5. PFC27
  6. PWA01
  7. SWA02
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. OperateDate (dataora come stringa)
  3. AreaId (stringa)
  4. NomeArea (stringa)
  5. BranchId (stringa)
  6. BranchName (stringa)
  7. BranchCode (stringa)
  8. CompanyId (stringa)
  9. CompanyName (stringa)
  10. AreaGroupId (stringa)
  11. AreaGroupName (stringa)
  12. SiteGroupId (stringa)
  13. SiteGroupdName (stringa)
Settori

Segmenti disponibili per filtrare i dati:

  1. IsAreaLevel: utilizzare questo segmento per eseguire query sui dati a livello di area
  2. IsSiteLevel: utilizzare questo segmento per eseguire query sui dati a livello di sito

*L'esecuzione di query sui dati a livello di sito senza utilizzare IsSiteLevel può causare la restituzione di dati errati.

Corpo - Esempio JSON
{
    "richiesta": {
        "le misure": [
            "site_area_1h_joined_data.PFC01_11",
            "site_area_1h_joined_data.PWA01",
            "site_area_1h_joined_data.SWA02",
            "area_sito_1h_dati_uniti.PFC27"
        ],
        "dimensioni": [
            "site_area_1h_joined_data.CompanyId",
            "site_area_1h_joined_data.NomeAzienda",
            "site_area_1h_joined_data.BranchId",
            "site_area_1h_joined_data.BranchName",
            "site_area_1h_joined_data.Time"
        ],
        "filtri": [
            {
                "membro": "site_area_1h_joined_data.BranchId",
                "operatore": "uguale",
                "valori": [
                    "25610"
                ]
            }
        ],
        "timeDimensions": [
            {
                "dimension": "site_area_1h_joined_data.Time",
                "intervallo di date": [
                    "2024-01-19T10:00:00.000000",
                    "2024-01-19T13:59:59.000000"
                ],
                "granularità": "ora"
            }
        ],
        "segmenti": [
           "site_area_1h_joined_data.IsSiteLevel"
        ],
        "ordine": {
            "site_area_1h_joined_data.Time": "asc"
        }
    }
}
Risposta - Esempio JSON
{
 
    ...
 
 
"dati":
[
        {
            "site_area_1h_joined_data.CompanyId": 1,
            "site_area_1h_joined_data.CompanyName": "Società demo",
            "site_area_1h_joined_data.BranchId": 1,
            "site_area_1h_joined_data.BranchName": "Centro commerciale",
            "site_area_1h_joined_data.Time": "2024-01-19T10:00:00.000",
            "site_area_1h_joined_data.Time.hour": "2024-01-19T10:00:00.000",
            "site_area_1h_joined_data.PFC01_11": 325,
            "site_area_1h_joined_data.PWA01": 101,
            "site_area_1h_joined_data.SWA02": 0.76,
            "site_area_1h_joined_data.PFC27": 310.20
        },
        {
            "site_area_1h_joined_data.CompanyId": 18330,
            "site_area_1h_joined_data.CompanyName": "Società demo",
            "site_area_1h_joined_data.BranchId": 25610,
            "site_area_1h_joined_data.BranchName": "Centro commerciale",
            "site_area_1h_joined_data.Time": "2024-01-19T11:00:00.000",
            "site_area_1h_joined_data.Time.hour": "2024-01-19T11:00:00.000",
            "site_area_1h_joined_data.PFC01_11": 440,
            "site_area_1h_joined_data.PWA01": 202,
            "site_area_1h_joined_data.SWA02": 0.69,
            "site_area_1h_joined_data.PFC27": 322.21
        },
        ...
    ],
 
    ...
 
}

sito_area_occupazione_dati

Descrizione Memorizza i dati sull'occupazione del sito e dell'area (senso dello spazio).
Nome cubo sito_area_occupazione_dati
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'secondo'.

secondo, minuto, ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. PSO05_MIN
  2. PSO05_MAX
  3. PSO05_AVG
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (numero)
  3. NomeArea (stringa)
  4. BranchId (numero)
  5. BranchCode (stringa)
  6. BranchName (stringa)
  7. CompanyId (numero)
  8. CompanyName (stringa)
Corpo - Esempio JSON
{
    "interrogazione": {
        "le misure": [
            "site_area_occupancy_data.PSO05_MIN",
            "site_area_occupancy_data.PSO05_MAX",
            "site_area_occupancy_data.PSO05_AVG"
        ],
        "dimensioni": [
          "site_area_occupancy_data.CompanyId",
          "site_area_occupancy_data.CompanyName",
          "site_area_occupancy_data.BranchId",
          "site_area_occupancy_data.BranchName",
          "site_area_occupancy_data.AreaId",
          "site_area_occupancy_data.AreaName"
        ],
        "filtri": [
            {
                "member": "site_area_occupancy_data.CompanyId",
                "operatore": "uguale",
                "i valori": [
                    "12345"
                ]
            },
            {
                "member": "site_area_occupancy_data.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            },
            {
                "member": "site_area_occupancy_data.AreaId",
                "operatore": "uguale",
                "i valori": [
                    "33333"
                ]
            }
        ],
        "timeDimensions": [
            {
                "dimension": "site_area_occupancy_data.Time",
                "intervallo di date": [
                    "2022-01-01T00:00:00.000",
                    "2022-01-02"
                ],
                "granularità": "minuto"
            }
        ],
        "ordine": [
            [
                "site_area_occupancy_data.BranchId",
                "asc"
            ],
            [
                "site_area_occupancy_data.Ora",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta - Esempio JSON
{


    ...


    "dati": [
        {
            "site_area_occupancy_data.CompanyId": "12345",
            "site_area_occupancy_data.CompanyName": "Azienda dimostrativa",
            "site_area_occupancy_data.BranchId": "22222",
            "site_area_occupancy_data.BranchName": "DemoBranch",
            "site_area_occupancy_data.AreaId": "33333",
            "site_area_occupancy_data.AreaName": "Area dimostrativa",
            "site_area_occupancy_data.Time.minute": "2022-01-01T00:00:00.000",
            "site_area_occupancy_data.Time": "2022-01-01T00:00:00.000",
            "site_area_occupancy_data.PSO05_MIN": 1,
            "site_area_occupancy_data.PSO05_MAX": 1,
            "site_area_occupancy_data.PSO05_AVG": 1
        },
        {
            "site_area_occupancy_data.CompanyId": "12345",
            "site_area_occupancy_data.CompanyName": "Azienda dimostrativa",
            "site_area_occupancy_data.BranchId": "22222",
            "site_area_occupancy_data.BranchName": "DemoBranch",
            "site_area_occupancy_data.AreaId": "33333",
            "site_area_occupancy_data.AreaName": "Area dimostrativa",
            "site_area_occupancy_data.Time.minute": "2022-01-01T09:27:00.000",
            "site_area_occupancy_data.Time": "2022-01-01T09:27:00.000",
            "site_area_occupancy_data.PSO05_MIN": 0,
            "site_area_occupancy_data.PSO05_MAX": 1,
            "site_area_occupancy_data.PSO05_AVG": 0.6666666666666666
        },
        {
            "site_area_occupancy_data.CompanyId": "12345",
            "site_area_occupancy_data.CompanyName": "Azienda dimostrativa",
            "site_area_occupancy_data.BranchId": "22222",
            "site_area_occupancy_data.BranchName": "DemoBranch",
            "site_area_occupancy_data.AreaId": "33333",
            "site_area_occupancy_data.AreaName": "Area dimostrativa",
            "site_area_occupancy_data.Time.minute": "2022-01-01T09:30:00.000",
            "site_area_occupancy_data.Time": "2022-01-01T09:30:00.000",
            "site_area_occupancy_data.PSO05_MIN": 0,
            "site_area_occupancy_data.PSO05_MAX": 2,
            "site_area_occupancy_data.PSO05_AVG": 1.2
        }
    ],


    ...


}

area_aggregate_occupancy_data_15m

Descrizione Memorizza i dati sull'occupazione del sito e dell'area (in out).
Nome cubo area_aggregate_occupancy_data_15m
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo. La granularità temporale minima è 15 minuti (continua a utilizzare "minuto" come valore per il parametro di granularità per l'API).

minuto, ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. PSO05_MIN
  2. PSO05_MAX
  3. PSO05_AVG
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (numero)
  3. NomeArea (stringa)
  4. BranchId (numero)
  5. BranchName (stringa)
  6. CompanyId (numero)
Corpo - Esempio JSON
{
    "interrogazione":
    {
        "le misure": [
            "area_aggregate_occupancy_data_15m.PSO05_MIN",
            "area_aggregate_occupancy_data_15m.PSO05_MAX",
            "area_aggregate_occupancy_data_15m.PSO05_AVG"
        ],
        "dimensioni": [
            "area_aggregate_occupancy_data_15m.CompanyId",
            "area_aggregate_occupancy_data_15m.NomeAzienda",
            "area_aggregate_occupancy_data_15m.BranchId",
            "area_aggregate_occupancy_data_15m.NomeDiramazione",
            "area_aggregate_occupancy_data_15m.AreaId",
            "area_aggregate_occupancy_data_15m.AreaName"
        ],
        "filtri": [
            {
                "membro": "area_aggregate_occupancy_data_15m.AreaId",
                "operatore": "uguale",
                "valori": [
                    "333333"
                ]
            }
        ],
        "timeDimensions": [
            {
                "dimension": "area_aggregate_occupancy_data_15m.Time",
                "intervallo di date": [
                    "2024-01-01T00:00:00.000",
                    "2024-01-02"
                ],
                "granularità": "minuto"
            }
        ],
        "ordine": [
            [
                "area_aggregate_occupancy_data_15m.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta - Esempio JSON
{


    ...


    "dati": [
        {
            "site_area_occupancy_data.CompanyId": "12345",
            "site_area_occupancy_data.CompanyName": "Azienda dimostrativa",
            "site_area_occupancy_data.BranchId": "22222",
            "site_area_occupancy_data.BranchName": "DemoBranch",
            "site_area_occupancy_data.AreaId": "33333",
            "site_area_occupancy_data.AreaName": "Area dimostrativa",
            "site_area_occupancy_data.Time.minute": "2022-01-01T00:00:00.000",
            "site_area_occupancy_data.Time": "2022-01-01T00:00:00.000",
            "site_area_occupancy_data.PSO05_MIN": 1,
            "site_area_occupancy_data.PSO05_MAX": 1,
            "site_area_occupancy_data.PSO05_AVG": 1
        },
        {
            "site_area_occupancy_data.CompanyId": "12345",
            "site_area_occupancy_data.CompanyName": "Azienda dimostrativa",
            "site_area_occupancy_data.BranchId": "22222",
            "site_area_occupancy_data.BranchName": "DemoBranch",
            "site_area_occupancy_data.AreaId": "33333",
            "site_area_occupancy_data.AreaName": "Area dimostrativa",
            "site_area_occupancy_data.Time.minute": "2022-01-01T00:15:00.000",
            "site_area_occupancy_data.Time": "2022-01-01T00:15:00.000",
            "site_area_occupancy_data.PSO05_MIN": 0,
            "site_area_occupancy_data.PSO05_MAX": 1,
            "site_area_occupancy_data.PSO05_AVG": 0.6666666666666666
        },
        {
            "site_area_occupancy_data.CompanyId": "12345",
            "site_area_occupancy_data.CompanyName": "Azienda dimostrativa",
            "site_area_occupancy_data.BranchId": "22222",
            "site_area_occupancy_data.BranchName": "DemoBranch",
            "site_area_occupancy_data.AreaId": "33333",
            "site_area_occupancy_data.AreaName": "Area dimostrativa",
            "site_area_occupancy_data.Time.minute": "2022-01-01T00:15:00.000",
            "site_area_occupancy_data.Time": "2022-01-01T00:15:00.000",
            "site_area_occupancy_data.PSO05_MIN": 0,
            "site_area_occupancy_data.PSO05_MAX": 2,
            "site_area_occupancy_data.PSO05_AVG": 1.2
        }
    ],


    ...


}

site_area_1h_queue_counting

Descrizione Memorizza i dati sul conteggio delle code del sito e dell'area
Nome cubo
site_area_1h_queue_counting
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è "ora".

ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo, fare riferimento Definizione delle metriche per i dettagli metrici

  1. PQM01_MIN
  2. PQM01_MAX
  3. PQM01_MEDIA
  4. PQM01_SOMMA
  5. PQM03_MIN
  6. PQM03_MAX
  7. PQM03_MEDIA
  8. PQM03_SOMMA
  9. PQM04_MIN
  10. PQM04_MAX
  11. PQM04_MEDIA
  12. PQM04_SOMMA
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (numero)
  3. NomeArea (stringa)
  4. BranchId (numero)
  5. BranchCode (stringa)
  6. BranchName (stringa)
  7. CompanyId (numero)
  8. CompanyName (stringa)
Corpo - Esempio JSON
{
     "richiesta": {
     
      "le misure": [
            "site_area_1h_queue_counting.PQM01_MIN",
            "site_area_1h_queue_counting.PQM01_MAX",
            "site_area_1h_queue_counting.PQM01_AVG",
            "site_area_1h_queue_counting.PQM01_SUM",
            "site_area_1h_queue_counting.PQM03_MIN",
            "site_area_1h_queue_counting.PQM03_MAX",
            "site_area_1h_queue_counting.PQM03_AVG",
            "site_area_1h_queue_counting.PQM03_SUM",
            "site_area_1h_queue_counting.PQM04_MIN",
            "site_area_1h_queue_counting.PQM04_MAX",
            "site_area_1h_queue_counting.PQM04_AVG",
            "site_area_1h_queue_counting.PQM04_SUM"
        ],
        "dimensioni": [
            "site_area_1h_queue_counting.CompanyId",
            "site_area_1h_queue_counting.CompanyName",
            "site_area_1h_queue_counting.BranchId",
            "site_area_1h_queue_counting.BranchName",
            "site_area_1h_queue_counting.BranchCode",
            "site_area_1h_queue_counting.AreaId",
            "site_area_1h_queue_counting.AreaName",
            "site_area_1h_queue_counting.IsOperating",
            "site_area_1h_queue_counting.Time"
        ],
        "filtri": [
            {
                "member": "site_area_1h_queue_counting.CompanyId",
                "operatore": "uguale",
                "i valori": [
                    "12345"
                ]
            },
            {
                "member": "site_area_1h_queue_counting.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            },
            {
                "member": "site_area_1h_queue_counting.AreaId",
                "operatore": "uguale",
                "i valori": [
                    "33333"
                ]
            }
        ],
        "timeDimensions": [
            {
                "dimension": "site_area_1h_queue_counting.Time",
                "intervallo di date": [
                    "2023-01-01T00:00:00.000",
                    "2023-01-02"
                ],
                "granularità": "minuto"
            }
        ],
        "ordine": [
            [
                "site_area_1h_queue_counting.BranchId",
                "asc"
            ],
            [
                "site_area_1h_queue_counting.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta - Esempio JSON
{


    ...


 
"dati": [
             
                {
                    "site_area_1h_queue_counting.CompanyId": 12345,
                    "site_area_1h_queue_counting.CompanyName": "Azienda dimostrativa",
                    "site_area_1h_queue_counting.BranchId": 22222,
                    "site_area_1h_queue_counting.BranchName": "DemoBranch",
                    "site_area_1h_queue_counting.BranchCode": "demo",
                    "site_area_1h_queue_counting.AreaId": 33333,
                    "site_area_1h_queue_counting.AreaName": "DemoArea",
                    "site_area_1h_queue_counting.IsOperating": 0,
                    "site_area_1h_queue_counting.Time": "2023-01-01T00:00:00.000",
                    "site_area_1h_queue_counting.PQM01_MIN": 6,
                    "site_area_1h_queue_counting.PQM01_MAX": 23,
                    "site_area_1h_queue_counting.PQM01_AVG": 19.3312,
                    "site_area_1h_queue_counting.PQM01_SUM": 23,
                    "site_area_1h_queue_counting.PQM03_MIN": 2,
                    "site_area_1h_queue_counting.PQM03_MAX": 23,
                    "site_area_1h_queue_counting.PQM03_AVG": 11.3434,
                    "site_area_1h_queue_counting.PQM03_SUM": 29,
                    "site_area_1h_queue_counting.PQM04_MIN": 2,
                    "site_area_1h_queue_counting.PQM04_MAX": 12,
                    "site_area_1h_queue_counting.PQM04_AVG": 11.2222,
                    "site_area_1h_queue_counting.PQM04_SUM": 12333
                },
                {
                 
                    "site_area_1h_queue_counting.CompanyId": 12345,
                    "site_area_1h_queue_counting.CompanyName": "Azienda dimostrativa",
                    "site_area_1h_queue_counting.BranchId": 22222,
                    "site_area_1h_queue_counting.BranchName": "DemoBranch",
                    "site_area_1h_queue_counting.BranchCode": "demo",
                    "site_area_1h_queue_counting.AreaId": 33333,
                    "site_area_1h_queue_counting.AreaName": "DemoArea",
                    "site_area_1h_queue_counting.IsOperating": 1,
                    "site_area_1h_queue_counting.Time": "2023-01-01T00:00:00.000",
                     "site_area_1h_queue_counting.PQM01_MIN": 0,
                    "site_area_1h_queue_counting.PQM01_MAX": 12,
                    "site_area_1h_queue_counting.PQM01_AVG": 14.433,
                    "site_area_1h_queue_counting.PQM01_SUM": 234,
                    "site_area_1h_queue_counting.PQM03_MIN": 1,
                    "site_area_1h_queue_counting.PQM03_MAX": 212,
                    "site_area_1h_queue_counting.PQM03_AVG": 12.3445,
                    "site_area_1h_queue_counting.PQM03_SUM": 123,
                    "site_area_1h_queue_counting.PQM04_MIN": 3,
                    "site_area_1h_queue_counting.PQM04_MAX": 33,
                    "site_area_1h_queue_counting.PQM04_AVG": 123,
                    "site_area_1h_queue_counting.PQM04_SUM": 1234
                }
    ],


    ...


}

site_area_1h_dati_demografici

Descrizione Memorizza i dati demografici del sito e dell'area
Nome cubo
site_area_1h_dati_demografici
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è "ora".

ora, giorno, settimana, mese, anno

Misure
  1. Sesso_Maschio_SUM
  2. Sesso_Femmina_SOMMA
  3. Emozione_Arrabbiata_SUM
  4. Emozione_Disprezzo_SOMMA
  5. Emozione_Disgusto_SOMMA
  6. Emozione_Paura_SOMMA
  7. Emozione_Triste_SOMMA
  8. Emozione_Neutro_SOMMA
  9. Emozione_Felice_SOMMA
  10. Emozione_Sorpreso_SOMMA
  11. Bambini_Età
  12. Adolescenti_Età
  13. Giovani_Adulti_Età
  14. Mezza_Età_Adulti_Età
  15. Anziani_Age
  16. Bambini_E_Adulti_Età
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (numero)
  3. NomeArea (stringa)
  4. BranchId (numero)
  5. BranchCode (stringa)
  6. BranchName (stringa)
  7. CompanyId (numero)
  8. CompanyName (stringa)
Corpo - Esempio JSON
{
    "interrogazione": {
        "le misure": [
            "site_area_1h_demographic_data.Gender_Male_SUM",
            "site_area_1h_demographic_data.Gender_Female_SUM",
            "site_area_1h_demographic_data.Emotion_Angry_SUM",
            "site_area_1h_demographic_data.Emotion_Contempt_SUM",
            "site_area_1h_demographic_data.Emotion_Disgust_SUM",
            "site_area_1h_demographic_data.Emotion_Fear_SUM",
            "site_area_1h_demographic_data.Emotion_Sad_SUM",
            "site_area_1h_demographic_data.Emotion_Neutral_SUM",
            "site_area_1h_demographic_data.Emotion_Happy_SUM",
            "site_area_1h_demographic_data.Emotion_Surprised_SUM",
            "site_area_1h_demographic_data.Children_Age",
            "site_area_1h_demographic_data.Teenagers_Age",
            "site_area_1h_demographic_data.Young_Adults_Age",
            "site_area_1h_demographic_data.Middle_Aged_Adults_Age",
            "site_area_1h_demographic_data.Elderly_Age",
            "site_area_1h_demographic_data.Kids_And_Adults_Age"
        ],
        "dimensioni": [
            "site_area_1h_demographic_data.CompanyId",
            "site_area_1h_demographic_data.CompanyName",
            "site_area_1h_demographic_data.BranchId",
            "site_area_1h_demographic_data.BranchName",
            "site_area_1h_demographic_data.BranchCode",
            "site_area_1h_demographic_data.AreaId",
            "site_area_1h_demographic_data.AreaName",
            "site_area_1h_demographic_data.IsOperating",
            "site_area_1h_demographic_data.Time"
        ],
        "filtri": [
            {
                "member": "site_area_1h_demographic_data.CompanyId",
                "operatore": "uguale",
                "i valori": [
                    "12345"
                ]
            },
            {
                "member": "site_area_1h_demographic_data.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            },
            {
                "member": "site_area_1h_demographic_data.AreaId",
                "operatore": "uguale",
                "i valori": [
                    "33333"
                ]
            }
        ],
        "timeDimensions": [
            {
                "dimension": "site_area_1h_demographic_data.Time",
                "intervallo di date": [
                    "2023-01-01T00:00:00.000",
                    "2023-01-02"
                ],
                "granularità": "minuto"
            }
        ],
        "ordine": [
            [
                "site_area_1h_demographic_data.BranchId",
                "asc"
            ],
            [
                "site_area_1h_demographic_data.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta - Esempio JSON
{


    ...


 
"dati": [
                {
                    "site_area_1h_demographic_data.CompanyId": 12345,
                    "site_area_1h_demographic_data.CompanyName": "Azienda dimostrativa",
                    "site_area_1h_demographic_data.BranchId": 22222,
                    "site_area_1h_demographic_data.BranchName": "DemoBranch",
                    "site_area_1h_demographic_data.AreaId": 33333,
                    "site_area_1h_demographic_data.AreaName": "Area dimostrativa",
                    "site_area_1h_demographic_data.IsOperating": 1,
                    "site_area_1h_demographic_data.Time": "2023-01-01T00:00:00.000",
                    "site_area_1h_demographic_data.Gender_Male_SUM": 22,
                    "site_area_1h_demographic_data.Gender_Female_SUM": 13,
                    "site_area_1h_demographic_data.Emotion_Angry_SUM": 1,
                    "site_area_1h_demographic_data.Emotion_Contempt_SUM": 0,
                    "site_area_1h_demographic_data.Emotion_Disgust_SUM": 4,
                    "site_area_1h_demographic_data.Emotion_Fear_SUM": 2,
                    "site_area_1h_demographic_data.Emotion_Sad_SUM": 4,
                    "site_area_1h_demographic_data.Emotion_Neutral_SUM": 3,
                    "site_area_1h_demographic_data.Emotion_Happy_SUM": 2,
                    "site_area_1h_demographic_data.Emotion_Surprised_SUM": 5,
                    "site_area_1h_demographic_data.Children_Age": 4,
                    "site_area_1h_demographic_data.Teenagers_Age": 392,
                    "site_area_1h_demographic_data.Young_Adults_Age": 12,
                    "site_area_1h_demographic_data.Middle_Aged_Adults_Age": 14,
                    "site_area_1h_demographic_data.Elderly_Age": 2,
                    "site_area_1h_demographic_data.Kids_And_Adults_Age": 16
                },
                {
                    "site_area_1h_demographic_data.CompanyId": 12345,
                    "site_area_1h_demographic_data.CompanyName": "Azienda dimostrativa",
                    "site_area_1h_demographic_data.BranchId": 22222,
                    "site_area_1h_demographic_data.BranchName": "DemoBranch",
                    "site_area_1h_demographic_data.AreaId": 33333,
                    "site_area_1h_demographic_data.AreaName": "Area dimostrativa",
                    "site_area_1h_demographic_data.IsOperating": 1,
                    "site_area_1h_demographic_data.Time": "2023-01-02T00:00:00.000",
                    "site_area_1h_demographic_data.Gender_Male_SUM": 14,
                    "site_area_1h_demographic_data.Gender_Female_SUM": 17,
                    "site_area_1h_demographic_data.Emotion_Angry_SUM": 0,
                    "site_area_1h_demographic_data.Emotion_Contempt_SUM": 3,
                    "site_area_1h_demographic_data.Emotion_Disgust_SUM": 2,
                    "site_area_1h_demographic_data.Emotion_Fear_SUM": 3,
                    "site_area_1h_demographic_data.Emotion_Sad_SUM": 3,
                    "site_area_1h_demographic_data.Emotion_Neutral_SUM": 4,
                    "site_area_1h_demographic_data.Emotion_Happy_SUM": 7,
                    "site_area_1h_demographic_data.Emotion_Surprised_SUM": 8,
                    "site_area_1h_demographic_data.Children_Age": 22,
                    "site_area_1h_demographic_data.Teenagers_Age": 12,
                    "site_area_1h_demographic_data.Young_Adults_Age": 78,
                    "site_area_1h_demographic_data.Middle_Aged_Adults_Age": 22,
                    "site_area_1h_demographic_data.Elderly_Age": 10,
                    "site_area_1h_demographic_data.Kids_And_Adults_Age": 100
                }
    ],


    ...


}

area_occupazione_live

Descrizione Conteggio dell'occupazione in tempo reale del sito e dell'area del negozio
Nome cubo
area_occupazione_live
Granularità temporali

Nessuna granularità temporale necessaria per i dati in tempo reale

Misure
  1. PSO05
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. AreaId (numero)
  2. NomeArea (stringa)
  3. BranchId (numero)
  4. BranchName (stringa)
  5. CompanyId (numero)
  6. CompanyName (stringa)
Corpo - Esempio JSON
{
    "interrogazione": {
        "le misure": [
            "area_occupazione_live.PSO05"
        ],
        "dimensioni": [
            "area_occupancy_live.CompanyId",
            "area_occupancy_live.CompanyName",
            "area_occupancy_live.BranchId",
            "area_occupancy_live.BranchName",
            "area_occupancy_live.AreaId",
            "area_occupancy_live.AreaName",
            "area_occupazione_live.AreaType"
        ],
        "filtri": [
            {
                "member": "area_occupancy_live.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            },
            {
                "member": "area_occupancy_live.AreaId",
                "operatore": "uguale",
                "i valori": [
                    "33333/XNUMX",
                    "44444"
                ]
            }
        ], 
        "ordine": [
            [
                "area_occupancy_live.BranchId",
                "asc"
            ],
            [
                "area_occupazione_live.Ora",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta - Esempio JSON
{


    ...


 
"dati": [
             
       {
            "area_occupancy_live.CompanyId": 12345,
            "area_occupancy_live.CompanyName": "Azienda dimostrativa",
            "area_occupancy_live.BranchId": 11111,
            "area_occupancy_live.BranchName": "DemoBranch",
            "area_occupancy_live.AreaId": 33333,
            "area_occupancy_live.AreaName": "Area dimostrativa",
            "area_occupancy_live.AreaType": 1,
            "area_occupancy_live.PSO05": 5632
        },       
       {
            "area_occupancy_live.CompanyId": 12345,
            "area_occupancy_live.CompanyName": "Azienda dimostrativa",
            "area_occupancy_live.BranchId": 22222,
            "area_occupancy_live.BranchName": "DemoBranch",
            "area_occupancy_live.AreaId": 44444,
            "area_occupancy_live.AreaName": "Area dimostrativa",
            "area_occupancy_live.AreaType": 1,
            "area_occupancy_live.PSO05": 2224
        }
 
    ],


    ...


}

site_area_1d_kid_counting_data

Descrizione Memorizza i dati di conteggio di bambini e adulti del sito e dell'area
Nome cubo
site_area_1d_kid_counting_data
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'giorno'.

giorno, settimana, mese, anno

Misure
  1. PFC01_3001
  2. PFC02_3001
  3. PFC01_5001
  4. PFC02_5001
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. AreaId (numero)
  2. NomeArea (stringa)
  3. BranchId (numero)
  4. BranchName (stringa)
  5. CompanyId (numero)
  6. CompanyName (stringa)
Corpo - Esempio JSON
{
    "interrogazione": {
        "le misure": [
            "site_area_1d_kid_counting_data.PFC01_3001",
            "site_area_1d_kid_counting_data.PFC02_3001",
            "site_area_1d_kid_counting_data.PFC01_5001",
            "site_area_1d_kid_counting_data.PFC02_5001"
        ],
        "dimensioni": [
            "site_area_1d_kid_counting_data.CompanyId",
            "site_area_1d_kid_counting_data.NomeAzienda",
            "site_area_1d_kid_counting_data.BranchId",
            "site_area_1d_kid_counting_data.BranchName",
            "site_area_1d_kid_counting_data.AreaId",
            "site_area_1d_kid_counting_data.AreaName",
            "site_area_1d_kid_counting_data.AreaType"
        ],
        "filtri": [
            {
                "membro": "site_area_1d_kid_counting_data.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            },
            {
                "membro": "site_area_1d_kid_counting_data.AreaId",
                "operatore": "uguale",
                "i valori": [
                    "33333/XNUMX",
                    "44444"
                ]
            }
        ], 
        "ordine": [
            [
                "site_area_1d_kid_counting_data.BranchId",
                "asc"
            ],
            [
                "site_area_1d_kid_counting_data.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta - Esempio JSON
{


    ...


 
"dati": [
             
       {
            "site_area_1d_kid_counting_data.CompanyId": 12345,
            "site_area_1d_kid_counting_data.CompanyName": "Azienda demo",
            "site_area_1d_kid_counting_data.BranchId": 11111,
            "site_area_1d_kid_counting_data.BranchName": "DemoBranch",
            "site_area_1d_kid_counting_data.AreaId": 33333,
            "site_area_1d_kid_counting_data.AreaName": "AreaDemo",
            "site_area_1d_kid_counting_data.AreaType": 1,
            "site_area_1d_kid_counting_data.PFC01_3001": 5422,
            "site_area_1d_kid_counting_data.PFC02_3001": 5420,
            "site_area_1d_kid_counting_data.PFC01_5001": 12532,
            "site_area_1d_kid_counting_data.PFC02_5001": 12529 
        },       
       {
            "site_area_1d_kid_counting_data.CompanyId": 12345,
            "site_area_1d_kid_counting_data.CompanyName": "Azienda demo",
            "site_area_1d_kid_counting_data.BranchId": 22222,
            "site_area_1d_kid_counting_data.BranchName": "DemoBranch",
            "site_area_1d_kid_counting_data.AreaId": 44444,
            "site_area_1d_kid_counting_data.AreaName": "AreaDemo",
            "site_area_1d_kid_counting_data.AreaType": 1,
            "site_area_1d_kid_counting_data.PFC01_3001": 5428,
            "site_area_1d_kid_counting_data.PFC02_3001": 5315,
            "site_area_1d_kid_counting_data.PFC01_5001": 35147,
            "site_area_1d_kid_counting_data.PFC02_5001": 32362
 
        }


    ],


    ...


}

site_area_1h_kid_counting_data

Descrizione Memorizza i dati di conteggio di bambini e adulti del sito e dell'area
Nome cubo
site_area_1h_kid_counting_data
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è "ora".

ora, giorno, settimana, mese, anno

Misure
  1. PFC01_3001
  2. PFC02_3001
  3. PFC01_5001
  4. PFC02_5001
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati.

  1. AreaId (numero)
  2. NomeArea (stringa)
  3. BranchId (numero)
  4. BranchName (stringa)
  5. CompanyId (numero)
  6. CompanyName (stringa)
Corpo - Esempio JSON
{
    "interrogazione": {
        "le misure": [
            "site_area_1h_kid_counting_data.PFC01_3001",
            "site_area_1h_kid_counting_data.PFC02_3001",
            "site_area_1h_kid_counting_data.PFC01_5001",
            "site_area_1h_kid_counting_data.PFC02_5001"
        ],
        "dimensioni": [
            "site_area_1h_kid_counting_data.CompanyId",
            "site_area_1h_kid_counting_data.NomeAzienda",
            "site_area_1h_kid_counting_data.BranchId",
            "site_area_1h_kid_counting_data.BranchName",
            "site_area_1h_kid_counting_data.AreaId",
            "site_area_1h_kid_counting_data.AreaName",
            "site_area_1h_kid_counting_data.AreaType"
        ],
        "filtri": [
            {
                "membro": "site_area_1h_kid_counting_data.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            },
            {
                "membro": "site_area_1h_kid_counting_data.AreaId",
                "operatore": "uguale",
                "i valori": [
                    "33333/XNUMX",
                    "44444"
                ]
            }
        ], 
        "ordine": [
            [
                "site_area_1h_kid_counting_data.BranchId",
                "asc"
            ],
            [
                "site_area_1h_kid_counting_data.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta - Esempio JSON
{


    ...


 
"dati": [
             
       {
            "site_area_1h_kid_counting_data.CompanyId": 12345,
            "site_area_1h_kid_counting_data.CompanyName": "Azienda demo",
            "site_area_1h_kid_counting_data.BranchId": 11111,
            "site_area_1h_kid_counting_data.BranchName": "DemoBranch",
            "site_area_1h_kid_counting_data.AreaId": 33333,
            "site_area_1h_kid_counting_data.AreaName": "DemoArea",
            "site_area_1h_kid_counting_data.AreaType": 1,
            "site_area_1h_kid_counting_data.PFC01_3001": 5422,
            "site_area_1h_kid_counting_data.PFC02_3001": 5420,
            "site_area_1h_kid_counting_data.PFC01_5001": 12532,
            "site_area_1h_kid_counting_data.PFC02_5001": 12529 
        },       
       {
            "site_area_1h_kid_counting_data.CompanyId": 12345,
            "site_area_1h_kid_counting_data.CompanyName": "Azienda demo",
            "site_area_1h_kid_counting_data.BranchId": 22222,
            "site_area_1h_kid_counting_data.BranchName": "DemoBranch",
            "site_area_1h_kid_counting_data.AreaId": 44444,
            "site_area_1h_kid_counting_data.AreaName": "DemoArea",
            "site_area_1h_kid_counting_data.AreaType": 1,
            "site_area_1h_kid_counting_data.PFC01_3001": 5428,
            "site_area_1h_kid_counting_data.PFC02_3001": 5315,
            "site_area_1h_kid_counting_data.PFC01_5001": 35147,
            "site_area_1h_kid_counting_data.PFC02_5001": 32362
 
        }


    ],


    ...


}

site_area_wifi_counting_metric_day_data

Descrizione Memorizza i dati di conteggio wifi del sito
Nome cubo site_area_wifi_counting_metric_day_data
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'giorno'.

giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo

  1. PWA01
  2. SWA02
  3. PWA03
  4. SWA04
  5. SWA06
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati. 

  1. Ora (data e ora come stringa): Esempio "2021-10-01T00:00:00.000", "2021-10-03T00:00"
  2. BranchId (stringa)
  3. BranchName (stringa)
  4. CompanyId (stringa)
  5. CompanyName (stringa)
Corpo: esempi JSON
{
    "queryType": "multi",
    "interrogazione": {
        "le misure": [
            "site_area_wifi_counting_metric_day_data.PWA01",
            "site_area_wifi_counting_metric_day_data.SWA02",
            "site_area_wifi_counting_metric_day_data.PWA03",
            "site_area_wifi_counting_metric_day_data.SWA04",
            "site_area_wifi_counting_metric_day_data.SWA06"
        ],
        "dimensioni": [
            "site_area_wifi_counting_metric_day_data.Time",
            "site_area_wifi_counting_metric_day_data.BranchId",
            "site_area_wifi_counting_metric_day_data.BranchName",
            "site_area_wifi_counting_metric_day_data.CompanyId",
            "site_area_wifi_counting_metric_day_data.CompanyName"
        ],
"filtri": [
            {
                "membro": "site_area_wifi_counting_metric_day_data.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            }
        ], 
        "ordine": [
            [
                "site_area_wifi_counting_metric_day_data.BranchId",
                "asc"
            ],
            [
                "site_area_wifi_counting_metric_day_data.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta: esempi JSON
{


    ...


 
"dati": [
             
       {
            "site_area_wifi_counting_metric_day_data.Time": "2022-01-01T00:00:00.000",
            "site_area_wifi_counting_metric_day_data.BranchId": 11111,
            "site_area_wifi_counting_metric_day_data.BranchName": "DemoBranch",
            "site_area_wifi_counting_metric_day_data.CompanyId": 12345,
            "site_area_wifi_counting_metric_day_data.CompanyName": "DemoCompany",
            "site_area_wifi_counting_metric_day_data.PWA01": 204,
            "site_area_wifi_counting_metric_day_data.SWA02": 1.22,
            "site_area_wifi_counting_metric_day_data.PWA03": 23.12,
            "site_area_wifi_counting_metric_day_data.SWA04": 0.2367,
            "site_area_wifi_counting_metric_day_data.SWA06": 0.7633 
        },       
       {      
            "site_area_wifi_counting_metric_day_data.Time": "2022-01-02T00:00:00.000",
            "site_area_wifi_counting_metric_day_data.BranchId": 11111,
            "site_area_wifi_counting_metric_day_data.BranchName": "DemoBranch",
            "site_area_wifi_counting_metric_day_data.CompanyId": 12345,
            "site_area_wifi_counting_metric_day_data.CompanyName": "DemoCompany",
            "site_area_wifi_counting_metric_day_data.PWA01": 137,
            "site_area_wifi_counting_metric_day_data.SWA02": 4.16,
            "site_area_wifi_counting_metric_day_data.PWA03": 15.18,
            "site_area_wifi_counting_metric_day_data.SWA04": 0.1418,
            "site_area_wifi_counting_metric_day_data.SWA06": 0.8582 
        }


    ],


    ...


}

site_area_wifi_counting_metric_hour_data

Descrizione Memorizza i dati di conteggio wifi del sito
Nome cubo site_area_wifi_counting_metric_hour_data
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è "ora".

ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo

  1. PWA01
  2. SWA02
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati. 

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. BranchId (stringa)
  3. BranchName (stringa)
  4. CompanyId (stringa)
  5. CompanyName (stringa)
Corpo: esempi JSON
{
    "interrogazione": {
        "le misure": [
            "site_area_wifi_counting_metric_hour_data.PWA01",
            "site_area_wifi_counting_metric_hour_data.SWA02"
        ],
        "dimensioni": [
            "site_area_wifi_counting_metric_hour_data.Time",
            "site_area_wifi_counting_metric_hour_data.BranchId",
            "site_area_wifi_counting_metric_hour_data.BranchName",
            "site_area_wifi_counting_metric_hour_data.CompanyId",
            "site_area_wifi_counting_metric_hour_data.CompanyName"
        ],
"filtri": [
            {
                "membro": "site_area_wifi_counting_metric_hour_data.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            }
        ], 
        "ordine": [
            [
                "site_area_wifi_counting_metric_hour_data.BranchId",
                "asc"
            ],
            [
                "site_area_wifi_counting_metric_hour_data.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta: esempi JSON
{


    ...


 
"dati": [
             
   
       {
            "site_area_wifi_counting_metric_hour_data.Time": "2022-01-01T00:00:00.000",
            "site_area_wifi_counting_metric_hour_data.BranchId": 11111,
            "site_area_wifi_counting_metric_hour_data.BranchName": "DemoBranch",
            "site_area_wifi_counting_metric_hour_data.CompanyId": 12345,
            "site_area_wifi_counting_metric_hour_data.CompanyName": "DemoCompany",
            "site_area_wifi_counting_metric_hour_data.PWA01": 204,
            "site_area_wifi_counting_metric_hour_data.SWA02": 1.22
        },       
       {      
            "site_area_wifi_counting_metric_hour_data.Time": "2022-01-01T01:00:00.000",
            "site_area_wifi_counting_metric_hour_data.BranchId": 11111,
            "site_area_wifi_counting_metric_hour_data.BranchName": "DemoBranch",
            "site_area_wifi_counting_metric_hour_data.CompanyId": 12345,
            "site_area_wifi_counting_metric_hour_data.CompanyName": "DemoCompany",
            "site_area_wifi_counting_metric_hour_data.PWA01": 137,
            "site_area_wifi_counting_metric_hour_data.SWA02": 4.16
        }


    ],


    ...


}

site_1d_footfall_wifi_sales_data

Descrizione Memorizza i dati di calpestio giornalieri
Nome cubo site_1d_footfall_wifi_sales_data
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'giorno'.

giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo

  1. PFC01_11
  2. PFC27
  3. PWA01
  4. SWA02
  5. SWA04
  6. SWA06
Dimensioni  

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati. 

  1. Ora (data e ora come stringa): Esempio "2021-10-01T00:00:00.000", "2021-10-01T00:00"
  2. BranchId (stringa)
  3. BranchName (stringa)
  4. CompanyId (stringa)
  5. CompanyName (stringa)
Corpo: esempi JSON
{
    "interrogazione": {
        "le misure": [
            "site_1d_footfall_wifi_sales_data.PFC01_11",
            "site_1d_footfall_wifi_sales_data.PFC27",
            "site_1d_footfall_wifi_sales_data.PWA01",
            "site_1d_footfall_wifi_sales_data.SWA02",
            "site_1d_footfall_wifi_sales_data.SWA04",
            "site_1d_footfall_wifi_sales_data.SWA06"
        ],
        "dimensioni": [
            "site_1d_footfall_wifi_sales_data.Time",
            "site_1d_footfall_wifi_sales_data.BranchId",
            "site_1d_footfall_wifi_sales_data.BranchName",
            "site_1d_footfall_wifi_sales_data.CompanyId",
            "site_1d_footfall_wifi_sales_data.CompanyName"
        ],
        "filtri": [
            {
                "membro": "site_1d_footfall_wifi_sales_data.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            }
        ], 
        "ordine": [
            [
                "site_1d_footfall_wifi_sales_data.BranchId",
                "asc"
            ],
            [
                "site_1d_footfall_wifi_sales_data.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta: esempi JSON
{


    ...


 
"dati": [
             
   
       {
            "site_1d_footfall_wifi_sales_data.Time": "2022-01-01T00:00:00.000",
            "site_1d_footfall_wifi_sales_data.BranchId": 11111,
            "site_1d_footfall_wifi_sales_data.BranchName": "DemoBranch",
            "site_1d_footfall_wifi_sales_data.CompanyId": 12345,
            "site_1d_footfall_wifi_sales_data.CompanyName": "DemoCompany",
            "site_1d_footfall_wifi_sales_data.PFC01_11": 2366,
            "site_1d_footfall_wifi_sales_data.PFC27": 1195.209,
            "site_1d_footfall_wifi_sales_data.PWA01": 649,
            "site_1d_footfall_wifi_sales_data.SWA02": 0.7847,
            "site_1d_footfall_wifi_sales_data.SWA04": 0.6124,
            "site_1d_footfall_wifi_sales_data.SWA06": 0.3876
        },       
       {      
            "site_1d_footfall_wifi_sales_data.Time": "2022-01-02T00:00:00.000",
            "site_1d_footfall_wifi_sales_data.BranchId": 11111,
            "site_1d_footfall_wifi_sales_data.BranchName": "DemoBranch",
            "site_1d_footfall_wifi_sales_data.CompanyId": 12345,
            "site_1d_footfall_wifi_sales_data.CompanyName": "DemoCompany",
            "site_1d_footfall_wifi_sales_data.PFC01_11": 2171,
            "site_1d_footfall_wifi_sales_data.PFC27": 937.0556,
            "site_1d_footfall_wifi_sales_data.PWA01": 861,
            "site_1d_footfall_wifi_sales_data.SWA02": 0.7160,
            "site_1d_footfall_wifi_sales_data.SWA04": 0.6106,
            "site_1d_footfall_wifi_sales_data.SWA06": 0.3894
        }


    ],


    ...


}

site_area_1h_customer_journeys

Descrizione Memorizza i percorsi orari dei clienti
Nome cubo site_area_1h_customer_journeys
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è "ora".

ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo

  1. Conteggio viaggi
Dimensioni  

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati. 

  1. DateTime (dataora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (stringa)
  3. NomeArea (stringa)
  4. BranchId (stringa)
  5. BranchName (stringa)
  6. CompanyId (stringa)
  7. Nome della ditta
  8. Viaggio (stringa)
  9. JourneyId (stringa)
Settori I segmenti seguenti possono essere utilizzati per interrogare i dati corrispondenti in base alla granularità necessaria. 
  1. IsAreaLevel ("vero")
  2. IsSiteLevel ("vero")
Corpo: esempi JSON
{
    "interrogazione": {
        "le misure": [
            "site_area_1h_customer_journeys.JourneyCount"
        ],
        "dimensioni": [
            "site_area_1h_customer_journeys.DateTime",
            "site_area_1h_customer_journeys.AreaId",
            "site_area_1h_customer_journeys.AreaName",
            "site_area_1h_customer_journeys.BranchId",
            "site_area_1h_customer_journeys.NomeFiliale",
            "site_area_1h_customer_journeys.CompanyId",
            "site_area_1h_customer_journeys.NomeAzienda",
            "site_area_1h_customer_journeys.Viaggio",
            "site_area_1h_customer_journeys.JourneyIds"
        ],
       "segmenti" : [
            "site_area_1h_customer_journeys.IsAreaLevel"
       ]
        "filtri": [
            {
                "membro": "site_area_1h_customer_journeys.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            }
        ], 
        "ordine": [
            [
                "site_area_1h_customer_journeys.BranchId",
                "asc"
            ],
            [
                "site_area_1h_customer_journeys.DateTime",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta: esempi JSON
{


    ...


 
"dati": [
             
   
       {
            "site_area_1h_customer_journeys.DateTime": "2022-01-01T00:00:00.000",
            "site_area_1h_customer_journeys.AreaId": 13131,
            "site_area_1h_customer_journeys.AreaName": "DemoArea",
            "site_area_1h_customer_journeys.BranchId": 11111,
            "site_area_1h_customer_journeys.BranchName": "DemoBranch",
            "site_area_1h_customer_journeys.CompanyId": 12345,
            "site_area_1h_customer_journeys.CompanyName": "DemoCompany",
            "site_area_1h_customer_journeys.Journey": "DemoZone2",
            "site_area_1h_customer_journeys.JourneyIds": "[2]", 
            "site_area_1h_customer_journeys.JourneyCount": 46
        },       
       {      
            "site_area_1h_customer_journeys.DateTime": "2022-01-01T00:00:00.000",
            "site_area_1h_customer_journeys.AreaId": 13131,
            "site_area_1h_customer_journeys.AreaName": "DemoArea",
            "site_area_1h_customer_journeys.BranchId": 11111,
            "site_area_1h_customer_journeys.BranchName": "DemoBranch",
            "site_area_1h_customer_journeys.CompanyId": 12345,
            "site_area_1h_customer_journeys.CompanyName": "DemoCompany",
            "site_area_1h_customer_journeys.Journey": "DemoZone1 -> DemoZone2",
            "site_area_1h_customer_journeys.JourneyIds": "[1,2]",
            "site_area_1h_customer_journeys.JourneyCount": 27
        }


    ],


    ...


}

site_area_1h_counting_data_ext

Descrizione Memorizza i dati di conteggio orario e il tempo di permanenza
Nome cubo site_area_1h_counting_data_ext
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è "ora".

ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo

  1. FC01_11
  2. PFC27
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati. 

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (stringa)
  3. NomeArea (stringa)
  4. BranchId (stringa)
  5. BranchName (stringa)
  6. CompanyId (stringa)
  7. CompanyName (stringa)
Settori

I segmenti seguenti possono essere utilizzati per interrogare i dati corrispondenti in base alla granularità necessaria. 

  1. IsAreaLevel ("vero")
  2. IsSiteLevel ("vero")
Corpo: esempi JSON
{
    "interrogazione": {
        "le misure": [
            "site_area_1h_counting_data_ext.FC01_11",
            "site_area_1h_counting_data_ext.PFC27"
        ],
        "dimensioni": [
            "site_area_1h_counting_data_ext.Time",
            "site_area_1h_counting_data_ext.AreaId",
            "site_area_1h_counting_data_ext.AreaName",
            "site_area_1h_counting_data_ext.BranchId",
            "site_area_1h_counting_data_ext.Nomeramo",
            "site_area_1h_counting_data_ext.CompanyId",
            "site_area_1h_counting_data_ext.NomeAzienda"
        ],
"filtri": [
            {
                "membro": "site_area_1h_counting_data_ext.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            }
        ], 
        "ordine": [
            [
                "site_area_1h_counting_data_ext.BranchId",
                "asc"
            ],
            [
                "site_area_1h_counting_data_ext.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta: esempi JSON
{


    ...


 
"dati": [
             
   
       {
            "site_area_1h_counting_data_ext.Time": "2022-01-01T00:00:00.000",
            "site_area_1h_counting_data_ext.AreaId": 13131,
            "site_area_1h_counting_data_ext.AreaName": "DemoArea",
            "site_area_1h_counting_data_ext.BranchId": 11111,
            "site_area_1h_counting_data_ext.BranchName": "DemoBranch",
            "site_area_1h_counting_data_ext.CompanyId": 12345,
            "site_area_1h_counting_data_ext.CompanyName": "DemoCompany",
            "site_area_1h_counting_data_ext.FC01_11": 204,
            "site_area_1h_counting_data_ext.PFC27": 1320.34
        },       
       {      
            "site_area_1h_counting_data_ext.Time": "2022-01-01T01:00:00.000",
            "site_area_1h_counting_data_ext.AreaId": 13131,
            "site_area_1h_counting_data_ext.AreaName": "DemoArea",
            "site_area_1h_counting_data_ext.BranchId": 11111,
            "site_area_1h_counting_data_ext.BranchName": "DemoBranch",
            "site_area_1h_counting_data_ext.CompanyId": 12345,
            "site_area_1h_counting_data_ext.CompanyName": "DemoCompany",
            "site_area_1h_counting_data_ext.FC01_11": 137,
            "site_area_1h_counting_data_ext.PFC27": 1201.31
        }


    ],


    ...


}

area_1h_footfall_wifi_sales_data

Descrizione Memorizza i dati orari sul conteggio del WiFi di calpestio dell'area
Nome cubo area_1h_footfall_wifi_sales_data
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è "ora".

ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo

  1. PFC01_11
  2. PFC27
  3. PFH05
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati. 

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (stringa)
  3. NomeArea (stringa)
  4. BranchId (stringa)
  5. BranchName (stringa)
  6. CompanyId (stringa)
  7. CompanyName (stringa)
  8. IsOperating (stringa)
Corpo: esempi JSON
{
    "interrogazione": {
        "le misure": [
            "area_1h_footfall_wifi_sales_data.PFC01_11",
            "area_1h_footfall_wifi_sales_data.PFC27",
            "area_1h_footfall_wifi_sales_data.PFH05"
        ],
        "dimensioni": [
            "area_1h_footfall_wifi_sales_data.Time",
            "area_1h_footfall_wifi_sales_data.AreaId",
            "area_1h_footfall_wifi_sales_data.AreaName",
            "area_1h_footfall_wifi_sales_data.BranchId",
            "area_1h_footfall_wifi_sales_data.BranchName",
            "area_1h_footfall_wifi_sales_data.CompanyId",
            "area_1h_footfall_wifi_sales_data.NomeAzienda",
            "area_1h_footfall_wifi_sales_data.IsOperating"
        ],
        "filtri": [
            {
                "membro": "area_1h_footfall_wifi_sales_data.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            }
        ], 
        "ordine": [
            [
                "area_1h_footfall_wifi_sales_data.BranchId",
                "asc"
            ],
            [
                "area_1h_footfall_wifi_sales_data.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta: esempi JSON
{


    ...


 
"dati": [
             
   
       {
            "area_1h_footfall_wifi_sales_data.Time": "2022-01-01T00:00:00.000",
            "area_1h_footfall_wifi_sales_data.AreaId": 13131,
            "area_1h_footfall_wifi_sales_data.AreaName": "DemoArea",
            "area_1h_footfall_wifi_sales_data.BranchId": 11111,
            "area_1h_footfall_wifi_sales_data.BranchName": "DemoBranch",
            "area_1h_footfall_wifi_sales_data.CompanyId": 12345,
            "area_1h_footfall_wifi_sales_data.CompanyName": "DemoCompany",
            "area_1h_footfall_wifi_sales_data.IsOperating": 1,
            "area_1h_footfall_wifi_sales_data.PFC01_11": 204,
            "area_1h_footfall_wifi_sales_data.PFC27": 1320.34,
            "area_1h_footfall_wifi_sales_data.PFH05": 19.7288
        },       
       {      
            "area_1h_footfall_wifi_sales_data.Time": "2022-01-01T01:00:00.000",
            "area_1h_footfall_wifi_sales_data.AreaId": 13131,
            "area_1h_footfall_wifi_sales_data.AreaName": "DemoArea",
            "area_1h_footfall_wifi_sales_data.BranchId": 11111,
            "area_1h_footfall_wifi_sales_data.BranchName": "DemoBranch",
            "area_1h_footfall_wifi_sales_data.CompanyId": 12345,
            "area_1h_footfall_wifi_sales_data.CompanyName": "DemoCompany",
            "area_1h_footfall_wifi_sales_data.IsOperating": 0,
            "area_1h_footfall_wifi_sales_data.PFC01_11": 137,
            "area_1h_footfall_wifi_sales_data.PFC27": 1201.31,
            "area_1h_footfall_wifi_sales_data.PFH05": 21.4473
        }


    ],


    ...


}

area_1h_footfall_wifi_sales_data_new

Descrizione Memorizza i dati orari sul conteggio del WiFi di calpestio dell'area
Nome cubo area_1h_footfall_wifi_sales_data_new
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è "ora".

ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo

  1. VisitatoreIn
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati. 

  1. __time (dataora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. AreaId (stringa)
  3. NomeArea (stringa)
  4. BranchId (stringa)
  5. BranchName (stringa)
  6. CompanyId (stringa)
  7. CompanyName (stringa)
  8. Dwelltime (float come stringa)
  9. IsOperating (stringa)
Corpo: esempi JSON
{
    "interrogazione": {
        "le misure": [
            "area_1h_footfall_wifi_sales_data_new.VisitorIn"
        ],
        "dimensioni": [
            "area_1h_footfall_wifi_sales_data_new.__time",
            "area_1h_footfall_wifi_sales_data_new.AreaId",
            "area_1h_footfall_wifi_sales_data_new.AreaName",
            "area_1h_footfall_wifi_sales_data_new.BranchId",
            "area_1h_footfall_wifi_sales_data_new.BranchName",
            "area_1h_footfall_wifi_sales_data_new.CompanyId",
            "area_1h_footfall_wifi_sales_data_new.CompanyName",
            "area_1h_footfall_wifi_sales_data_new.Dwelltime",
            "area_1h_footfall_wifi_sales_data_new.IsOperating"
        ],
        "filtri": [
            {
                "membro": "area_1h_footfall_wifi_sales_data_new.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            }
        ], 
        "ordine": [
            [
                "area_1h_footfall_wifi_sales_data_new.BranchId",
                "asc"
            ],
            [
                "area_1h_footfall_wifi_sales_data_new.__time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta: esempi JSON
{


    ...


 
"dati": [
             
   
       {
            "area_1h_footfall_wifi_sales_data_new.__time": "2022-01-01T00:00:00.000",
            "area_1h_footfall_wifi_sales_data_new.AreaId": 13131,
            "area_1h_footfall_wifi_sales_data_new.AreaName": "DemoArea",
            "area_1h_footfall_wifi_sales_data_new.BranchId": 11111,
            "area_1h_footfall_wifi_sales_data_new.BranchName": "DemoBranch",
            "area_1h_footfall_wifi_sales_data_new.CompanyId": 12345,
            "area_1h_footfall_wifi_sales_data_new.CompanyName": "DemoCompany",
            "area_1h_footfall_wifi_sales_data_new.VisitorIn": 204,
            "area_1h_footfall_wifi_sales_data_new.Dwelltime": 1320.34,
            "area_1h_footfall_wifi_sales_data_new.IsOperating": 1
        },       
       {      
            "area_1h_footfall_wifi_sales_data_new.__time": "2022-01-01T01:00:00.000",
            "area_1h_footfall_wifi_sales_data_new.AreaId": 13131,
            "area_1h_footfall_wifi_sales_data_new.AreaName": "DemoArea",
            "area_1h_footfall_wifi_sales_data_new.BranchId": 11111,
            "area_1h_footfall_wifi_sales_data_new.BranchName": "DemoBranch",
            "area_1h_footfall_wifi_sales_data_new.CompanyId": 12345,
            "area_1h_footfall_wifi_sales_data_new.CompanyName": "DemoCompany",
            "area_1h_footfall_wifi_sales_data_new.VisitorIn": 137,
            "area_1h_footfall_wifi_sales_data_new.Dwelltime": 1201.31,
            "area_1h_footfall_wifi_sales_data_new.IsOperating": 0
        }


    ],


    ...


}

customer_journeys

Descrizione Memorizzare i percorsi dei clienti
Nome cubo customer_journeys
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è 'secondo'.

secondo, minuto, ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo

  1. Contare
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati. 

  1. DateTime (dataora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. BranchId (stringa)
  3. CompanyId (stringa)
  4. IsOperating (stringa)
  5. Viaggio (stringa)
  6. JourneyId (stringa)
Corpo: esempi JSON
{
    "interrogazione": {
        "le misure": [
            "customer_journeys.Count"
        ],
        "dimensioni": [
            "customer_journeys.DateTime",
            "customer_journeys.BranchId",
            "customer_journeys.CompanyId",
            "customer_journeys.IsOperating",
            "customer_journeys.Viaggio",
            "customer_journeys.JourneyIds"
        ],
        "filtri": [
            {
                "membro": "customer_journeys.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            }
        ], 
        "ordine": [
            [
                "customer_journeys.BranchId",
                "asc"
            ],
            [
                "customer_journeys.DateTime",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta: esempi JSON
{


    ...


 
"dati": [
             
   
       {
            "customer_journeys.Time": "2022-01-01T00:00:00.000",
            "customer_journeys.BranchId": 11111,
            "customer_journeys.CompanyId": 12345,
            "customer_journeys.IsOperating": 1,
            "customer_journeys.Journey": "Cassiere",
            "customer_journeys.JourneyIds": "[1]",
            "customer_journeys.Count": 1
        },       
       {      
            "customer_journeys.Time": "2022-01-01T01:00:00.000",
            "customer_journeys.BranchId": 11111,
            "customer_journeys.CompanyId": 12345,
            "customer_journeys.IsOperating": 0,
            "customer_journeys.Journey": "Frigo A -> Cassiere",
            "customer_journeys.JourneyIds": "[2]",
            "customer_journeys.Count": 2
        }


    ],


    ...


}

site_1h_footfall_wifi_sales_data

Descrizione Memorizza i dati di calpestio orario
Nome cubo site_1h_footfall_wifi_sales_data
Granularità temporali

Di seguito sono riportate le granularità temporali disponibili per questo cubo, la granularità temporale minima è "ora".

ora, giorno, settimana, mese, anno

Misure

Metriche disponibili per questo cubo

  1. PFC01_11
  2. PFC27
  3. PWA01
  4. SWA02
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati. 

  1. Ora (data e ora come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. BranchId (stringa)
  3. BranchName (stringa)
  4. CompanyId (stringa)
  5. CompanyName (stringa)
Corpo: esempi JSON
{
    "interrogazione": {
        "le misure": [
            "site_1h_footfall_wifi_sales_data.PFC01_11",
            "site_1h_footfall_wifi_sales_data.PFC27",
            "site_1h_footfall_wifi_sales_data.PWA01",
            "site_1h_footfall_wifi_sales_data.SWA02"
        ],
        "dimensioni": [
            "site_1h_footfall_wifi_sales_data.Time",
            "site_1h_footfall_wifi_sales_data.BranchId",
            "site_1h_footfall_wifi_sales_data.BranchName",
            "site_1h_footfall_wifi_sales_data.CompanyId",
            "site_1h_footfall_wifi_sales_data.NomeAzienda"
        ],
        "filtri": [
            {
                "membro": "site_1h_footfall_wifi_sales_data.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111/XNUMX",
                    "22222"
                ]
            }
        ], 
        "ordine": [
            [
                "site_1h_footfall_wifi_sales_data.BranchId",
                "asc"
            ],
            [
                "site_1h_footfall_wifi_sales_data.Time",
                "asc"
            ]
        ],
        "limite": 10
    }
}
Risposta: esempi JSON
{


    ...


 
"dati": [
             
   
       {
            "site_1h_footfall_wifi_sales_data.Time": "2022-01-01T00:00:00.000",
            "site_1h_footfall_wifi_sales_data.BranchId": 11111,
            "site_1h_footfall_wifi_sales_data.BranchName": "DemoBranch",
            "site_1h_footfall_wifi_sales_data.CompanyId": 12345,
            "site_1h_footfall_wifi_sales_data.CompanyName": "DemoCompany",
            "site_1h_footfall_wifi_sales_data.PFC01_11": 204,
            "site_1h_footfall_wifi_sales_data.PFC27": 1320.34,
            "site_1h_footfall_wifi_sales_data.PWA01": 649,
            "site_1h_footfall_wifi_sales_data.SWA02": 0.7847
        },       
       {      
            "site_1h_footfall_wifi_sales_data.Time": "2022-01-01T01:00:00.000",
            "site_1h_footfall_wifi_sales_data.BranchId": 11111,
            "site_1h_footfall_wifi_sales_data.BranchName": "DemoBranch",
            "site_1h_footfall_wifi_sales_data.CompanyId": 12345,
            "site_1h_footfall_wifi_sales_data.CompanyName": "DemoCompany",
            "site_1h_footfall_wifi_sales_data.PFC01_11": 2171,
            "site_1h_footfall_wifi_sales_data.PFC27": 937.0556,
            "site_1h_footfall_wifi_sales_data.PWA01": 861,
            "site_1h_footfall_wifi_sales_data.SWA02": 0.7160
        }


    ],


    ...


}

site_1h_counting_prediction

Descrizione

Traffico storico orario e traffico previsto per 14 giorni prima e dopo la data di inserimento. Per le date passate, vengono restituiti il ​​traffico storico e il traffico previsto per confrontare la precisione. Per le date future, viene restituito solo il traffico previsto, il traffico storico non è noto.

I dati storici orari di 56 giorni (minimo 14 giorni) vengono utilizzati per prevedere il traffico orario dei successivi 14 giorni.

Nome cubo site_1h_counting_prediction
Granularità temporali ora
Misure

Metriche disponibili per questo cubo:

  1. PFC01
  2. Previsione PFC01 (PFC23)
Dimensioni

I seguenti campi possono essere utilizzati per applicare il filtraggio e ordinare i dati. 

  1. CompanyId (numero)
  2. BranchId (stringa)
  3. BranchName (stringa)
  4. Giorno della settimana (numero)
  5. Ora (datetime come stringa): Esempio "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  6. StartDateTime (dataora come stringa)
  7. CurrentLocalTime (dataora come stringa)
  8. IsOperating (stringa)
Corpo: esempi JSON
{
    "interrogazione": {
        "dimensioni": [
            "site_1h_counting_prediction.CompanyId",
            "site_1h_counting_prediction.BranchId",
            "site_1h_counting_prediction.BranchName",
            "site_1h_counting_prediction.DayOfWeek",
            "site_1h_counting_prediction.Time",
            "site_1h_counting_prediction.StartDateTime",
            "site_1h_counting_prediction.CurrentLocalTime",
            "site_1h_counting_prediction.IsOperating",
            "site_1h_counting_prediction.PFC01",
            "site_1h_counting_prediction.PFC01_Prediction"
        ],
        "filtri": [
            {
                "membro": "site_1h_counting_prediction.BranchId",
                "operatore": "uguale",
                "i valori": [
                    "11111"
                ]
            },
            {
                "membro": "site_1h_counting_prediction.StartDateTime",
                "operatore": "uguale",
                "i valori": [
                    "2024-03-11"
                ]
            },
            {
                "membro": "site_1h_counting_prediction.IsOperating",
                "operatore": "uguale",
                "i valori": [
                    "1"
                ]
            }
        ],
        "ordine": [
            [
                "site_1h_counting_prediction.Time",
                "asc"
            ]
        ],
        "limite": 50000,
        "renewQuery": "VERO"
    }
}
Risposta: esempi JSON
{


    ...


 
"dati": [
        {
            "site_1h_counting_prediction.CompanyId": 12345,
            "site_1h_counting_prediction.BranchId": 11111,
            "site_1h_counting_prediction.BranchName": "DemoBranch",
            "site_1h_counting_prediction.DayOfWeek": 1,
            "site_1h_counting_prediction.Time": "2024-02-26T09:00:00.000",
            "site_1h_counting_prediction.StartDateTime": "2024-03-11T00:00:00.000",
            "site_1h_counting_prediction.CurrentLocalTime": "2024-03-11T16:05:58.000",
            "site_1h_counting_prediction.IsOperating": "1",
            "site_1h_counting_prediction.PFC01": 7,
            "site_1h_counting_prediction.PFC01_Prediction": 24
        },
 
       ...
       {
            "site_1h_counting_prediction.CompanyId": 12345,
            "site_1h_counting_prediction.BranchId": 11111,
            "site_1h_counting_prediction.BranchName": "DemoBranch",
            "site_1h_counting_prediction.DayOfWeek": 1,
            "site_1h_counting_prediction.Time": "2024-03-11T09:00:00.000",
            "site_1h_counting_prediction.StartDateTime": "2024-03-11T00:00:00.000",
            "site_1h_counting_prediction.CurrentLocalTime": "2024-03-11T16:05:58.000",
            "site_1h_counting_prediction.IsOperating": "1",
            "site_1h_counting_prediction.PFC01": 22,
            "site_1h_counting_prediction.PFC01_Prediction": 15
        },
 
         ...
     
        {
            "site_1h_counting_prediction.CompanyId": 12345,
            "site_1h_counting_prediction.BranchId": 11111,
            "site_1h_counting_prediction.BranchName": "DemoBranch",
            "site_1h_counting_prediction.DayOfWeek": 7,
            "site_1h_counting_prediction.Time": "2024-03-24T18:00:00.000",
            "site_1h_counting_prediction.StartDateTime": "2024-03-11T00:00:00.000",
            "site_1h_counting_prediction.CurrentLocalTime": "2024-03-11T16:05:58.000",
            "site_1h_counting_prediction.IsOperating": "1",
            "site_1h_counting_prediction.PFC01": null,
            "site_1h_counting_prediction.PFC01_Prediction": 288
        }
    ],


    ...


}

Aggiornato a marzo 15, 2024