Here is the code with both tables created separately in case you need some more info :
<div ods-adv-analysis="myData"
ods-adv-analysis-context="eolienperiodique"
ods-adv-analysis-select="AVG(ff_top_sonic_avg) as vit_moyenne, AVG(ff_top_sonic_avg)*3.6 as vit_moyenne_kmh, count(timestamp)/144*100 as disp_data, AVG(tt_99_avg) as temp_moyenne, sum(productible) as productible_moyen"
ods-adv-analysis-group-by="date_format(timestamp, 'dd/MM/YYYY') as days">
<ods-adv-table
data="myData"
sticky-header="true"
columns-options="{
days: {
label: 'Date'
},
vit_moyenne: {
label: 'Vitesse moyenne [m/s]',
decimals: 2
},
vit_moyenne_kmh: {
label: 'Vitesse moyenne [km/h]',
decimals: 2
},
disp_data: {
label: 'Disponibilité des données [%]',
decimals: 1
},
temp_moyenne: {
label: 'Température moyenne [°C]',
decimals: 1
},
productible_moyen: {
label: 'Productible [kWh]',
decimals: 0
}
}">
</ods-adv-table>
<div ods-adv-analysis="moyennedata"
ods-adv-analysis-context="eolienperiodique"
ods-adv-analysis-select="{{myData.length}} as jours, AVG(ff_top_sonic_avg) as vit_moyenne, AVG(ff_top_sonic_avg)*3.6 as vit_moyenne_kmh, count(timestamp)/144*100/{{myData.length}} as disp_data, AVG(tt_99_avg) as temp_moyenne, sum(productible) as productible_moyen">
<ods-adv-table
data="moyennedata"
sticky-header="true"
columns-options="{
jours: {
label: 'Jours (total)'
},
vit_moyenne: {
label: 'Vitesse moyenne [m/s]',
decimals: 2
},
vit_moyenne_kmh: {
label: 'Vitesse moyenne [km/h]',
decimals: 2
},
disp_data: {
label: 'Disponibilité des données [%]',
decimals: 1
},
temp_moyenne: {
label: 'Température moyenne [°C]',
decimals: 1
},
productible_moyen: {
label: 'Productible total [kWh]',
decimals: 0
}
}">
</ods-adv-table>
</div>
Hello Eric,
In case of complex table like this one I would advise you to use a classical html/css table (exemple). This will allow way more possibilities in terms of design for your table. You can look throw your both adv-analyis to display the line in the same table.
I hope this could help you improve your visualisation.
Best regards,
Aubin