# \#lens **URL:** https://discuss.elastic.co/tag/lens/42.md [Latest](https://discuss.elastic.co/latest.md) · [Categories](https://discuss.elastic.co/categories.md) · [Tags](https://discuss.elastic.co/tags.md) --- ## [Averaging last values of multiple beats](https://discuss.elastic.co/t/averaging-last-values-of-multiple-beats/386182)
**Author:** [@Benjamin\_Klein](https://discuss.elastic.co/u/Benjamin_Klein)\ **Replies:** 4\ **Last updated:** [May 7, 2026, 6:28pm UTC](https://discuss.elastic.co/t/averaging-last-values-of-multiple-beats/386182 "2026-05-07T18:28:51Z")
I have a collection of Heartbeat monitors pinging several different hosts. Each host has multiple services being pinged (by different beats). Is there a way to display, for each host, either the number of beats that came… --- ## [Freeze one or more columns in Lens Table visualisation](https://discuss.elastic.co/t/freeze-one-or-more-columns-in-lens-table-visualisation/378300)
**Author:** [@tallakh](https://discuss.elastic.co/u/tallakh)\ **Replies:** 4\ **Last updated:** [April 29, 2026, 1:15pm UTC](https://discuss.elastic.co/t/freeze-one-or-more-columns-in-lens-table-visualisation/378300 "2026-04-29T13:15:42Z")
I have a Lens Table that contains quite many columns which leads to a lot of horisontal scrolling. Is it possible to pin/freeze columns? That would make it a lot easier to keep track when scrolling? It would also be rea… --- ## [Lookup join and visualization on that join](https://discuss.elastic.co/t/lookup-join-and-visualization-on-that-join/385464)
**Author:** [@jai2](https://discuss.elastic.co/u/jai2)\ **Replies:** 5\ **Last updated:** [March 18, 2026, 10:36am UTC](https://discuss.elastic.co/t/lookup-join-and-visualization-on-that-join/385464 "2026-03-18T10:36:45Z")
Consider the following, I have populated 2 indices, both have a task\_id field and I want to join these 2 indices on task\_id to create a dashboard in Kibana. Firstly, I cannot create a data view out of a lookup join. I … --- ## [Lens color by value issue when using formula metrics](https://discuss.elastic.co/t/lens-color-by-value-issue-when-using-formula-metrics/384284)
**Author:** [@cgchamb](https://discuss.elastic.co/u/cgchamb)\ **Replies:** 3\ **Last updated:** [December 29, 2025, 12:17am UTC](https://discuss.elastic.co/t/lens-color-by-value-issue-when-using-formula-metrics/384284 "2025-12-29T00:17:07Z")
Elasticsearch: 8.19.5, Kibana: 8.19.5. I’m using the Sample Flight data set and I’ve created a Lens Table with “Rows: Top 5 values of Carrier” and Metric “Count of DestAirportID”. I set the metric to color by value (Cel… --- ## [LENS and TSVB showing different result](https://discuss.elastic.co/t/lens-and-tsvb-showing-different-result/384110)
**Author:** [@Arshukla](https://discuss.elastic.co/u/Arshukla)\ **Replies:** 4\ **Last updated:** [December 16, 2025, 4:10pm UTC](https://discuss.elastic.co/t/lens-and-tsvb-showing-different-result/384110 "2025-12-16T16:10:15Z")
Hi team, Could you please help why TSVB is showing 0 values for same field and LENS is having values. Whereas in both scenarios aggregation is sum --- ## [Params.\_interval in LENS](https://discuss.elastic.co/t/params-interval-in-lens/384065)
**Author:** [@Arshukla](https://discuss.elastic.co/u/Arshukla)\ **Replies:** 1\ **Last updated:** [December 15, 2025, 12:13pm UTC](https://discuss.elastic.co/t/params-interval-in-lens/384065 "2025-12-15T12:13:14Z")
Hi I am using params.\_interval in TSVB, and want to use the same interval thing in LENS. What is the way to do the same in LENS? As in denominator I want to use the interval in LENS, for preparing a tabular dashboard --- ## [How to create a network utilization of inbound traffic and outbound like solarwind](https://discuss.elastic.co/t/how-to-create-a-network-utilization-of-inbound-traffic-and-outbound-like-solarwind/383078)
**Author:** [@Syed\_Yaseen\_Arham](https://discuss.elastic.co/u/Syed_Yaseen_Arham)\ **Replies:** 2\ **Last updated:** [October 30, 2025, 8:07am UTC](https://discuss.elastic.co/t/how-to-create-a-network-utilization-of-inbound-traffic-and-outbound-like-solarwind/383078 "2025-10-30T08:07:03Z")
we have field called ifInOctets which incremental field and its values in bytes. ifSpeed is in GBPs polling inverval 120 seconds My Formula ((counter\_rate(max(ifInOctets))\*8)/60)/average(ifSpeed) i tried to this but… --- ## [Kibana Visualization date\_histogram weekly start day: Sunday (Start of Week) in Dashboard](https://discuss.elastic.co/t/kibana-visualization-date-histogram-weekly-start-day-sunday-start-of-week-in-dashboard/382877)
**Author:** [@josh\_tran](https://discuss.elastic.co/u/josh_tran)\ **Replies:** 2\ **Last updated:** [October 24, 2025, 10:15am UTC](https://discuss.elastic.co/t/kibana-visualization-date-histogram-weekly-start-day-sunday-start-of-week-in-dashboard/382877 "2025-10-24T10:15:01Z")
I want weekly date\_histogram function to start on Sunday in Kibana dashboards, but they currently start on Monday (ISO week). I’m using Kibana Lens with Elasticsearch 9.0.4. I’ve tried adjusting dateFormat:dow settings t… --- ## [Set more than 10000 number of values in data tables](https://discuss.elastic.co/t/set-more-than-10000-number-of-values-in-data-tables/375766)
**Author:** [@Ruben\_Mendez](https://discuss.elastic.co/u/Ruben_Mendez)\ **Replies:** 3\ **Last updated:** [September 10, 2025, 11:15am UTC](https://discuss.elastic.co/t/set-more-than-10000-number-of-values-in-data-tables/375766 "2025-09-10T11:15:59Z")
Hi, I'm trying to fetch more than 10000 number of values in my kibana data table visualization. I get the error above, I edited index.max\_result\_window in all my elasticSearch indexes. But I get the same error I can… --- ## [Changing weekly aggregations to start on Sundays in TSVB visuals](https://discuss.elastic.co/t/changing-weekly-aggregations-to-start-on-sundays-in-tsvb-visuals/379015)
**Author:** [@tflowers94](https://discuss.elastic.co/u/tflowers94)\ **Replies:** 1\ **Last updated:** [June 24, 2025, 1:07pm UTC](https://discuss.elastic.co/t/changing-weekly-aggregations-to-start-on-sundays-in-tsvb-visuals/379015 "2025-06-24T13:07:11Z")
Hello, We're using the TSVB visualization in Kibana to display calculated rates over time using the Filter Ratio aggregation within a time series. We prefer to analyze our data on a weekly basis (sun–sat). However, whe… --- ## [How to know what Elasticsearch endpoint is used by Kibana to make graphs?](https://discuss.elastic.co/t/how-to-know-what-elasticsearch-endpoint-is-used-by-kibana-to-make-graphs/378529)
**Author:** [@philyeanaeknss](https://discuss.elastic.co/u/philyeanaeknss)\ **Replies:** 5\ **Last updated:** [May 27, 2025, 9:02am UTC](https://discuss.elastic.co/t/how-to-know-what-elasticsearch-endpoint-is-used-by-kibana-to-make-graphs/378529 "2025-05-27T09:02:11Z")
I have URI like ../discover#/?\_g=(filters:!(),refreshInterval:(pause:!t,value:0),time:(from:now%2Fd,to:now%2Fd))&\_a=(columns:!(\_source),filters:!(),index:{index},interval:auto,query:(language:kuery,query:%27%27),sort:!(… --- ## [Sum aggregation Giving incorrect resumt](https://discuss.elastic.co/t/sum-aggregation-giving-incorrect-resumt/378329)
**Author:** [@Arshukla](https://discuss.elastic.co/u/Arshukla)\ **Replies:** 14\ **Last updated:** [May 23, 2025, 4:46pm UTC](https://discuss.elastic.co/t/sum-aggregation-giving-incorrect-resumt/378329 "2025-05-23T16:46:03Z")
I'm encountering an issue in Kibana. When I check a particular variable in Discover, I can see that it has a value of 0 on four different dates. For the remaining dates, there is no data shown for this variable in Discov… --- ## [Kibana 9.0 - "vibrant color palette" unusable](https://discuss.elastic.co/t/kibana-9-0-vibrant-color-palette-unusable/377821)
**Author:** [@allatrue](https://discuss.elastic.co/u/allatrue)\ **Replies:** 5\ **Last updated:** [May 9, 2025, 12:07pm UTC](https://discuss.elastic.co/t/kibana-9-0-vibrant-color-palette-unusable/377821 "2025-05-09T12:07:11Z")
Hi everybody, I would like to ask the designers of the new "vibrant color palette", if they ever tested it with Lens visualizations? Very useful function of highlighting the line when hovering it in legend, works now on… --- ## [Use days\_of\_month](https://discuss.elastic.co/t/use-days-of-month/377907)
**Author:** [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Replies:** 1\ **Last updated:** [May 8, 2025, 9:55am UTC](https://discuss.elastic.co/t/use-days-of-month/377907 "2025-05-08T09:55:51Z")
Hi I would like to create line graph in Lens and use sum(price)/days\_of\_month how do I get days\_of\_month ? which is 31,28,31,30 etc.. --- ## [Drill-down support in kibana Enterprise 2022.10.4 (build 117134)](https://discuss.elastic.co/t/drill-down-support-in-kibana-enterprise-2022-10-4-build-117134/377560)
**Author:** [@Guy\_Levin](https://discuss.elastic.co/u/Guy_Levin)\ **Replies:** 0\ **Last updated:** [April 28, 2025, 7:14am UTC](https://discuss.elastic.co/t/drill-down-support-in-kibana-enterprise-2022-10-4-build-117134/377560 "2025-04-28T07:14:15Z")
I have Kibana Enterprise 2022.10.4 (build 117134). I noticed that when I try to add a drill-down, there are two choices. The "go to dashboard" choice is enabled. The "go to url" is disabled. Is this disablement becau… --- ## [Percentage breakdown for each subgroup](https://discuss.elastic.co/t/percentage-breakdown-for-each-subgroup/376750)
**Author:** [@mat-bro](https://discuss.elastic.co/u/mat-bro)\ **Replies:** 2\ **Last updated:** [April 3, 2025, 4:01pm UTC](https://discuss.elastic.co/t/percentage-breakdown-for-each-subgroup/376750 "2025-04-03T16:01:32Z")
Hi, I am trying to create a table in Kibana Lens (8.13) to calculate statistics for some products. In particular, for each month and product type, I would need to calculate the number of products considered and the perc… --- ## [Lens Metric with Graph Underlay](https://discuss.elastic.co/t/lens-metric-with-graph-underlay/376035)
**Author:** [@ArielC](https://discuss.elastic.co/u/ArielC)\ **Replies:** 2\ **Last updated:** [March 17, 2025, 10:31pm UTC](https://discuss.elastic.co/t/lens-metric-with-graph-underlay/376035 "2025-03-17T22:31:47Z")
I would like to create a Metric visualization using Lens similar to one mentioned in the post below: https://discuss.elastic.co/t/metric-background-change-based-on-last-week-value/345082 How can I add a graph under… --- ## [Kibana: How to obtain the last value of a date field](https://discuss.elastic.co/t/kibana-how-to-obtain-the-last-value-of-a-date-field/374817)
**Author:** [@InesCM](https://discuss.elastic.co/u/InesCM)\ **Replies:** 4\ **Last updated:** [February 21, 2025, 10:17am UTC](https://discuss.elastic.co/t/kibana-how-to-obtain-the-last-value-of-a-date-field/374817 "2025-02-21T10:17:15Z")
Hi! I have an index with many documents per device and day. One of the fields is a date field called "latest\_device\_activity\_dt". Please note that this is not the field that the index is referred to, is a date field tha… --- ## [How to configure Daily Average Sum Calculation in Lens? ](https://discuss.elastic.co/t/how-to-configure-daily-average-sum-calculation-in-lens/374387)
**Author:** [@Rafael\_Mendonca](https://discuss.elastic.co/u/Rafael_Mendonca)\ **Replies:** 2\ **Last updated:** [February 12, 2025, 4:41pm UTC](https://discuss.elastic.co/t/how-to-configure-daily-average-sum-calculation-in-lens/374387 "2025-02-12T16:41:53Z")
I have a "Data Table" visualization configured, where I sum the daily average of a specific value, as shown in the image below. Now, I'm trying to recreate this view in Lens, but I can't achieve the same calculation,… --- ## [Rank functions not showing](https://discuss.elastic.co/t/rank-functions-not-showing/374407)
**Author:** [@3isenHeiM](https://discuss.elastic.co/u/3isenHeiM)\ **Replies:** 3\ **Last updated:** [February 12, 2025, 1:13pm UTC](https://discuss.elastic.co/t/rank-functions-not-showing/374407 "2025-02-12T13:13:29Z")
Hi, Between 2 ELK instances of the same version (8.12.2), and the same data type (keyword), the ranking functions proposed are not the same. On the first one, I can ran the vertical axis of my bar graph percentage by A… --- ## [Rank customers by counter\_rate](https://discuss.elastic.co/t/rank-customers-by-counter-rate/374227)
**Author:** [@Annxii](https://discuss.elastic.co/u/Annxii)\ **Replies:** 1\ **Last updated:** [February 12, 2025, 11:36am UTC](https://discuss.elastic.co/t/rank-customers-by-counter-rate/374227 "2025-02-12T11:36:06Z")
Hi, I'm trying to make a tabular visualization of the top 10 customers measure on req/sec. I have a monotonically increasing counter with the customer as an attribute. My counter\_rate is working fine, my issue is that … --- ## [Visualize flattened fields in Kibana dashboard](https://discuss.elastic.co/t/visualize-flattened-fields-in-kibana-dashboard/368112)
**Author:** [@HermannSamimi](https://discuss.elastic.co/u/HermannSamimi)\ **Replies:** 3\ **Last updated:** [February 12, 2025, 8:35am UTC](https://discuss.elastic.co/t/visualize-flattened-fields-in-kibana-dashboard/368112 "2025-02-12T08:35:03Z")
Hello, I was wondering if there is a possibility to visualize flattened fields in a simple table in Lens. --- ## [Kibana Lens Table: Filter Table Rows](https://discuss.elastic.co/t/kibana-lens-table-filter-table-rows/373286)
**Author:** [@lavaplanet](https://discuss.elastic.co/u/lavaplanet)\ **Replies:** 3\ **Last updated:** [January 17, 2025, 8:44am UTC](https://discuss.elastic.co/t/kibana-lens-table-filter-table-rows/373286 "2025-01-17T08:44:02Z")
Hi there, I want to create a Kibana lens table where the rows are divided based on field values. However, I want to filter the individual rows by specific values. I only want to see all rows starting with Keyword\_Aor… --- ## [Kibana Formula using ifelse with multiple conditions](https://discuss.elastic.co/t/kibana-formula-using-ifelse-with-multiple-conditions/370983)
**Author:** [@bjornbear](https://discuss.elastic.co/u/bjornbear)\ **Replies:** 5\ **Last updated:** [December 13, 2024, 1:57pm UTC](https://discuss.elastic.co/t/kibana-formula-using-ifelse-with-multiple-conditions/370983 "2024-12-13T13:57:12Z")
How can I combine multiple conditions in an ifelse statement? I need to avoid a situation where I divide by zero e.g. any of the following values: count() and count(shift='1w')+count(shift='2w') may not be 0 to avoid a N… --- ## [Lens - Dotted Lines](https://discuss.elastic.co/t/lens-dotted-lines/371152)
**Author:** [@erikg](https://discuss.elastic.co/u/erikg)\ **Replies:** 6\ **Last updated:** [December 2, 2024, 4:05pm UTC](https://discuss.elastic.co/t/lens-dotted-lines/371152 "2024-12-02T16:05:26Z")
Hello, I was wondering how I can create something like this: Where it just connects the points and creates like a cohesive dotted line. Is there a way I can just enable , if the data points are far apart make it a … --- ## [Display another field as the result of a Lens formula](https://discuss.elastic.co/t/display-another-field-as-the-result-of-a-lens-formula/370932)
**Author:** [@snicoll](https://discuss.elastic.co/u/snicoll)\ **Replies:** 1\ **Last updated:** [November 22, 2024, 8:55am UTC](https://discuss.elastic.co/t/display-another-field-as-the-result-of-a-lens-formula/370932 "2024-11-22T08:55:43Z")
Hello, Assume an index which contains entries with a version field, something like: "version": { "properties": { "id": { "type": "keyword" }, "major": { "type": "keyword" }, "minor": {… --- ## [Kibana getting hanged, and getting Wait response or Kill page](https://discuss.elastic.co/t/kibana-getting-hanged-and-getting-wait-response-or-kill-page/369194)
**Author:** [@Arshukla](https://discuss.elastic.co/u/Arshukla)\ **Replies:** 4\ **Last updated:** [October 23, 2024, 6:27pm UTC](https://discuss.elastic.co/t/kibana-getting-hanged-and-getting-wait-response-or-kill-page/369194 "2024-10-23T18:27:25Z")
Hi Team, I am using 8.14 version of Kibana, and when I am trying to do changes in a LENS tabular dashboard, my dashboard is becoming too slow. Sometimes it even take 2-3 mins to load even loading data for last 4 hours … --- ## [How to apply range using calculated metric field](https://discuss.elastic.co/t/how-to-apply-range-using-calculated-metric-field/368846)
**Author:** [@kishorkumar](https://discuss.elastic.co/u/kishorkumar)\ **Replies:** 6\ **Last updated:** [October 17, 2024, 9:27am UTC](https://discuss.elastic.co/t/how-to-apply-range-using-calculated-metric-field/368846 "2024-10-17T09:27:09Z")
I wanted to create the buckets for the total sales on the basis of the calculated value form metric aggs in lens i have total field in doc so if use agg of avg in lens then i want to create the range built on top of th… --- ## [How to make now to be dynamic in the date \> now-1M](https://discuss.elastic.co/t/how-to-make-now-to-be-dynamic-in-the-date-now-1m/368847)
**Author:** [@kishorkumar](https://discuss.elastic.co/u/kishorkumar)\ **Replies:** 1\ **Last updated:** [October 16, 2024, 7:29am UTC](https://discuss.elastic.co/t/how-to-make-now-to-be-dynamic-in-the-date-now-1m/368847 "2024-10-16T07:29:53Z")
i am trying to create last month sales lens where i have added the filter of the date \>= now-1M/M AND date \< now/M so lets i am in oct then i want to see sep sales. and if i change the end from above globla time filte… --- ## [Kibana data normalization](https://discuss.elastic.co/t/kibana-data-normalization/368036)
**Author:** [@47bit](https://discuss.elastic.co/u/47bit)\ **Replies:** 1\ **Last updated:** [October 1, 2024, 9:20am UTC](https://discuss.elastic.co/t/kibana-data-normalization/368036 "2024-10-01T09:20:58Z")
I have a dataset that contains data like this: IP, event type, ... IP1, EventType1, ... IP2, EventType2, ... IP1, EventType2, ... IP1, EventType1, ... IP3, EventType2, ... I want to show count events of every eve… [Next page](https://discuss.elastic.co/tag/lens/42.md?match_all_tags=true&page=1&tags%5B%5D=lens)