# Timelion is not reflecting the time series **URL:** \ **Category:** Kibana\ **Tags:** timelion\ **Created:** [June 21, 2018, 1:34pm UTC](https://discuss.elastic.co/t/timelion-is-not-reflecting-the-time-series/136881 "2018-06-21T13:34:31Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![eswarloges](https://avatars.discourse-cdn.com/v4/letter/e/8e7dd6/32.png) [@eswarloges](https://discuss.elastic.co/u/eswarloges)\ **Post date:** [June 21, 2018, 1:34pm UTC](https://discuss.elastic.co/t/timelion-is-not-reflecting-the-time-series/136881/1 "2018-06-21T13:34:31Z")
Hi Team, I am new to Elastic Search. I have started exploring it and when I write my first timelion query it is not working. I am trying to generate the timeseries for the rejected percentage of the records. .es(index=finalwmindex,timefield=process\_start\_time,q=status.keyword:COMPLETED,metric=sum:invalid\_records\_count).divide(.es(index=finalwmindex,timefield=process\_start\_time,q=status.keyword:COMPLETED,metric=sum:total\_records\_count)).multiply(100). ---
**Author:** ![a5a](https://avatars.discourse-cdn.com/v4/letter/a/a87d85/32.png) [@a5a](https://discuss.elastic.co/u/a5a)\ **Post date:** [June 21, 2018, 5:37pm UTC](https://discuss.elastic.co/t/timelion-is-not-reflecting-the-time-series/136881/2 "2018-06-21T17:37:49Z")
Not sure if just a typo in this message, your in your actual query in timelion, but you have `multipy` instead of `multiply`. What is the error you're getting? ---
**Author:** ![eswarloges](https://avatars.discourse-cdn.com/v4/letter/e/8e7dd6/32.png) [@eswarloges](https://discuss.elastic.co/u/eswarloges)\ **Post date:** [June 21, 2018, 5:51pm UTC](https://discuss.elastic.co/t/timelion-is-not-reflecting-the-time-series/136881/3 "2018-06-21T17:51:05Z")
Sorry for the typo. I m not getting any errors. I have got the empty time series only. But I have data points in the index. I m trying to get the rejected percentage. If pipeline aggregation is possible in visualization then I can achieve it easily? ---
**Author:** ![a5a](https://avatars.discourse-cdn.com/v4/letter/a/a87d85/32.png) [@a5a](https://discuss.elastic.co/u/a5a)\ **Post date:** [June 21, 2018, 5:53pm UTC](https://discuss.elastic.co/t/timelion-is-not-reflecting-the-time-series/136881/4 "2018-06-21T17:53:14Z")
Yes, you can definitely achieve this. I'm working on something locally. Will update! ---
**Author:** ![eswarloges](https://avatars.discourse-cdn.com/v4/letter/e/8e7dd6/32.png) [@eswarloges](https://discuss.elastic.co/u/eswarloges)\ **Post date:** [June 21, 2018, 6:00pm UTC](https://discuss.elastic.co/t/timelion-is-not-reflecting-the-time-series/136881/5 "2018-06-21T18:00:56Z")
Sure will wait for the update.. Thanks ---
**Author:** ![a5a](https://avatars.discourse-cdn.com/v4/letter/a/a87d85/32.png) [@a5a](https://discuss.elastic.co/u/a5a)\ **Post date:** [June 21, 2018, 6:20pm UTC](https://discuss.elastic.co/t/timelion-is-not-reflecting-the-time-series/136881/6 "2018-06-21T18:20:10Z")
Maybe your granularity is set too narrow or too broad. Do you have your setting at "auto"? You might try changing that. ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/3/437292a8b621eb475f20876e3760d931c32b9042.png) ---
**Author:** ![eswarloges](https://avatars.discourse-cdn.com/v4/letter/e/8e7dd6/32.png) [@eswarloges](https://discuss.elastic.co/u/eswarloges)\ **Post date:** [June 22, 2018, 9:36am UTC](https://discuss.elastic.co/t/timelion-is-not-reflecting-the-time-series/136881/7 "2018-06-22T09:36:02Z")
It worked. Thanks @a5a Are we still not supported with Pipeline Aggregation in Kibana Visualization? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 20, 2018, 9:36am UTC](https://discuss.elastic.co/t/timelion-is-not-reflecting-the-time-series/136881/8 "2018-07-20T09:36:12Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.