# Vega Error

**URL:** <https://discuss.elastic.co/t/vega-error/275584>\
**Category:** Kibana\
**Tags:** vega\
**Created:** [June 10, 2021, 1:57pm UTC](https://discuss.elastic.co/t/vega-error/275584 "2021-06-10T13:57:02Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krunal](https://avatars.discourse-cdn.com/v4/letter/k/ce7236/32.png) [@Krunal](https://discuss.elastic.co/u/Krunal)\
**Post date:** [June 10, 2021, 1:57pm UTC](https://discuss.elastic.co/t/vega-error/275584/1 "2021-06-10T13:57:03Z")

</div>

Hello expert,  
Vega Graph is working perfectly, but getting 0 at x-axis ... why 0 ?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/9/a9f88c167271bec174186a4d28f463fedee8f334.png)

```auto
{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "title": "Difference par Jour",
  "data": {
    "url": {
      "%context%": true,
      "%timefield%": "@timestamp",
      "index": "terrena_client_vm",
      "body": {
          "aggs": {
      "day_date_histogram_of_timestamp": {
        "date_histogram": {
          "field": "@timestamp", 
          "calendar_interval": "day"
        },
        "aggs": {
          "sum_of_Jobsize": {
            "sum": {"field": "Job_Size(GB)"}
          },
          "serial_diff_of_sum_of_Jobsize": {
            "serial_diff": {"buckets_path": "sum_of_Jobsize", "lag": 1}
          }
        }
      }
    },
    "size":0 
      }
    },
    "format": {"property": "aggregations.day_date_histogram_of_timestamp.buckets"}
  },
    transform: [
    {
      window: [
        {
          op: lead
          field: key_as_string
          offset: 1
          as: next_lead
        }
      ]
    }
    {
  calculate: "datum.sum_of_Jobsize.value",
  as: "sum"
}

{
  calculate: "datum.key_as_string",
  as: "lead"
}

{
  calculate: datum.serial_diff_of_sum_of_Jobsize != null ? datum.sum - datum.serial_diff_of_sum_of_Jobsize.value :0
  as: previous_sum
}
{
  calculate: datum.serial_diff_of_sum_of_Jobsize != null ? datum.serial_diff_of_sum_of_Jobsize.value :datum.sum
  as: amount
}
{
  calculate: ( datum.serial_diff_of_sum_of_Jobsize != null && datum.amount > 0 ? '+' : '') + datum.amount 
  as: text_amount
}
{
  calculate: (datum.sum + datum.previous_sum) / 2
  as: center
}
{
  calculate: datum.sum < datum.previous_sum ? datum.sum : ''
  as: sum_dec
}
{
  calculate: datum.sum > datum.previous_sum ? datum.sum : ''
  as: sum_inc
}
  ],
  "mark": "line",
  encoding: {
    x: {
      field: key_as_string
      type: ordinal
      sort : null
      axis: {
          title: Days
          labelExpr: datum.label[8]+datum.label[9]
          labelBaseline : bottom
          labelColor: black
          
      }
    }
  }
    layer: [
    {
      mark: {
        type: bar
        size: 20
      }
      encoding: {
        y: {
          field: previous_sum
          type: quantitative
          title: Sum of Job Size
        }
        y2: {
          field: sum
        }
        color: {
          condition: [
            {
              test: datum.serial_diff_of_sum_of_Jobsize == null
              value: "yellow"
            }
            {
              test: datum.sum < datum.previous_sum
              value: "pink"
            }
          ]
          value: "lightgreen"
        }
      }
    }
    {
      mark: {
        type: rule
        opacity: 1
        color: "#404040"
        strokeWidth: 2
        xOffset: -10
        x2Offset: 10
      }
      encoding: {
        x2: {
          field: next_lead
        }
        y: {
          field: sum
          type: quantitative
        }
      }
    }
    {
      mark: {
        type: text
        dy: -18
        baseline : bottom
      }
      encoding: {
        y: {
          field: sum_inc
          type: quantitative
        }
        text: {
          field: sum_inc
          type: nominal
          format:.1f
        }
      }
    }
    {
      mark: {
        type: text
        dy: 13
        baseline: middle
      }
      encoding: {
        y: {
          field: sum_dec
          type: quantitative
        }
        text: {
          field: sum_dec
          type: nominal
          format: .1f
        }
      }
    }
    {
      mark: {
        type: text
        dy :0
        fontWeight: bold
        baseline : line-bottom
      }
      encoding: {
        y: {
          field: center
          type: quantitative
        }
        text: {
          field: text_amount
          type: nominal
          format: .1f
        }
        color: {
          condition: [
            {
              test: datum.serial_diff_of_sum_of_Jobsize == null
              value: "green"
            }
          ]
          value: black
        }
      }
    }
  ]
    config: {
    text: {
      fontWeight: bold
      color: red
    }
  }
}

```

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [June 10, 2021, 6:22pm UTC](https://discuss.elastic.co/t/vega-error/275584/2 "2021-06-10T18:22:13Z")

</div>

@krunal it looks like this is because you have `dy: -18` on your text.

---

<div class="post-metadata">

**Author:** ![Krunal](https://avatars.discourse-cdn.com/v4/letter/k/ce7236/32.png) [@Krunal](https://discuss.elastic.co/u/Krunal)\
**Post date:** [June 11, 2021, 9:02am UTC](https://discuss.elastic.co/t/vega-error/275584/3 "2021-06-11T09:02:51Z")

</div>

@wylie Thanks  
But how I can remove 0.... I dont want 0 in my chart

---

<div class="post-metadata">

**Author:** ![Krunal](https://avatars.discourse-cdn.com/v4/letter/k/ce7236/32.png) [@Krunal](https://discuss.elastic.co/u/Krunal)\
**Post date:** [June 11, 2021, 12:03pm UTC](https://discuss.elastic.co/t/vega-error/275584/4 "2021-06-11T12:03:39Z")

</div>

Is there any possibility that i can put if condition to remove 0... or i can change color to white if value is 0...

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [June 14, 2021, 1:41pm UTC](https://discuss.elastic.co/t/vega-error/275584/5 "2021-06-14T13:41:26Z")

</div>

Yes, both are possible. You should look into the documentation for Vega to see examples where you can apply conditional logic.

---

<div class="post-metadata">

**Author:** ![Krunal](https://avatars.discourse-cdn.com/v4/letter/k/ce7236/32.png) [@Krunal](https://discuss.elastic.co/u/Krunal)\
**Post date:** [June 15, 2021, 7:50am UTC](https://discuss.elastic.co/t/vega-error/275584/6 "2021-06-15T07:50:29Z")

</div>

Thanks a lot @wylie for providing useful hints.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/4/347dba14083187da10d02db1bbe84f2c89cbf41c.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 13, 2021, 7:51am UTC](https://discuss.elastic.co/t/vega-error/275584/7 "2021-07-13T07:51:08Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.