|
|
| (94 versions intermédiaires par 2 utilisateurs non affichées) |
| Ligne 1 : |
Ligne 1 : |
| <graph mode="interactive">
| | |
| {
| |
| "$schema": "https://vega.github.io/schema/vega/v5.json",
| |
| "width": 1200,
| |
| "height": 700,
| |
| "data": [
| |
| {
| |
| "name": "membres",
| |
| "values": [
| |
| {"label": "paul","nom": "Paul Malone","membre_start": "2022-04-20","membre_end": "2022-07-29","status": "✈️"},
| |
| {"label": "carmelo","nom": "Carmelo Riina","membre_start": "2022-04-20","membre_end": "2022-07-29","status": "✈️"},
| |
| {"label": "kenny","nom": "Kenny Gringeman","membre_start": "2022-04-20","membre_end": "2023-02-26","status": "⚰️"},
| |
| {"label": "allan","nom": "Allan Fraser","membre_start": "2022-04-20","membre_end": "2023-08-05","status": "❌"},
| |
| {"label": "bryan","nom": "Bryan Colman","membre_start": "2022-04-20","membre_end": "2023-08-05","status": "❌"},
| |
| {"label": "wyatt","nom": "Wyatt Wright","membre_start": "2022-04-21","membre_end": "2023-08-05","status": "❌"},
| |
| {"label": "vince","nom": "Vince Hamilton","membre_start": "2022-07-29","membre_end": "2023-07-11","status": "✈️"},
| |
| {"label": "john","nom": "John Fritz","membre_start": "2022-07-29","membre_end": "2022-09-30","status": "⚰️"},
| |
| {"label": "calvin","nom": "Calvin Anderson","membre_start": "2022-08-15","membre_end": "2022-12-14","status": "⚰️"},
| |
| {"label": "freya","nom": "Freya Shanks","membre_start": "2022-08-15","membre_end": "2023-01-29","status": "🚪"},
| |
| {"label": "james","nom": "James Heller","membre_start": "2022-09-10","membre_end": "2022-12-14","status": "⚰️"},
| |
| {"label": "luz","nom": "Luz Brown","membre_start": "2022-09-27","membre_end": "2023-07-11","status": "✈️"},
| |
| {"label": "albert","nom": "Albert Chellin","membre_start": "2022-12-16","membre_end": "2023-08-05","status": "❌"},
| |
| {"label": "christopher","nom": "Christopher Johnson","membre_start": "2022-12-22","membre_end": "2023-08-05","status": "❌"},
| |
| {"label": "gwendal","nom": "Gwendal Griffin","membre_start": "2022-12-22","membre_end": "2023-08-05","status": "❌"},
| |
| {"label": "havana","nom": "Havana Prayers","membre_start": "2023-02-19","membre_end": "2023-04-24","status": "⚰️"},
| |
| {"label": "sullyvan","nom": "Sullyvan Roch","membre_start": "2023-02-19","membre_end": "2023-08-05","status": "❌"},
| |
| {"label": "lorenzo","nom": "Lorenzo Vàsquez Mendoza","membre_start": "2023-02-27","membre_end": "2023-08-05","status": "❌"},
| |
| {"label": "doran","nom": "Doran Henderson","membre_start": "2023-02-27","membre_end": "2023-08-05","status": "❌"},
| |
| {"label": "buck","nom": "Buck Horn","membre_start": "2023-04-24","membre_end": "2023-08-05","status": "❌"}
| |
| ],
| |
| "transform": [
| |
| {
| |
| "type": "formula",
| |
| "as": "membre_end",
| |
| "expr": "datum.membre_end ? datum.membre_end : datetime(year(now()) + '/' + (month(now())+1) + '/' + date(now()))"
| |
| }
| |
| ],
| |
| "format": {"parse": {"membre_start": "date", "membre_end": "date"}}
| |
| },
| |
| {
| |
| "name": "seconds",
| |
| "values": [
| |
| {"label": "carmelo","second_start": "2022-04-20","second_end": "2022-07-29"},
| |
| {"label": "allan","second_start": "2022-07-29","second_end": "2022-11-08"},
| |
| {"label": "bryan","second_start": "2022-07-29","second_end": "2022-11-08"},
| |
| {"label": "calvin","second_start": "2022-11-08","second_end": "2022-12-15"},
| |
| {"label": "vince","second_start": "2022-12-15","second_end": "2023-05-23"},
| |
| {"label": "lorenzo","second_start": "2023-03-06","second_end": "2023-08-05"}
| |
| ],
| |
| "transform": [
| |
| {
| |
| "type": "formula",
| |
| "as": "second_end",
| |
| "expr": "datum.second_end ? datum.second_end : datetime(year(now()) + '/' + (month(now())+1) + '/' + date(now()))"
| |
| }
| |
| ],
| |
| "format": {"parse": {"second_start": "date", "second_end": "date"}}
| |
| },
| |
| {
| |
| "name": "chefs",
| |
| "values": [
| |
| {"label": "paul","chef_start": "2022-04-20","chef_end": "2022-07-29"},
| |
| {"label": "kenny","chef_start": "2022-07-29","chef_end": "2022-11-07"},
| |
| {"label": "bryan","chef_start": "2022-07-29","chef_end": "2023-08-05"}
| |
| ],
| |
| "transform": [
| |
| {
| |
| "type": "formula",
| |
| "as": "chef_end",
| |
| "expr": "datum.chef_end ? datum.chef_end : datetime(year(now()) + '/' + (month(now())+1) + '/' + date(now()))"
| |
| }
| |
| ],
| |
| "format": {"parse": {"chef_start": "date", "chef_end": "date"}}
| |
| },
| |
| {
| |
| "name": "events",
| |
| "values": [
| |
| {"name": "20/04 - Création du gang","date": "2022-04-20","y": -20},
| |
| {"name": "13/09 - Drogues","date": "2022-09-13","y": -20},
| |
| {"name": "03/11 - Recel de véhicules","date": "2022-11-03","y": -20},
| |
| {"name": "05/08 - Dissolution du groupe","date": "2023-08-05","y": -20}
| |
| ],
| |
| "format": {"parse": {"date": "date"}}
| |
| },
| |
| {
| |
| "name": "annee",
| |
| "values": [
| |
| {"name": "2023","date": "2023-01-01"}
| |
| ],
| |
| "format": {"parse": {"date": "date"}}
| |
| }
| |
| ],
| |
| "scales": [
| |
| {
| |
| "name": "x",
| |
| "type": "time",
| |
| "range": "width",
| |
| "domain": {
| |
| "data": "membres",
| |
| "fields": ["membre_start", "membre_end"]
| |
| }
| |
| },
| |
| {
| |
| "name": "y",
| |
| "type": "band",
| |
| "range": "height",
| |
| "domain": {"data": "membres", "field": "label"},
| |
| "padding": 0.2
| |
| }
| |
| ],
| |
| "axes": [
| |
| {"orient": "bottom", "scale": "x", "grid": true, "format": "%m/%y"}
| |
| ],
| |
| "marks": [
| |
| {
| |
| "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": "chefs"},
| |
| "encode": {
| |
| "enter": {
| |
| "x": {"scale": "x", "field": "chef_start"},
| |
| "x2": {"scale": "x", "field": "chef_end"},
| |
| "y": {"scale": "y", "field": "label", "offset": -3},
| |
| "height": {"value": 10},
| |
| "fill": {"value": "#000"}
| |
| }
| |
| }
| |
| },
| |
| {
| |
| "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": "#ff0000"}
| |
| }
| |
| }
| |
| },
| |
| {
| |
| "type": "rect",
| |
| "from": {"data": "events"},
| |
| "encode": {
| |
| "enter": {
| |
| "x": {"scale": "x", "field": "date"},
| |
| "y": {"field": "y"},
| |
| "width": {"value": 0.5},
| |
| "height": {"value": 700},
| |
| "fill": {"value": "#0090FF"}
| |
| }
| |
| }
| |
| },
| |
| {
| |
| "type": "text",
| |
| "from": {"data": "events"},
| |
| "encode": {
| |
| "enter": {
| |
| "x": {"scale": "x", "field": "date"},
| |
| "y": {"field": "y"},
| |
| "angle": {"value": -30},
| |
| "text": {"field": "name"},
| |
| "fill": {"value": "#000"},
| |
| "fontSize": {"value": 14}
| |
| }
| |
| }
| |
| },
| |
| {
| |
| "type": "rect",
| |
| "from": {"data": "annee"},
| |
| "encode": {
| |
| "enter": {
| |
| "x": {"scale": "x", "field": "date"},
| |
| "y": {"field": "y"},
| |
| "width": {"value": 0.5},
| |
| "height": {"value": 700},
| |
| "fill": {"value": "#FF0000"}
| |
| }
| |
| }
| |
| },
| |
| {
| |
| "type": "text",
| |
| "from": {"data": "annee"},
| |
| "encode": {
| |
| "enter": {
| |
| "x": {"scale": "x", "field": "date"},
| |
| "y": {"field": "y"},
| |
| "angle": {"value": -30},
| |
| "text": {"field": "name"},
| |
| "fill": {"value": "#FF0000"},
| |
| "fontSize": {"value": 20}
| |
| }
| |
| }
| |
| },
| |
| {
| |
| "type": "text",
| |
| "from": {"data": "membres"},
| |
| "encode": {
| |
| "enter": {
| |
| "x": {"scale": "x", "field": "membre_start"},
| |
| "y": {"scale": "y", "field": "label", "offset": -7},
| |
| "text": {"field": "nom"},
| |
| "fill": {"value": "#000"},
| |
| "fontSize": {"value": 14}
| |
| }
| |
| }
| |
| },
| |
| {
| |
| "type": "text",
| |
| "from": {"data": "membres"},
| |
| "encode": {
| |
| "enter": {
| |
| "x": {"scale": "x", "field": "membre_end", "offset": -2},
| |
| "y": {"scale": "y", "field": "label", "offset": 6},
| |
| "text": {"field": "status"},
| |
| "fill": {"value": "#000"},
| |
| "fontSize": {"value": 14}
| |
| }
| |
| }
| |
| }
| |
| ]
| |
| }
| |
| </graph>
| |
