« Test » : différence entre les versions

De 21Wiki
Aucun résumé des modifications
Aucun résumé des modifications
Ligne 1 : Ligne 1 :
<graph>{
<graph>{
    "$schema": "https://vega.github.io/schema/vega/v5.json",
  "width": 800,
"width": 1200,
  "height": 400,
"height": 1200,
  "data": [
"data": [
    {
{
      "name": "membres",
"name": "membres",
      "transform": [
"transform": [
        {
{
          "type": "formula",
"type": "formula",
          "field": "membre_end",
"as": "membre_end",
          "expr": "datum.membre_end ? datum.membre_end : datetime(year(now()) + '/' + (month(now())+1) + '/' + date(now()))"
"expr": "datum.membre_end ? datum.membre_end : datetime(year(now()) + '/' + (month(now())+1) + '/' + date(now()))"
        }
}
      ],
],
      "format": {
"format": {
        "type": "json",
"type": "json",
        "parse": {
"format": {"parse": {"membre_start": "date", "membre_end": "date"}}
          "membre_start": "date:\"%Y-%m-%d\"",
}
          "membre_end": "date:\"%Y-%m-%d\""
},
        }
"values": [
      },
{"label": "esteban","nom": "Esteban Vidal","membre_start": "2021-10-22","membre_end": "2022-02-12","status": "✈️"},
      "values": [
{"label": "esteban","membre_start": "2022-07-18","membre_end": "2022-09-21","status": "✈️"},
        {"label": "aelis", "nom": "Aelis Fleeks", "membre_start": "2021-09-24", "membre_end": "2021-12-04", "status": ""},
{"label": "kyle","nom": "Kyle Hood","membre_start": "2021-10-22","membre_end": "2022-03-10","status": "✈️"},
        {"label": "abraham", "nom": "Abraham Jackson", "membre_start": "2021-09-24", "membre_end": "2021-12-04", "status": ""},
{"label": "aaron","nom": "Aaron Perret","membre_start": "2021-10-22","membre_end": "2022-03-29","status": "🚪"},
        {"label": "memphis", "nom": "Memphis Owens", "membre_start": "2021-09-24", "membre_end": "2021-12-04", "status": ""},
{"label": "willyam","nom": "Willyam Da Costa","membre_start": "2021-11-09","membre_end": "2022-07-15","status": "✈️"},
        {"label": "karl", "nom": "Karl Zakharovich", "membre_start": "2021-09-25", "membre_end": "2021-12-04", "status": ""},
{"label": "magdalena","nom": "Magdalena Carlson","membre_start": "2021-11-10","membre_end": "2022-09-23","status": "⚰️"},
        {"label": "rutgerus", "nom": "Rutgerus von der Woerth", "membre_start": "2021-10-03", "membre_end": "2021-12-04", "status": ""},
{"label": "Liam","nom": "Liam «Django» Newt","membre_start": "2021-11-11","membre_end": "2022-05-13","status": "✈️"},
        {"label": "james", "nom": "James While", "membre_start": "2021-10-28", "membre_end": "2021-12-04", "status": ""},
{"label": "louis","nom": "Louis «Léo» Léonard ","membre_start": "2021-11-22","membre_end": "2022-01-01","status": "✈️"},
        {"label": "kara", "nom": "Kara Dawson", "membre_start": "2021-10-30", "membre_end": "2021-11-04", "status": "📢"},
{"label": "livio","nom": "Livio «Tito» Agnelli","membre_start": "2021-11-24","membre_end": "2022-09-21","status": "✈️"},
        {"label": "leo", "nom": "Léo Serval", "membre_start": "2021-11-08", "membre_end": "2021-12-04", "status": ""},
{"label": "kenny","nom": "Kenny Tomasino","membre_start": "2022-01-11","membre_end": "2022-11-24","status": "✈️"},
        {"label": "gabriel", "nom": "Gabriel Deans", "membre_start": "2021-11-08", "membre_end": "2021-12-04", "status": ""}
{"label": "ethan","nom": "Ethan Brawn","membre_start": "2022-01-11","membre_end": "2022-10-30","status": "✈️"},
      ]
{"label": "scott","nom": "Scott «Hantu» Elvene","membre_start": "2022-02-25","membre_end": "2022-03-10","status": "🚪"},
    },
{"label": "morel","nom": "Django Morel","membre_start": "2022-03-01","membre_end": "2022-11-07","status": "✈️"},
    {
{
      "name": "seconds",
"label": "samuel",
      "transform": [
"nom": "Samuel Roes",
        {
"membre_start": "2022-03-11",
          "type": "formula",
"membre_end": null,
          "field": "second_end",
"status": null
          "expr": "datum.second_end ? datum.second_end : datetime(year(now()) + '/' + (month(now())+1) + '/' + date(now()))"
},
        }
{"label": "aaronn","nom": "Aaronn Davis","membre_start": "2022-04-10","membre_end": "2022-11-09","status": "⚰️"},
      ],
{"label": "tyo","nom": "Tyo Watanabe","membre_start": "2022-04-13","membre_end": "2022-07-01","status": "✈️"},
      "format": {
{"label": "john","nom": "John Blue","membre_start": "2022-06-03","membre_end": "2022-09-15","status": "✈️"},
        "type": "json",
{"label": "fox","nom": "Aaron «Fox» Foxwell","membre_start": "2022-06-06","membre_end": "2022-11-24","status": "✈️"},
        "parse": {
{"label": "lance","nom": "Lance Tyler","membre_start": "2022-06-06","membre_end": "2022-11-07","status": "✈️"},
          "second_start": "date:\"%Y-%m-%d\"",
{"label": "manuel","nom": "Manuel Almeira","membre_start": "2022-07-18","membre_end": "2024-05-10","status": "✈️"},
          "second_end": "date:\"%Y-%m-%d\""
{"label": "mateo","nom": "Mateo Ortega","membre_start": "2022-09-19","membre_end": "2023-06-16","status": "✈️"},
        }
{"label": "dereck","nom": "Dereck Parks","membre_start": "2022-09-29","membre_end": "2023-07-04","status": "✈️"},
      },
{"label": "Scott","nom": "Scott Payne","membre_start": "2022-10-29","membre_end": "2023-10-23","status": "⚰️"},
      "values": [
{"label": "Louka","nom": "Louka Moretti","membre_start": "2022-10-29","membre_end": "2022-11-10","status": "✈️"},
        {"label": "abraham", "second_start": "2021-09-24", "second_end": "2021-12-04"}
{"label": "Al","nom": "Alarik Collet","membre_start": "2022-11-24","membre_end": "2024-09-01","status": "⚰️"},
      ]
{"label": "William","nom": "William Lexer","membre_start": "2022-11-24","membre_end": "2024-06-04","status":"✈️"},
    },
{"label": "Jason","nom": "Jason Munez","membre_start": "2022-11-24","membre_end": "2024-02-28","status": "✈️"},
    {
{"label": "Jessy","nom": "Jessy Arturo","membre_start": "2022-12-11","membre_end": "2024-04-23","status": "⚰️"},
      "name": "chefs",
{"label": "Squall","nom": "Squall Breizh","membre_start": "2022-12-11","membre_end": "2023-06-23","status": "⚰️"},
      "transform": [
{"label": "sam","nom": "Sam Bridge","membre_start": "2023-01-09","membre_end": "2023-10-01","status": "⚰️"},
        {
{"label": "skadela","nom": "Skadela Rorick","membre_start": "2023-01-09","membre_end": "2023-06-23","status": "⚰️"},
          "type": "formula",
{"label": "lino","nom": "Lino Morales","membre_start": "2023-06-25","membre_end": "2024-02-16","status": "⚰️"},
          "field": "chef_end",
{
          "expr": "datum.chef_end ? datum.chef_end : datetime(year(now()) + '/' + (month(now())+1) + '/' + date(now()))"
"label": "shaw",
        }
"nom": "Shaw Santos",
      ],
"membre_start": "2023-07-05",
      "format": {
"membre_end": null,
        "type": "json",
"status": null
        "parse": {
},
          "chef_start": "date:\"%Y-%m-%d\"",
{"label": "lia","nom": "Lia Arrah","membre_start": "2023-07-19","membre_end":"2024-05-30","status": "✈️"},
          "chef_end": "date:\"%Y-%m-%d\""
{"label": "ari","nom": "Ari Te Kahurangi","membre_start": "2023-08-03","membre_end": "2024-05-06","status": "✈️"},
        }
{"label": "luc","nom": "Luc Hart","membre_start": "2023-11-09","membre_end": "2024-12-25","status": "✈️"},
      },
            {"label": "seth","nom": "Seth Butler","membre_start": "2024-02-14","membre_end": "2024-05-10","status": "✈️"},
      "values": [
                {"label": "jake","nom": "Jake Mathers","membre_start": "2024-02-28","membre_end": "2024-04-23","status": "✈️"},
        {"label": "aelis", "chef_start": "2021-09-24", "chef_end": "2021-12-04"}
                {
      ]
"label": "azul",
    },
"nom": "Manuel Azul",
    {
"membre_start": "2024-03-20",
      "name": "events",
"membre_end": null,
      "format": {
"status": null
        "type": "json",
},
        "parse": {
                {
          "date": "date:\"%Y-%m-%d\""
"label": "javier",
        }
"nom": "Javier Castillo Fernandez",
      },
"membre_start": "2024-04-23",
      "values": [
"membre_end": null,
        {"name": "24/09 - Création du groupe", "date": "2021-09-24", "y": -20},
"status": null
        {"name": "04/12 - Dissolution du groupe", "date": "2021-12-04", "y": -20}
},
      ]
                {"label": "clay","nom": "Clarence Pearce","membre_start": "2024-04-23","membre_end": "2024-06-29","status": "✈️"},
    }
                {"label": "thomas","nom": "Thomas Holsen","membre_start": "2024-05-16","membre_end": "2024-09-03","status": "✈️"},
  ],
                {
  "scales": [
"label": "jenna",
    {
"nom": "Jenna Aguilar",
      "name": "y",
"membre_start": "2024-05-31",
      "type": "ordinal",
"membre_end": null,
      "range": "height",
"status": null
      "domain": {"data": "membres", "field": "label"}
},
    },
                {"label": "sacha_mat","nom": "Sacha Mat","membre_start": "2024-06-28","membre_end": "2024-11-15","status": "⚰️"},
    {
                {"label": "ivy","nom": "Ivy Wood","membre_start": "2024-07-08","membre_end": "2025-02-05","status": "✈️"},
      "name": "x",
                {
      "type": "time",
"label": "finn",
      "range": "width",
"nom": "Scott Odafinn",
      "nice": "week",
"membre_start": "2024-08-08",
      "domain": {
"membre_end": null,
        "data": "membres",
"status": null
        "field": ["membre_start", "membre_end"]
},
      }
                {
    }
"label": "liam",
  ],
"nom": "Liam Shaw",
  "axes": [
"membre_start": "2024-09-25",
    {
"membre_end": null,
      "type": "x",
"status": null
      "scale": "x",
},
      "grid": true,
                {
      "format": "%m/%y"
"label": "jimmy",
    }
"nom": "Jimmy Wade",
  ],
"membre_start": "2024-09-25",
  "marks": [
"membre_end": null,
    {
"status": null
      "type": "text",
},
      "from": {"data": "events"},
                {
      "properties": {
"label": "e_curtis",
        "enter": {
"nom": "Ethan Curtis",
          "x": {"scale": "x", "field": "date"},
"membre_start": "2024-11-21",
          "y": {"field": "y"},
"membre_end": null,
          "angle": {"value": -30},
"status": null
          "fill": {"value": "#000"},
}
          "text": {"field": "name"},
]
          "fontSize": {"value": 14}
},
        }
{
      }
"name": "troisieme",
    },
"transform": [
    {
{
      "type": "rect",
"type": "formula",
      "from": {"data": "events"},
"as": "troisieme_end",
      "properties": {
"expr": "datum.troisieme_end ? datum.troisieme_end : datetime(year(now()) + '/' + (month(now())+1) + '/' + date(now()))"
        "enter": {
}
          "x": {"scale": "x", "field": "date"},
],
          "y": {"field": "y"},
"format": {
          "width": {"value": 0.5},
"type": "json",
          "height": {"field": {"group": "height"}, "offset": 20},
"parse": {
          "fill": {"value": "#0090FF"}
"troisieme_start": "date:\"%Y-%m-%d\"",
        }
"troisieme_end": "date:\"%Y-%m-%d\""
      }
}
    },
},
    {
"values": [
      "type": "text",
{"label": "aaron","troisieme_start": "2021-10-22","troisieme_end": "2022-02-12"},
      "from": {"data": "membres"},
{"label": "livio","troisieme_start": "2022-04-10","troisieme_end": "2022-07-18"},
      "properties": {
{"label": "esteban","troisieme_start": "2022-08-07","troisieme_end": "2022-09-21"},
        "enter": {
{"label": "magdalena","troisieme_start": "2022-08-07","troisieme_end": "2022-09-23"},
          "x": {"scale": "x", "field": "membre_end", "offset": -2},
{"label": "samuel","troisieme_start": "2022-08-07","troisieme_end": "2022-10-30"},
          "y": {"scale": "y", "field": "label", "offset": 6},
{"label": "manuel","troisieme_start": "2022-10-22","troisieme_end": "2022-11-24"},
          "fill": {"value": "#000"},
{"label": "dereck","troisieme_start": "2022-11-24","troisieme_end": "2023-07-04"},
          "text": {"field": "status"},
{"label": "shaw","troisieme_start": "2024-05-25","troisieme_end": "2024-09-25"},
          "fontSize": {"value": 14}
{"label": "luc","troisieme_start": "2024-05-25","troisieme_end": null},
        }
{"label": "azul","troisieme_start": "2024-05-25","troisieme_end": null}
      }
]
    },
},
    {
{
      "type": "rect",
"name": "seconds",
      "from": {"data": "chefs"},
"transform": [
      "properties": {
{
        "enter": {
"type": "formula",
          "x": {"scale": "x", "field": "chef_start"},
"as": "second_end",
          "x2": {"scale": "x", "field": "chef_end"},
"expr": "datum.second_end ? datum.second_end : datetime(year(now()) + '/' + (month(now())+1) + '/' + date(now()))"
          "y": {"scale": "y", "field": "label", "offset": -3},
}
          "height": {"value": 9},
],
          "fill": {"value": "#000000"}
"format": {
        }
"type": "json",
      }
"parse": {
    },
"second_start": "date:\"%Y-%m-%d\"",
    {
"second_end": "date:\"%Y-%m-%d\""
      "type": "rect",
}
      "from": {"data": "seconds"},
},
      "properties": {
"values": [
        "enter": {
{"label": "kyle","second_start": "2021-10-22","second_end": "2022-02-12"},
          "x": {"scale": "x", "field": "second_start"},
{"label": "aaron","second_start": "2022-02-12","second_end": "2022-03-10"},
          "x2": {"scale": "x", "field": "second_end"},
{"label": "magdalena","second_start": "2022-03-10","second_end": "2022-03-19"},
          "y": {"scale": "y", "field": "label", "offset": -3},
{"label": "willyam","second_start": "2022-03-19","second_end": "2022-04-01"},
          "height": {"value": 10},
{"label": "kenny","second_start": "2022-04-10","second_end": "2022-07-18"},
          "fill": {"value": "#999"}
{"label": "ethan","second_start": "2022-07-18","second_end": "2022-10-30"},
        }
{"label": "samuel","second_start": "2022-10-30","second_end": "2022-11-24"},
      }
{"label": "manuel","second_start": "2022-11-24","second_end": "2023-04-15"},
    },
{"label": "samuel","second_start": "2023-04-15","second_end": "2024-04-23"},
    {
                {"label": "Al","second_start": "2024-04-23","second_end":"2024-09-01"},
      "type": "rect",
{"label": "shaw","second_start": "2024-09-25","second_end": "2024-10-30"},
      "from": {"data": "membres"},
{"label": "azul","second_start": "2024-10-30","second_end": null}
      "properties": {
]
        "enter": {
},
          "x": {"scale": "x", "field": "membre_start"},
{
          "x2": {"scale": "x", "field": "membre_end"},
"name": "chefs",
          "y": {"scale": "y", "field": "label"},
"transform": [
          "height": {"value": 4},
{
          "fill": {"value": "#880000"}
"type": "formula",
        }
"as": "chef_end",
      }
"expr": "datum.chef_end ? datum.chef_end : datetime(year(now()) + '/' + (month(now())+1) + '/' + date(now()))"
    },
}
    {
],
      "type": "text",
"format": {
      "from": {"data": "membres"},
"type": "json",
      "properties": {
"parse": {
        "enter": {
"chef_start": "date:\"%Y-%m-%d\"",
          "x": {"scale": "x", "field": "membre_start"},
"chef_end": "date:\"%Y-%m-%d\""
          "y": {"scale": "y", "field": "label", "offset": -7},
}
          "fill": {"value": "#000"},
},
          "text": {"field": "nom"},
"values": [
          "fontSize": {"value": 14}
{"label": "esteban","chef_start": "2021-10-22","chef_end": "2022-02-12"},
        }
{"label": "kyle","chef_start": "2022-02-12","chef_end": "2022-03-10"},
      }
{"label": "Liam","chef_start": "2022-03-10","chef_end": "2022-04-01"},
    }
{"label": "willyam","chef_start": "2022-04-01","chef_end": "2022-07-15"},
  ]
{"label": "kenny","chef_start": "2022-07-18","chef_end": "2022-11-24"},
}
{"label": "samuel","chef_start": "2022-11-24","chef_end": "2023-04-15"},
</graph>
{"label": "manuel","chef_start": "2023-04-15","chef_end": "2024-05-10"},
{"label": "samuel","chef_start": "2024-05-10","chef_end": null}
]
},
{
"name": "events",
"format": {
"type": "json",
"parse": {"date": "date:\"%Y-%m-%d\""}
},
"values": [
{"name": "22/10 - Création du groupe","date": "2021-10-22","y": -95},
{"name": "18/11 - Paiement du tribut à la Mano","date": "2021-11-18","y": -95},
{"name": "09/12 - Début de The Run","date": "2021-12-09","y": -90},
{"name": "23/12 - Fin de The Run","date": "2021-12-23","y": -80},
{"name": "25/02 - Course de vols de voitures","date": "2022-02-25","y": -100},
{"name": "07/04 - Guerre avec les Wave","date": "2022-04-07","y": -110},
{"name": "13/05 - Premier braquage de Banque","date": "2022-05-13","y": -110},
{"name": "16/05 - Business de drogue","date": "2022-05-16","y": -90},
{"name": "30/05 - Blanchiment et Trafic de faux papiers","date": "2022-05-30","y": -80},
{"name": "04/07 - Début de la cavale de Willyam","date": "2022-07-04","y": -80},
{"name": "24/07 - Recel et Trafic de faux papiers","date": "2022-07-24","y": -75},
{"name": "27/07 - Guerre avec les Ballas","date": "2022-07-27","y": -60},
{"name": "24/08 - Meurtre du Lieutenant Green","date": "2022-08-24","y": -60},
{"name": "31/08 - Perte du business","date": "2022-08-31","y": -45},
{"name": "31/08 - Drogues","date": "2022-09-13","y": -35},
{"name": "26/10 - Braquage de la Pacific","date": "2022-10-26","y": -40},
{"name": "03/11 - Recel de véhicules","date": "2022-11-03","y": -30},
{"name": "24/11 - Fusion avec les Marabuntas","date": "2022-11-24","y": -25},
{"name": "31/01 - Drogues","date": "2023-01-31","y": -45},
{"name": "20/02 - Course Recel Patriots","date": "2023-02-20","y": -40},
{"name": "24/02 - Bizz Recel / Faussaire","date": "2023-02-20","y": -20},
{"name": "27/03 - Chasse MM's et mort de Mike","date": "2023-03-27","y": -20},
{"name": "30/05 - Course aux champignons","date": "2023-05-30","y": -20},
{"name": "27/06 - Bizz Pillage","date": "2023-06-27","y": -20},
                {"name": "28/03 - Perte du business","date": "2024-03-28","y": -20},
                {"name": "17/04 - Drogue","date": "2024-04-17","y": -20},
                {"name": "05/09 - Armes","date": "2024-09-05","y": -20},
                {"name": "18/11 - Guerre avec la Mano","date": "2024-11-18","y": -10},
                {"name": "28/11 - Drogue","date": "2024-11-28","y": -20}
]
},
{
"name": "annee",
"format": {
"type": "json",
"parse": {"date": "date:\"%Y-%m-%d\""}
},
"values": [
{"name": "2022","date": "2022-01-01"},
{"name": "2023","date": "2023-01-01"},
{"name": "2024","date": "2024-01-01"}
]
}
],
"scales": [
{
"name": "y",
"type": "ordinal",
"range": "height",
"domain": {"data": "membres","field": "label"}
},
{
"name": "x",
"type": "time",
"range": "width",
"round": false,
"nice": "month",
"domain": {
"data": "membres",
"as": ["membre_start","membre_end"]
}
}
],
"axes": [
{
"type": "x",
"scale": "x",
"grid": true,
"format": "%m/%y"
}
],
"marks": [
{
"type": "text",
"from": {"data": "events"},
"encode": {
"enter": {
"x": {"scale": "x","field": "date"},
"y": {"field": "y"},
"angle": {"value": -30},
"fill": {"value": "#000"},
"text": {"field": "name"},
"fontSize": {"value": 14}
}
}
},
{
"type": "rect",
"from": {"data": "events"},
"encode": {
"enter": {
"x": {"scale": "x","field": "date"},
"y": {"field": "y"},
"width": {"value": 0.5},
"height": {"field": {"group": "height"},"offset": 20},
"fill": {"value": "#0090FF"}
}
}
},
{
"type": "rect",
"from": {"data": "events"},
"encode": {
"enter": {
"x": {"scale": "x","field": "date"},
"y": {"value": -20},
"width": {"value": 0.5},
"height": {"field": {"group": "height"},"offset": 20},
"fill": {"value": "#0090FF"}
}
}
},
{
"type": "text",
"from": {"data": "membres"},
"encode": {
"enter": {
"x": {"scale": "x","field": "membre_end","offset": -2},
"y": {"scale": "y","field": "label","offset": 6},
"fill": {"value": "#000"},
"text": {"field": "status"},
"fontSize": {"value": 14}
}
}
},
{
"type": "rect",
"from": {"data": "chefs"},
"encode": {
"enter": {
"x": {"scale": "x","field": "chef_start"},
"x2": {"scale": "x","field": "chef_end"},
"y": {"scale": "y","field": "label","offset": -3},
"height": {"value": 9},
"fill": {"value": "#000"}
}
}
},
{
"type": "rect",
"from": {"data": "seconds"},
"encode": {
"enter": {
"x": {"scale": "x","field": "second_start"},
"x2": {"scale": "x","field": "second_end"},
"y": {"scale": "y","field": "label","offset": -3},
"height": {"value": 10},
"fill": {"value": "#999"}
}
}
},
{
"type": "rect",
"from": {"data": "troisieme"},
"encode": {
"enter": {
"x": {"scale": "x","field": "troisieme_start"},
"x2": {"scale": "x","field": "troisieme_end"},
"y": {"scale": "y","field": "label","offset": -1.5},
"height": {"value": 7},
"fill": {"value": "#cccccc"}
}
}
},
{
"type": "rect",
"from": {"data": "membres"},
"encode": {
"enter": {
"x": {"scale": "x","field": "membre_start"},
"x2": {"scale": "x","field": "membre_end"},
"y": {"scale": "y","field": "label"},
"height": {"value": 4},
"fill": {"value": "#00fff0"}
}
}
},
{
"type": "text",
"from": {"data": "membres"},
"encode": {
"enter": {
"x": {"scale": "x","field": "membre_start"},
"y": {"scale": "y","field": "label","offset": -7},
"fill": {"value": "#000"},
"text": {"field": "nom"},
"fontSize": {"value": 14}
}
}
},
{
"type": "text",
"from": {"data": "annee"},
"encode": {
"enter": {
"x": {"scale": "x","field": "date"},
"y": {"value": -5},
"angle": {"value": 0},
"fill": {"value": "#FF0000"},
"text": {"field": "name"},
"fontSize": {"value": 20}
}
}
},
{
"type": "rect",
"from": {"data": "annee"},
"encode": {
"enter": {
"x": {"scale": "x","field": "date"},
"y": {"value": -5},
"width": {"value": 0.5},
"height": {"field": {"group": "height"},"offset": 5},
"fill": {"value": "#FF0000"}
}
}
}
]
}</graph>

Version du 25 avril 2025 à 14:38