Forum Discussion

ayalangel's avatar
ayalangel
Frequent Visitor
1 year ago
Solved

undefined

Hola, Esperando ser breve, tengo una tabla de entrada y salida de personal por ejemplo:

estoy tratando de obtener una forma de ver estos datos dentro de un calendario grafico u objeto visual, donde lo vea por fechas algo parecido a esto: 

donde pueda ver por empleado los dias que estuvo en guardia, esperando no sea un sueño lograrlo y recibir el apoyo de la comunidad, agradeciendo de antemano la ayuda

 

Need Help
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    1 year ago

    would something like this be acceptable?  This is a simple Deneb based chart.

     

     

    {
  "data": {
    "name": "dataset"
  },
  "mark": {
    "type": "bar"
  },
  "encoding": {
    "y": {
      "field": "employee_code",
      "type": "ordinal"
    },
    "x": {
      "field": "check in",
      "type": "temporal"
    },
    "x2": {
      "field": "check out"
    }
  }
}

     

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

    Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

    Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

    Please show the expected outcome based on the sample data you provided.

    Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

    • ayalangel's avatar
      ayalangel
      Frequent Visitor
      1 year ago

      Buenas noches, perdon por la demora en responder, lo que busco es una grafica de Gantt que me permita visualizacion a nivel horas y minutos (tiempo de jornada), asi como varios registros ( entrada y salida) por categoria (empleado), adjunto datos de ejemplo en el formato solicitado: 

      employee_codecheck incheck outHours
      9616101/10/2024 17:5203/10/2024 08:3138.64
      0027301/10/2024 08:1402/10/2024 05:3721.38
      0027303/10/2024 05:1805/10/2024 05:2148.06
      0703901/10/2024 08:2301/10/2024 12:314.14
      0703902/10/2024 06:0202/10/2024 12:186.26
      0703903/10/2024 07:3205/10/2024 13:5254.33
      9615301/10/2024 05:0702/10/2024 20:3139.40
      9618701/10/2024 13:4905/10/2024 05:4888.00
      4358267501/10/2024 05:1504/10/2024 20:5287.62

      Agradeciendo de nuevo la ayuda, esperando haber sido mas especifico en lo que busco

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        would something like this be acceptable?  This is a simple Deneb based chart.

         

         

        {
  "data": {
    "name": "dataset"
  },
  "mark": {
    "type": "bar"
  },
  "encoding": {
    "y": {
      "field": "employee_code",
      "type": "ordinal"
    },
    "x": {
      "field": "check in",
      "type": "temporal"
    },
    "x2": {
      "field": "check out"
    }
  }
}