Triple Performance permet d'insérer facilement des graphiques dans les pages, par exemple pour exposer une rotation sur plusieurs années, montrer les détails d'un bilan économique ou d'un assolement. Les données des graphiques sont saisies dans un document Google Spreadsheet™ et ensuite synchronisées dans la page grâce à un Add-On.
Sommaire
Installation de l'add-on
Voir l'article détaillé sur l'add-on :
Article détaillé : Aide:Utiliser l'add-on Triple Performance pour Google Spreadsheet
Types de graphiques
Il est possible d'insérer les graphiques suivants :
Comptabilité
Ce graphique permet d'afficher un bilan économique simple sur plusieurs années. Les couleurs permettent de distinguer ce qui est de l'ordre des charges opérationnelles, charges de structure, etc. En cliquant sur une zone, on peut voir le détail de ce qui constitue les charges précisément.
{
"tooltip": {},
"title": {
"text": "Évolution du bilan financier",
"subtext": "Cliquer sur une barre pour voir le détail",
"textAlign": "center",
"left": "50%"
},
"legend": {
"bottom": "20",
"type": "scroll",
"selectedMode": "multiple"
},
"xAxis": {
"type": "category",
"data": [
"2019",
"2020",
"2021",
"2022"
]
},
"yAxis": {
"type": "value",
"axisLabel": {
"formatter": "{value} €"
}
},
"grid": {
"containLabel": true
},
"series": [
{
"type": "bar",
"itemStyle": {
"color": "#afd095"
},
"label": {
"show": true,
"position": "inside",
"formatter": "{c} €"
},
"emphasis": {
"focus": "series"
},
"name": "Chiffre d'affaire",
"stack": "Produits",
"id": "Chiffre d'affaire",
"data": [
{
"groupId": "Produits",
"value": 450000
},
{
"groupId": "Produits",
"value": 361000
},
{
"groupId": "Produits",
"value": 528000
},
{
"groupId": "Produits",
"value": 598000
}
]
},
{
"type": "bar",
"itemStyle": {
"color": "#729fcf"
},
"label": {
"show": true,
"position": "inside",
"formatter": "{c} €"
},
"emphasis": {
"focus": "series"
},
"name": "Aides",
"stack": "Produits",
"id": "Aides",
"data": [
{
"groupId": "Produits",
"value": 76000
},
{
"groupId": "Produits",
"value": 107000
},
{
"groupId": "Produits",
"value": 55000
},
{
"groupId": "Produits",
"value": 63000
}
]
},
{
"type": "bar",
"itemStyle": {
"color": "#F28960"
},
"label": {
"show": true,
"position": "inside",
"formatter": "{c} €"
},
"emphasis": {
"focus": "series"
},
"name": "Charges opérationnelles",
"stack": "Charges",
"id": "Charges opérationnelles",
"data": [
{
"groupId": "Charges",
"value": 90240
},
{
"groupId": "Charges",
"value": 85760
},
{
"groupId": "Charges",
"value": 96800
},
{
"groupId": "Charges",
"value": 118720
}
]
},
{
"type": "bar",
"itemStyle": {
"color": "#F5A893"
},
"label": {
"show": true,
"position": "inside",
"formatter": "{c} €"
},
"emphasis": {
"focus": "series"
},
"name": "Charges de structure",
"stack": "Charges",
"id": "Charges de structure",
"data": [
{
"groupId": "Charges",
"value": 237000
},
{
"groupId": "Charges",
"value": 233720
},
{
"groupId": "Charges",
"value": 272000
},
{
"groupId": "Charges",
"value": 279360
}
]
},
{
"type": "bar",
"itemStyle": {
"color": "#FDCF74"
},
"label": {
"show": true,
"position": "inside",
"formatter": "{c} €"
},
"emphasis": {
"focus": "series"
},
"name": "Charges de personnel",
"stack": "Charges",
"id": "Charges de personnel",
"data": [
{
"groupId": "Charges",
"value": 8000
},
{
"groupId": "Charges",
"value": 7000
},
{
"groupId": "Charges",
"value": 16000
},
{
"groupId": "Charges",
"value": 20000
}
]
},
{
"type": "bar",
"itemStyle": {
"color": "#F8B26D"
},
"label": {
"show": true,
"position": "inside",
"formatter": "{c} €"
},
"emphasis": {
"focus": "series"
},
"name": "Soldes de gestion",
"stack": "Charges",
"id": "Soldes de gestion",
"data": [
{
"groupId": "Charges",
"value": 190760
},
{
"groupId": "Charges",
"value": 191520
},
{
"groupId": "Charges",
"value": 248200
},
{
"groupId": "Charges",
"value": 292920
}
]
}
]
}{
"2019": {
"Produits": {
"name": "Produits 2019\n526000 €",
"value": 526000,
"type": "treemap",
"breadcrumb": {
"height": 34,
"itemStyle": {
"textStyle": {
"lineHeight": 15
}
}
},
"data": [
{
"name": "Chiffre d'affaire\n450000 €",
"value": 450000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Vente de produits végétaux",
"value": 450000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#afd095",
"borderWidth": 1
}
},
{
"name": "Aides\n76000 €",
"value": 76000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "DPU, DPB",
"value": 48000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Aides",
"value": 25000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Aide à la certification",
"value": 3000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#729fcf",
"borderWidth": 1
}
}
]
},
"Charges": {
"name": "Charges 2019\n526000 €",
"value": 526000,
"type": "treemap",
"breadcrumb": {
"height": 34,
"itemStyle": {
"textStyle": {
"lineHeight": 15
}
}
},
"data": [
{
"name": "Charges opérationnelles\n90240 €",
"value": 90240,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Semences et plants",
"value": 23360,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Fertilisation",
"value": 24160,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Produits de traitements",
"value": 33600,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Travaux par tiers",
"value": 9120,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F28960",
"borderWidth": 1
}
},
{
"name": "Charges de structure\n237000 €",
"value": 237000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Carburant",
"value": 17280,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Entretien matériel",
"value": 14560,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Eau, gaz, électricité",
"value": 1000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Frais de gestion",
"value": 9000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Fermage",
"value": 36480,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Assurances",
"value": 29120,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Autres",
"value": 129560,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F5A893",
"borderWidth": 1
}
},
{
"name": "Charges de personnel\n8000 €",
"value": 8000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Salariés",
"value": 8000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#FDCF74",
"borderWidth": 1
}
},
{
"name": "Soldes de gestion\n190760 €",
"value": 190760,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Prélèvements privés",
"value": 50000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Annuité de remboursement",
"value": 40000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Frais financiers",
"value": 10000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "EBE total",
"value": 90760,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F8B26D",
"borderWidth": 1
}
}
]
}
},
"2020": {
"Produits": {
"name": "Produits 2020\n468000 €",
"value": 468000,
"type": "treemap",
"breadcrumb": {
"height": 34,
"itemStyle": {
"textStyle": {
"lineHeight": 15
}
}
},
"data": [
{
"name": "Chiffre d'affaire\n361000 €",
"value": 361000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Vente de produits végétaux",
"value": 361000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#afd095",
"borderWidth": 1
}
},
{
"name": "Aides\n107000 €",
"value": 107000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Subventions",
"value": 30000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "DPU, DPB",
"value": 49000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Aides",
"value": 25000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Aide à la certification",
"value": 3000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#729fcf",
"borderWidth": 1
}
}
]
},
"Charges": {
"name": "Charges 2020\n518000 €",
"value": 518000,
"type": "treemap",
"breadcrumb": {
"height": 34,
"itemStyle": {
"textStyle": {
"lineHeight": 15
}
}
},
"data": [
{
"name": "Charges opérationnelles\n85760 €",
"value": 85760,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Semences et plants",
"value": 18080,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Fertilisation",
"value": 30880,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Produits de traitements",
"value": 28320,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Travaux par tiers",
"value": 8480,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F28960",
"borderWidth": 1
}
},
{
"name": "Charges de structure\n233720 €",
"value": 233720,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Carburant",
"value": 9120,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Entretien matériel",
"value": 21600,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Eau, gaz, électricité",
"value": 2000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Frais de gestion",
"value": 8000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Fermage",
"value": 42000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Assurances",
"value": 32000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Autres",
"value": 119000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F5A893",
"borderWidth": 1
}
},
{
"name": "Charges de personnel\n7000 €",
"value": 7000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Salariés",
"value": 7000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#FDCF74",
"borderWidth": 1
}
},
{
"name": "Soldes de gestion\n191520 €",
"value": 191520,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Prélèvements privés",
"value": 50000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "EBE total",
"value": 141520,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F8B26D",
"borderWidth": 1
}
}
]
}
},
"2021": {
"Produits": {
"name": "Produits 2021\n583000 €",
"value": 583000,
"type": "treemap",
"breadcrumb": {
"height": 34,
"itemStyle": {
"textStyle": {
"lineHeight": 15
}
}
},
"data": [
{
"name": "Chiffre d'affaire\n528000 €",
"value": 528000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Vente de produits végétaux",
"value": 528000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#afd095",
"borderWidth": 1
}
},
{
"name": "Aides\n55000 €",
"value": 55000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "DPU, DPB",
"value": 52000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Aide à la certification",
"value": 3000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#729fcf",
"borderWidth": 1
}
}
]
},
"Charges": {
"name": "Charges 2021\n633000 €",
"value": 633000,
"type": "treemap",
"breadcrumb": {
"height": 34,
"itemStyle": {
"textStyle": {
"lineHeight": 15
}
}
},
"data": [
{
"name": "Charges opérationnelles\n96800 €",
"value": 96800,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Semences et plants",
"value": 20160,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Fertilisation",
"value": 27840,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Produits de traitements",
"value": 39040,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Travaux par tiers",
"value": 9760,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F28960",
"borderWidth": 1
}
},
{
"name": "Charges de structure\n272000 €",
"value": 272000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Carburant",
"value": 10560,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Entretien matériel",
"value": 34880,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Eau, gaz, électricité",
"value": 2300,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Frais de gestion",
"value": 11000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Fermage",
"value": 47360,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Assurances",
"value": 30720,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Autres",
"value": 135180,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F5A893",
"borderWidth": 1
}
},
{
"name": "Charges de personnel\n16000 €",
"value": 16000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Salariés",
"value": 16000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#FDCF74",
"borderWidth": 1
}
},
{
"name": "Soldes de gestion\n248200 €",
"value": 248200,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Prélèvements privés",
"value": 50000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "EBE total",
"value": 198200,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F8B26D",
"borderWidth": 1
}
}
]
}
},
"2022": {
"Produits": {
"name": "Produits 2022\n661000 €",
"value": 661000,
"type": "treemap",
"breadcrumb": {
"height": 34,
"itemStyle": {
"textStyle": {
"lineHeight": 15
}
}
},
"data": [
{
"name": "Chiffre d'affaire\n598000 €",
"value": 598000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Vente de produits végétaux",
"value": 598000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#afd095",
"borderWidth": 1
}
},
{
"name": "Aides\n63000 €",
"value": 63000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "DPU, DPB",
"value": 60000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Aide à la certification",
"value": 3000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#729fcf",
"borderWidth": 1
}
}
]
},
"Charges": {
"name": "Charges 2022\n711000 €",
"value": 711000,
"type": "treemap",
"breadcrumb": {
"height": 34,
"itemStyle": {
"textStyle": {
"lineHeight": 15
}
}
},
"data": [
{
"name": "Charges opérationnelles\n118720 €",
"value": 118720,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Semences et plants",
"value": 27200,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Fertilisation",
"value": 44480,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Produits de traitements",
"value": 37440,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Travaux par tiers",
"value": 9600,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F28960",
"borderWidth": 1
}
},
{
"name": "Charges de structure\n279360 €",
"value": 279360,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Carburant",
"value": 10560,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Entretien matériel",
"value": 19200,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Eau, gaz, électricité",
"value": 9000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Frais de gestion",
"value": 98000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Fermage",
"value": 39680,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Assurances",
"value": 17920,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "Autres",
"value": 85000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F5A893",
"borderWidth": 1
}
},
{
"name": "Charges de personnel\n20000 €",
"value": 20000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Salariés",
"value": 20000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#FDCF74",
"borderWidth": 1
}
},
{
"name": "Soldes de gestion\n292920 €",
"value": 292920,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": [
{
"name": "Prélèvements privés",
"value": 50000,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
},
{
"name": "EBE total",
"value": 242920,
"label": {
"show": true,
"position": "inside",
"overflow": "break"
},
"children": []
}
],
"itemStyle": {
"color": "#F8B26D",
"borderWidth": 1
}
}
]
}
}
}Histogramme
Ce graphique permet d'afficher un histogramme simple tel que celui ci-dessous. Les colonnes peuvent être typiquement des années mais peuvent aussi être n'importe quoi d'autre.
Radar
Un radar avec un nombre quelconque de branches. On peut y mettre une moyenne pour comparer avec des résultats d'un groupe de fermes par exemple. Les max de chaque branche peuvent ne pas être tous les mêmes.
Le radar, ainsi que tous les autres graphiques, peut être calé à droite, à gauche, ou bien centré dans la page.
Rotation
Un graph pour afficher une rotation. Chaque élément de la rotation se prolonge sur un nombre de mois donné, et on peut préciser tout élément complémentaire en commentaire (au passage de la souris ou en cliquant dessus sur mobile). Comme sur chaque graph, les couleurs sont choisies directement dans Google Spreadsheet™.
Assolement
L'assolement permet de montrer comment la surface utile de l'agriculteur est répartie entre ses différentes productions à un instant T.
Analyse environnementale et analyse socio-économique
option = {
legend: {
},
radar: {
radius: '60%',
center : ['50%', '60%'],
indicator: [
{ name: 'Satisfaction\néconomique', max: 10 }, { name: 'Satisfaction\nsociale', max: 10 }, { name: 'Cadre\nde vie', max: 10 }, { name: 'Coopération', max: 10 }, { name: 'Efficacité\ntemps de travail', max: 50 }, { name: 'EBE/UTH', max: 60000 }, { name: 'Confort\nau travail', max: 10 },
]
},
series: [
{
type: 'radar',
data: [
{
value: [
10, 10, 9, 2, 30, 24264, 8,
],
name: "Nom de la ferme",
emphasis: { label: { show: true } },
itemStyle: {width : 3, color: "#f1894c" },
lineStyle: {width : 3, color: "#f1894c" },
areaStyle: {color: "#f1894c" }
}
,{
value: [
7, 8, 8, 0, 12, 13545, 7,
],
name: 'Moyenne',
emphasis: { title: { show: true }, label: { show: true } },
lineStyle: {width : 3}
}
] } ]};
Ces radars permettent d'afficher les données qu'on retrouve dans les portraits MSV par exemple.
Capacité d'autoproduction
option = {
title: {
text: "Part produite sur place (en % du total)"
},
legend: {
top: "20"
},
grid: {
containLabel: true
},
xAxis: [
{
type: 'value',
min: 0,
max: 100,
}
],
yAxis: [
{
type: 'category',
data: ["MO", "Légumes", "Plants", "Semences"],
}
],
series: [
{
name: "Nom de la ferme",
emphasis: { label: {show: true, formatter: '{a} : {c}%'} },
type: 'bar',
data: [10, 100, 90, 3]
},
{
name: 'Moyenne',
type: 'bar',
emphasis: { label: {show: true, formatter: '{a} : {c}%'} },
itemStyle: {
normal: {
color: '#ddd'
}
},
data: [19 , 85 , 72 , 7 ]
}
]
};
Ce graphique permet d'afficher la capacité d'autoproduction de la ferme sur certains aspects (utilisé en particulier dans les portraits de ferme).
Stratégie commerciale
option = {
tooltip: {
trigger: 'item',
formatter: '{b} : {d}%'
},
legend: {
orient: 'vertical',
left: 'left',
top: 'center'
},
series: [
{
type: 'pie',
radius: ['40%', '70%'],
center: ['65%', '50%'],
label: {
show: true,
position: 'inside'
},
data: [
{ name: "Paniers", value: 20 },
{ name: "AMAP", value: 30 },
{ name: "Vente à la ferme", value: 23 },
{ name: "Grossiste", value: 17 },
{ name: "GMS", value: 10 },
{ name: "Autres", value: -2.220446049250313e-14 },
]
}
]
};Ce camembert permet de comprendre la part du revenu de la ferme en fonction des différents canaux de vente.
Fleur de l'agroécologie
La fleur de l'agroécologie est un indicateur développé par Fermes d'Avenir.
Questions fréquentes
- J'ai modifié le graphique et je l'ai resynchronisé, mais il reste inchangé dans Triple Performance ?
- Le graphique précédent a été mis en cache (pour une question de performance). Rendez-vous dans le menu à droite de la page et sélectionnez "Purger la page".
- Dans le graphique de rotation, je n'arrive pas à revenir à la ligne dans les cellules de commentaires !
- Il suffit de cliquer Ctrl-Entrée pour passer à la ligne au sein d'une cellule. Vous pouvez aussi mettre du gras, de l'italique, etc... avec les raccourcis claviers : Ctrl-b, Ctrl-i, ...
- J'ai modifié le titre de ma page Triple Performance, faut-il aussi changer le nom dans l'onglet "Données générales" ?
- Oui, le nom en face de "Nom de la page Triple Performance" doit toujours correspondre au titre de la page Triple Performance
- Est-ce que je peux ajouter d'autres textes dans l'onglet "Données générales" ?
- Oui, l'important c'est que quelque part dans l'onglet, on ait les deux cellules dans la colonne A "Nom de la page Triple Performance" et B avec le titre de votre page.
- J'essaie de synchroniser un graphique X ou Y, mais il ne s'affiche pas dans Triple Performance
- Vérifiez que vous n'avez pas modifié des textes nécessaires à l'Add-on pour s'y retrouver... En particulier, l'Add-on va chercher la ligne avec écrit "Graphique" et le type de graphique dans la cellule qui suit. C'est ainsi qu'il reconnait tel ou tel type de graphique. Si vous modifiez ce texte la synchronisation n'est plus possible. Il en est de même avec les textes "Fin du graphique", etc... Le cas échéant, ajoutez un nouveau graphique du même type en cliquant sur le bouton correspondant, et reportez les valeurs une à une pour comprendre à quel moment ça cesse de fonctionner !
- Dans le graphique du bilan économique, est-ce qu'il est possible d'ajouter d'autres champs (par exemple dépenses kmtriques, etc..) ?
- Non malheureusement, tous les champs gérés par ce graphique sont affichés par défaut quand vous ajoutez le graphe à votre Spreadsheet. Vous pouvez supprimer les lignes qui sont inutiles mais vous ne pouvez pas en créer de nouvelles. Il en va de même pour les radars d'analyse, la capacité d'autoproduction et la stratégie commerciale. Si vous voyez des champs qui seraient intéressants d'ajouter, contactez-nous !
- J'ai un problème qui n'est pas dans la liste ?
- Pas de soucis, on est réactifs. Le mieux est de vous rendre sur Slack et de nous poser la question directement !
