Forum Discussion

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, ...

Need Help

Tutorial Requests

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"
    }
  }
}

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

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_code	check in	check out	Hours
96161	01/10/2024 17:52	03/10/2024 08:31	38.64
00273	01/10/2024 08:14	02/10/2024 05:37	21.38
00273	03/10/2024 05:18	05/10/2024 05:21	48.06
07039	01/10/2024 08:23	01/10/2024 12:31	4.14
07039	02/10/2024 06:02	02/10/2024 12:18	6.26
07039	03/10/2024 07:32	05/10/2024 13:52	54.33
96153	01/10/2024 05:07	02/10/2024 20:31	39.40
96187	01/10/2024 13:49	05/10/2024 05:48	88.00
43582675	01/10/2024 05:15	04/10/2024 20:52	87.62

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

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" } } }
- ayalangel
  Frequent Visitor
  1 year ago
  Gracias, esto funcionará, por ahora... solo falta que aprenda a configurarla para mejorar la vista, de nuevo gracias,
  trataré de afinar los detalles visuales.