# TSVB don't work only on Count Aggregation **URL:** \ **Category:** Kibana\ **Created:** [September 6, 2021, 2:29pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457 "2021-09-06T14:29:52Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Cap\_Ho](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cap_ho/32/79703_2.png) [@Cap\_Ho](https://discuss.elastic.co/u/Cap_Ho)\ **Post date:** [September 6, 2021, 2:29pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/1 "2021-09-06T14:29:52Z")
I don't know why the TSVB suddenly don't work anymore only for "Count" Aggregation. it show "The request for this panel failed. Failed to compile inline script [count \*1] using lang [expression]. " But when i use the other aggregation like "Average, Cardinality". it works perfectly. Also for other visualization (Bar, Pie , Metrics). The "Count" function is ok, do any one of you face it before? ---
**Author:** ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)\ **Post date:** [September 6, 2021, 2:45pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/2 "2021-09-06T14:45:09Z")
Hi @Cap_Ho what version of the Stack are you using? ---
**Author:** ![Cap\_Ho](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cap_ho/32/79703_2.png) [@Cap\_Ho](https://discuss.elastic.co/u/Cap_Ho)\ **Post date:** [September 6, 2021, 2:56pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/3 "2021-09-06T14:56:23Z")
7.10 ---
**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\ **Post date:** [September 6, 2021, 3:14pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/4 "2021-09-06T15:14:47Z")
Can you share your TSVB configuration with us ? ---
**Author:** ![Cap\_Ho](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cap_ho/32/79703_2.png) [@Cap\_Ho](https://discuss.elastic.co/u/Cap_Ho)\ **Post date:** [September 7, 2021, 12:28am UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/5 "2021-09-07T00:28:55Z")
I just use Kibana sample flight and sales and create the tsvb and it also fail ---
**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\ **Post date:** [September 7, 2021, 8:21am UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/6 "2021-09-07T08:21:43Z")
Here is a screenshot from a 7.10 cloud instance which uses ecommerce data and count aggregation and it works ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/5/45ad84d0963b5f85024a3d880e5b9e512fab1255.png) do you have the same configuration with the screenshot? ---
**Author:** ![huynhmytuan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/huynhmytuan/32/94325_2.png) [@huynhmytuan](https://discuss.elastic.co/u/huynhmytuan)\ **Post date:** [September 8, 2021, 3:49pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/7 "2021-09-08T15:49:30Z")
![image](https://us1.discourse-cdn.com/elastic/original/3X/d/b/db29efab226cbb3b3e180786b9251e16ea677e49.png) I have the same problem. ---
**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\ **Post date:** [September 9, 2021, 6:32am UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/8 "2021-09-09T06:32:58Z")
I can't replicate it so I will need more information. I see another series the `2xx`, what is it about. Can you also share your Options and Panel options configuration? @huynhmytuan you are also using the 7.10 version of the stack? ---
**Author:** ![AmplifiedHuman](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/amplifiedhuman/32/94402_2.png) [@AmplifiedHuman](https://discuss.elastic.co/u/AmplifiedHuman)\ **Post date:** [September 10, 2021, 9:15am UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/9 "2021-09-10T09:15:36Z")
Hi, having the same issue as well on 7.9. The error message I'm getting is: `"Failed to compile inline script [count * 1] using lang [expression]"` . Interestingly there's also another error in Timelion which says: `[timelion_vis] > Timelion request error: undefined Error: in cell #1: [search_phase_execution_exception]` ![Screenshot 2021-09-10 at 10.13.20](https://us1.discourse-cdn.com/elastic/original/3X/b/7/b7a7f0aba04444090cd1ff01ffd5a4c38aafe4d5.png) ![Screenshot 2021-09-10 at 10.16.56](https://us1.discourse-cdn.com/elastic/original/3X/6/3/63331ec355f795045b978809e887aca91bedd484.png) ![Screenshot 2021-09-10 at 10.17.20](https://us1.discourse-cdn.com/elastic/original/3X/4/e/4e27d6b48389bc4a8437c1029a8288e4c85ab50a.png) ![Screenshot 2021-09-10 at 10.13.42](https://us1.discourse-cdn.com/elastic/original/3X/5/e/5ecd1ce22d19d963f163b8153c39c35100c108ab.png) ---
**Author:** ![stemons](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stemons/32/84571_2.png) [@stemons](https://discuss.elastic.co/u/stemons)\ **Post date:** [September 13, 2021, 1:28pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/10 "2021-09-13T13:28:35Z")
Hello team, we have the same issue. Do you have further info about the root cause of the error message? ---
**Author:** ![usamkr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/usamkr/32/94671_2.png) [@usamkr](https://discuss.elastic.co/u/usamkr)\ **Post date:** [September 16, 2021, 12:17pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/11 "2021-09-16T12:17:46Z")
we have the same issue. What's wrong? ---
**Author:** ![vincentditlevinz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vincentditlevinz/32/94688_2.png) [@vincentditlevinz](https://discuss.elastic.co/u/vincentditlevinz)\ **Post date:** [September 16, 2021, 3:52pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/12 "2021-09-16T15:52:11Z")
Hello I have the same issue on a 7.7.0 managed by AWS The issue arose a few days ago but I am not aware of any recent change of our managed Elasticsearch platform. Does this mean that partial updates of the platform may occur "underground" without being notified ? ---
**Author:** ![PeterC](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/peterc/32/4222_2.png) [@PeterC](https://discuss.elastic.co/u/PeterC)\ **Post date:** [September 20, 2021, 12:19pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/13 "2021-09-20T12:19:30Z")
We have the same issue on AWS managed service .. v 7.10 . Many TSVB visualisations.. appear to have just failed with above error message. ---
**Author:** ![vincentditlevinz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vincentditlevinz/32/94688_2.png) [@vincentditlevinz](https://discuss.elastic.co/u/vincentditlevinz)\ **Post date:** [September 20, 2021, 4:24pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/14 "2021-09-20T16:24:43Z")
The issue is now solved. Though I am still surprised to not have full control on TSVB visualization plugin updates on our AWS managed cluster. I would really appreciate having some insights to understand what was going on. Thank you, Vincent ---
**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\ **Post date:** [September 20, 2021, 6:02pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/15 "2021-09-20T18:02:24Z")
Hi @vincentditlevinz Welcome tho the community and glad you got your issues resolved. I think there is a bit of confusion. This forum / community does not deal with AWS Managed Opensearch service we support the official Distributions of Elasticsearch and Elastic Cloud .. The Official Elasticsearch Hosted Service. The AWS Managed Service is a based on a past fork of the Elasticsearch code and thus is very different that the official distribution and hosted service. If you want the best Product and Service perhaps you should try the official Services Product Page Here: > **[Elastic Cloud: Hosted Elasticsearch, Hosted Search | Elastic](https://www.elastic.co/cloud/)** > > Elastic Cloud is a family of Elasticsearch SaaS offerings — including hosted Elasticsearch, hosted app search, and hosted site search — that make it easy to deploy, operate, and scale Elastic products and solutions in the cloud. And here is a little bit of the difference between our Official Offering and AWS Opensearch. > **[Amazon Elasticsearch Service: About Amazon Elasticsearch (Amazon OpenSearch...](https://www.elastic.co/aws-elasticsearch-service)** > > Does Amazon Elasticsearch Service (Amazon OpenSearch Service) = Elastic Elasticsearch Service? Nope! Let’s take a look at differences and some critical features that are only available through our Elasticsearch Service on Elastic Cloud. ---
**Author:** ![vincentditlevinz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vincentditlevinz/32/94688_2.png) [@vincentditlevinz](https://discuss.elastic.co/u/vincentditlevinz)\ **Post date:** [September 21, 2021, 7:41am UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/16 "2021-09-21T07:41:07Z")
Thanks for your reply Stephen. I know there was a big shift between AWS and Elastic stack, same as MongoDb did a few years before. I understand and still love Elastic community. That said, in the current case, despite our cluster is managed by AWS it is still based on Elastic stack, not OpenSearch (v7.7.0). It seems also that the user who opened the case observed a "sudden" issue too and he didn't mention operating a AWS cluster. Actually I just want to know if there is a kind of dynamic update of plugins like TSVB whereas the whole Kibana version remain the same and if any how to prevent this. Sincerely, Vincent MATHON ---
**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\ **Post date:** [September 21, 2021, 2:40pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/17 "2021-09-21T14:40:03Z")
Hi @vincentditlevinz Thanks for the details and sorry that you had the issue, I am sure it was frustrating. > [@vincentditlevinz](#): > > It seems also that the user who opened the case observed a "sudden" issue too and he didn't mention operating a AWS cluster. It looks like we could never replicate the issue with the 7.10 version on Elastic Stack, Elastic Cloud nor just a Docker Image and did not seem to get much more info to help debug. With a quick look I did not see a bunch of these bugs reported from our users which I would expect as we have many TSVB users (including myself)... I suspect (not positive) these may be all related to what you encountered. > [@vincentditlevinz](#): > > Though I am still surprised to not have full control on TSVB visualization plugin updates on our AWS managed cluster. I would really appreciate having some insights to understand what was going on. We can not really comment on how AWS Managed Service work, and again I am not trying to discount the the AWS service it is very popular it is just that we (Elastic) have no insight on what happens behind the scene and how it is run / operated. I would suggest opening a ticket with AWS Support perhaps they can shed some light. From Elastic Cloud perspective we do not "Background Update" components / Kibana / plugins et... updates only occur user initiated. > [@vincentditlevinz](#): > > That said, in the current case, despite our cluster is managed by AWS it is still based on Elastic stack, not OpenSearch (v7.7.0). I The AWS ES code is a significant fork of the Elasticsearch / Kibana code going very far back much further than 7.7 ---
**Author:** ![vincentditlevinz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vincentditlevinz/32/94688_2.png) [@vincentditlevinz](https://discuss.elastic.co/u/vincentditlevinz)\ **Post date:** [September 21, 2021, 3:51pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/18 "2021-09-21T15:51:35Z")
Thanks for all these details Stephen. Sincerly, Vincent ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [October 19, 2021, 3:51pm UTC](https://discuss.elastic.co/t/tsvb-dont-work-only-on-count-aggregation/283457/19 "2021-10-19T15:51:50Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.