Help with time format in deneb visual

Deneb Showcase
1

Hi,

I’ve been attempting to recreate this visual on my dataset.

image
image405×558 56.2 KB

with help of this video: https://www.youtube.com/watch?v=FlzlSozY3VE

I am using the Interval Column from my time table :

image
image1460×440 44.6 KB

My time interval isnt appearing in correct format. Looks like a utc format

image
image463×646 4.4 KB

this is the code i have written so far. - Please can you guide me on how to get this time format corrected ?

{
  "data": {"name": "dataset"},
  "vconcat": [
    {
      "hconcat": [
        {
          "name": "Main matrix",
          "mark": {"type": "rect"},
          "encoding": {
            "x": {
              "field": "LOB",
              "sort": null
            },
            "y": {
              "timeunit": "hoursminutes",
              "field": "Interval",
              "type":"ordinal"
              
            }
          }
        },
        {
          "name": "Marginal bars (row)",
          "mark": {"type": "bar"},
          "encoding": {
            "y": {
              "timeunit": "hoursminutes",
              "field": "Interval",
              "type":"ordinal",
              "axis": null
            }
          }
        }
      ]
    },
    {
      "hconcat": [
        {
          "name": "Marginal bars(col)",
          "mark": {"type": "bar"},
          "encoding": {
            "x": {
              "field": "LOB",
              "sort": null,
              "axis": null
            }
          }
        }
      ]
    }
  ]
}

and these are the errors i have :

image
image1132×803 221 KB

2

Hi @jsodhi. Daniel’s is the best video to use for sure, so the best start, however he’s using a text field for Hours AM/PM where yours is a date/time. You’ll need to format your date/time value appropriately, perhaps using one of either the Power BI formatting provided by Deneb

or the built-in Vega-Lite formatting

Give one of these a shot, and if you still have questions, upload a sample PBIX to reduce the workload on the forum members who respond.
Greg

3

This link may also help:

Greg

4

Awesome.

Thank you for your quick response and refering me these links. Ill read the links and attempt to fix it. Will get back here for help if it still doesnt work.

Thank you again.

5

Hello @jsodhi

Did the response from @Greg help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark his answer as the SOLUTION.

Thank you

6

Hey Greg,

Thank you . I found my solution on this link, that you shared:

This is the code i used and i’ve got the time appearign in correct format.

"y": {
              "timeUnit": "hoursminutes",
              "field":"Interval",
              "type": "Ordinal",
              "title": "time"
              
            }

Thank you agian for pointing me in correct direction