# X-axis is not visible in vega visualization **URL:** \ **Category:** Elasticsearch\ **Tags:** vega\ **Created:** [February 11, 2021, 9:49am UTC](https://discuss.elastic.co/t/x-axis-is-not-visible-in-vega-visualization/263981 "2021-02-11T09:49:16Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![saumya1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/saumya1/32/87139_2.png) [@saumya1](https://discuss.elastic.co/u/saumya1)\ **Post date:** [February 11, 2021, 9:49am UTC](https://discuss.elastic.co/t/x-axis-is-not-visible-in-vega-visualization/263981/1 "2021-02-11T09:49:16Z")
```auto { "$schema": "https://vega.github.io/schema/vega/v5.json", "description": "A basic bar chart example, with value labels shown upon mouse hover.", "signals": [{ "name": "timeunit", "value": ["day"], "bind": {"input": "select", "options": [ ["month"], ["date"], ["day"], ["hours"] ]}}], "data": [ { "name": "flights", url: { index: samptuint body: { _source: ["date", "ticket", "priority", "inc_num", "status"] } } format: { property: "hits.hits" } "transform": [ { "type": "timeunit", "field": "date", "units": {"signal": "timeunit"}, "signal": "tbin" } ] } ], "scales": [ { "name": "xscale", "type": "band", "range": "width", "padding": 0.05, "round": true, "domain": {data:"flights", "signal": "timeSequence(tbin.unit, tbin.start, tbin.stop)"} } ], "axes": [ { "orient": "bottom", "scale": "xscale", "formatType": "time", "format": {"signal": "timeUnitSpecifier(tbin.units, {hours: '%H'})"} } ] } ``` for reference:- ```auto { "$schema": "https://vega.github.io/schema/vega/v5.json", "description": "A basic bar chart example, with value labels shown upon mouse hover.", "width": 400, "height": 200, "padding": 5, "signals": [ { "name": "timeunit", "value": ["day"], "bind": {"input": "select", "options": [ ["month"], ["date"], ["day"], ["hours"] ]} } ], "data": [ { "name": "flights", "values": [ {"date": " 01 Jan 2012 23:00:00", "ticket":10, "priority":"p1", "inc":"INC001"}, {"date": " 01 feb 2012 20:00:00", "ticket":10, "priority":"p1", "inc":"INC001"}, {"date": " 01 Jan 2012 23:00:00", "ticket":17, "priority":"p3", "inc":"INC002"}, {"date": " 01 feb 2012 23:00:00", "ticket":20, "priority":"p3", "inc":"INC003"}, {"date": " 04 march 2012 23:00:00", "ticket":15,"priority":"p4", "inc":"INC004"}, {"date": " 01 Apr 2018 23:00:00", "ticket":28, "priority":"p4", "inc":"INC008"}, {"date": " 01 Jan 2016 23:00:00", "ticket":27, "priority":"p2", "inc":"INC005"}, {"date": " 06 feb 2016 23:00:00", "ticket":32, "priority":"p3", "inc":"INC006"}, {"date": " 07 march 2016 20:00:00", "ticket":11, "priority":"p4", "inc":"INC007"}, {"date": " 01 Jan 2018 23:00:00", "ticket":28, "priority":"p4", "inc":"INC008"}, {"date": " 05 feb 2018 13:00:00", "ticket":16, "priority":"p2", "inc":"INC009"}, {"date": " 08 march 2018 23:00:00", "ticket":19, "priority":"p2", "inc":"INC010"}, {"date": " 01 Jan 2020 23:00:00", "ticket":29, "priority":"p1", "inc":"INC011"}, {"date": " 05 feb 2020 23:00:00", "ticket":18, "priority":"p3", "inc":"INC012"}, {"date": "06 march 2020 23:00:00", "ticket":18, "priority":"p3", "inc":"INC013"} ], "format": {"type": "json", "parse": "auto"}, "transform": [ { "type": "timeunit", "field": "date", "units": {"signal": "timeunit"}, "signal": "tbin" } ] } ], "scales": [ { "name": "xscale", "type": "band", "range": "width", "padding": 0.05, "round": true, "domain": {"signal": "timeSequence(tbin.unit, tbin.start, tbin.stop)"} } ], "axes": [ { "orient": "bottom", "scale": "xscale", "formatType": "time", "format": {"signal": "timeUnitSpecifier(tbin.units, {hours: '%H'})"} } ] } ``` ---
**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\ **Post date:** [February 11, 2021, 1:13pm UTC](https://discuss.elastic.co/t/x-axis-is-not-visible-in-vega-visualization/263981/2 "2021-02-11T13:13:45Z")
What is the response to your ES query? ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/1/91e077ce2578d673913ea3ce131985b5e076b319.png) ---
**Author:** ![saumya1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/saumya1/32/87139_2.png) [@saumya1](https://discuss.elastic.co/u/saumya1)\ **Post date:** [February 11, 2021, 1:29pm UTC](https://discuss.elastic.co/t/x-axis-is-not-visible-in-vega-visualization/263981/3 "2021-02-11T13:29:36Z")
{ "took": 1, "timed\_out": false, "\_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "total": 14, "max\_score": 1, "hits": [ { "\_index": "samptuint", "\_type": "\_doc", "\_id": "ue3lR3cBmDhuxKMfAKQP", "\_score": 1, "\_source": { "date": "01-01-2012 23:00:00" }, "unit0": null, "unit1": null }, { "\_index": "samptuint", "\_type": "\_doc", "\_id": "uu3lR3cBmDhuxKMfAKQP", "\_score": 1, "\_source": { "date": "03-22-2012 20:00:00" }, "unit0": null, "unit1": null }, { "\_index": "samptuint", "\_type": "\_doc", "\_id": "u-3lR3cBmDhuxKMfAKQP", "\_score": 1, "\_source": { "date": "02-01-2012 23:00:00" }, "unit0": null, "unit1": null }, { "\_index": "samptuint", "\_type": "\_doc", "\_id": "vO3lR3cBmDhuxKMfAKQP", "\_score": 1, "\_source": { "date": "04-02-2012 23:00:00" }, "unit0": null, "unit1": null }, { "\_index": "samptuint", "\_type": "\_doc", "\_id": "ve3lR3cBmDhuxKMfAKQP", "\_score": 1, "\_source": { "date": "04-13-2012 23:00:00" }, "unit0": null, "unit1": null }, { "\_index": "samptuint", "\_type": "\_doc", "\_id": "vu3lR3cBmDhuxKMfAKQP", "\_score": 1, "\_source": { "date": "01-04-2018 23:00:00" }, "unit0": null, "unit1": null }, { "\_index": "samptuint", "\_type": "\_doc", "\_id": "v-3lR3cBmDhuxKMfAKQP", "\_score": 1, "\_source": { "date": "04-21-2016 23:00:00" }, "unit0": null, "unit1": null }, { "\_index": "samptuint", "\_type": "\_doc", "\_id": "wO3lR3cBmDhuxKMfAKQP", "\_score": 1, "\_source": { "date": "02-02-2016 23:00:00" }, "unit0": null, "unit1": null }, { "\_index": "samptuint", "\_type": "\_doc", "\_id": "we3lR3cBmDhuxKMfAKQP", "\_score": 1, "\_source": { "date": "03-03-2016 20:00:00" }, "unit0": null, "unit1": null }, { "\_index": "samptuint", "\_type": "\_doc", "\_id": "wu3lR3cBmDhuxKMfAKQP", "\_score": 1, "\_source": { "date": "01-01-2018 23:00:00" }, "unit0": null, "unit1": null } ] } } ---
**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\ **Post date:** [February 11, 2021, 2:22pm UTC](https://discuss.elastic.co/t/x-axis-is-not-visible-in-vega-visualization/263981/4 "2021-02-11T14:22:45Z")
I think it's your date format. Working `01 Jan 2012 23:00:00` Not Working `03-03-2016 20:00:00` I'd try a parse or transform to change your string to a date that will work with this function. Something like `timeParse('03-22-2012 20:00:00', '%m-%d-%Y %H:%M:%S')` ---
**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\ **Post date:** [February 11, 2021, 2:34pm UTC](https://discuss.elastic.co/t/x-axis-is-not-visible-in-vega-visualization/263981/5 "2021-02-11T14:34:24Z")
Toss this transform in there before your `timeunit` transform and it should work. ```auto {"type": "formula", "as": "date", "expr": "toDate(datum._source.date)"} ``` ---
**Author:** ![saumya1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/saumya1/32/87139_2.png) [@saumya1](https://discuss.elastic.co/u/saumya1)\ **Post date:** [February 11, 2021, 3:14pm UTC](https://discuss.elastic.co/t/x-axis-is-not-visible-in-vega-visualization/263981/6 "2021-02-11T15:14:12Z")
I have added transform as per suggestion but still no output. { "$schema": "[https://vega.github.io/schema/vega/v5.json](https://vega.github.io/schema/vega/v5.json)", "description": "A basic bar chart example, with value labels shown upon mouse hover.", ``` "signals": [ { "name": "timeunit", "value": ["day"], "bind": {"input": "select", "options": [ ["month"], ["date"], ["day"], ["hours"] ]} } ``` ], "autosize":"none", "height":"300", "width":"200", "padding":"30" "data": [ { "name": "flights", url: { index: samptuint body: { ``` _source: ["date", "ticket", "priority", "inc_num", "status"] } } format: { property: "hits.hits" } "transform":[{"type": "formula", "as": "date", "expr": "toDate(datum._source.date)"}] "transform": [ // {"type": "formula", "as": "month", "expr": "month(datum.date)"} { "type": "timeunit", "field": "date", "units": {"signal": "timeunit"}, "signal": "tbin" } ] } ``` ], "scales": [ { "name": "xscale", "type": "band", "range": "width", "padding": 0.05, "round": true, "domain": {data:"flights", "signal": "timeSequence(tbin.unit, tbin.start, tbin.stop)"} } ], "axes": [ { "orient": "bottom", "scale": "xscale", "formatType": "time", "format": {"signal": "timeUnitSpecifier(tbin.units, {hours: '%H'})"} } ] } ---
**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\ **Post date:** [February 11, 2021, 3:19pm UTC](https://discuss.elastic.co/t/x-axis-is-not-visible-in-vega-visualization/263981/7 "2021-02-11T15:19:46Z")
What do you mean by `no output`? I have this working on the [Vega Editor](https://vega.github.io/editor/#/url/vega/N4IgJAzgxgFgpgWwIYgFwhgF0wBwqgegIDc4BzJAOjIEtMYBXAI0poHsDp5kTykSArJQBWENgDsQAGhAATONABONHJnaT0AQQAETJBBpRdSRdtgnM2uAA8kCHABs4U7QHc6MbcSQOGcbQ5ITHAOENoQMGyu4toMOBLaCGwMEP6RpIqU0iDusvRoACwADEUy8DRkWGgATCUyBmTiPhBoANqgTQhwaCBqXQzidNnevt2orXJIAJ4gALoyTDTismigSzgMmD2pTlBbMmyq6i3jE0ni+fMTskiY3VeTMw+RDIots7MAvp-zk5go4w6djGIAAZg4KlgWjJXg4elhcPgiLQIJhqB5mCk4IooBI7hdKLiEAQkCYJABaQZJKAAawgBDgAGZZIzqkEinBZABGIoANiY1QAnAAOASgxnCuBQYVFLlc4Ii4UERRIVwEQVQQUAdlBvIKBVJcC1wVBoP1vIERVkut5sgKGq1vMFUsdjIKjN5BDuqJEYkkMlBbEUyC2qFAOEUh2xmBm6BgdAglHjmBanxkmBV4gggeDbVAMZwIJzCAYgWy+h6Nzu2RsEZ6mDYABFbnAABRVhgISgAfTErygcEoVbgAEoQGn81NC-WaP1BvswTQQit0MPsgME6sQA0mnD0H04ButmntxVd-XFpIfj96lAfAo8yBOiDrNB79kCyC9MtspmyCDcnyGQcCQWRZCWMg0CKSgigEGRIwGFcMz8GRZDYZAli3KsATBCFKhTbIdx8GcugAZTgABHPxxAHVtMEvSgjxceilkoVELGYhjUUOMdvl+JBrAfQEQCDJcLh6Jg2GwdDCLvJwelfOTugDIMQwAFSnEED2yYtbi3Ii916Wc4AAVXnUjCygGhQSXRQ6IYo8IBcYAXjeVBtAAcgAUgACQ8z5eOvIA) and I see it is creating the x-axis. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 11, 2021, 3:20pm UTC](https://discuss.elastic.co/t/x-axis-is-not-visible-in-vega-visualization/263981/8 "2021-03-11T15:20:31Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.