# How to show one entry per day **URL:** \ **Category:** Kibana\ **Created:** [December 8, 2023, 2:48pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913 "2023-12-08T14:48:56Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![soad20000](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@soad20000](https://discuss.elastic.co/u/soad20000)\ **Post date:** [December 8, 2023, 2:48pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/1 "2023-12-08T14:48:56Z")
Hello, I am on Elastic V8.10.4 and I have a dashboard for NTP that looks like this: ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/e/9e914861ccbd696fd68afd0a37a3427aa685af2c.png) I want it to show only one entry per day, instead of multiple per day like it currently does. How can I accomplish this? ---
**Author:** ![abiliocastro](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abiliocastro/32/129064_2.png) [@abiliocastro](https://discuss.elastic.co/u/abiliocastro)\ **Post date:** [December 8, 2023, 3:05pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/2 "2023-12-08T15:05:06Z")
Hi @soad20000 I think you have to aggregate by timestamp to accomplish what you want. Now, you are showing TOP10 values for that day. For example: for the day 2023-12-08 there will be 10 entries for that day. Maybe if you show average values for the day you then will have one entry per day. ---
**Author:** ![soad20000](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@soad20000](https://discuss.elastic.co/u/soad20000)\ **Post date:** [December 8, 2023, 4:48pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/3 "2023-12-08T16:48:47Z")
I am not sure what you mean by aggregate by timestamp, could you clarify that for me please? I split the metrics by minimum value of timestamp, and I'm getting closer to what I want but not exactly. Also changed the number of values being shown from 10 to 2. ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/0/50c1e8ec643302202f6c08d413fa45faba24493d.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/5/f57210b5970f5a787caa83f5be643222ed15163a.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/3/0336e9e05ff22079456d27ea1a7a16090f148854.png) I want the dates to be in one single column. ---
**Author:** ![soad20000](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@soad20000](https://discuss.elastic.co/u/soad20000)\ **Post date:** [December 8, 2023, 5:20pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/4 "2023-12-08T17:20:20Z")
Ok I've managed to get it to look the way I want it to. ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/3/a31523975ed13931099fb6ecdb1db620da28b75f.png) However, I noticed that the values are all the same in their respective categories across all dates. How can I make it use the exact value from the document? I see that the values are different in the documents. ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/3/13c3c5cf4d3e9ef874094b70bc5b1633dbd43a4e.png) It seems that it's taking the top value in that date range and using it for every row. If I change the date range to last 4 days the values change, same if I change it to the last 7 days too. ---
**Author:** ![abiliocastro](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abiliocastro/32/129064_2.png) [@abiliocastro](https://discuss.elastic.co/u/abiliocastro)\ **Post date:** [December 8, 2023, 7:30pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/5 "2023-12-08T19:30:41Z")
Please show the last configuration of the table Rows and Metrics. Maybe you have to inverse the things, put the @timestamp in the rows and the other fields in metrics using the top or last value. Did you get it? I did an example of it: ![Captura de tela 2023-12-08 164036](https://us1.discourse-cdn.com/elastic/original/3X/a/9/a9828c6505488b817e15a9fb8aa581e3fd52630b.png) ---
**Author:** ![soad20000](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@soad20000](https://discuss.elastic.co/u/soad20000)\ **Post date:** [December 8, 2023, 8:46pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/6 "2023-12-08T20:46:31Z")
When I try to follow your example the fields values disappear. ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/9/a9fb90926f0831ac5a82f5cb47e56a0103266c07.png) Removing the timestamp shows the values again. ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/c/cc25bfd87446c87b6585847794e253e6e0880587.png) The last configuration I used was this: ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/b/8b2fd7b2f53f983bcf4deab9278bad7beedf856a.png) ---
**Author:** ![abiliocastro](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abiliocastro/32/129064_2.png) [@abiliocastro](https://discuss.elastic.co/u/abiliocastro)\ **Post date:** [December 8, 2023, 8:54pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/7 "2023-12-08T20:54:26Z")
Did you select DateHistogram and marked Customize time interval and setted it to 1 day? When you tried to put the @timestamp field in the row? ---
**Author:** ![soad20000](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@soad20000](https://discuss.elastic.co/u/soad20000)\ **Post date:** [December 8, 2023, 8:55pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/8 "2023-12-08T20:55:23Z")
Yes it's currently set up like this: ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/5/f5ca85b606912bea1bd313508a545950e41c75c1.png) ---
**Author:** ![abiliocastro](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abiliocastro/32/129064_2.png) [@abiliocastro](https://discuss.elastic.co/u/abiliocastro)\ **Post date:** [December 8, 2023, 8:57pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/9 "2023-12-08T20:57:01Z")
Now try to check if your query interval range is big enough to get the data ---
**Author:** ![soad20000](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@soad20000](https://discuss.elastic.co/u/soad20000)\ **Post date:** [December 8, 2023, 8:58pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/10 "2023-12-08T20:58:49Z")
It should be, I have it set to 1 month currently. Is this the query interval range you are referring to? ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/8/b8f657ef473aeeb8e637344484ed49db645f4ba1.png) ---
**Author:** ![soad20000](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@soad20000](https://discuss.elastic.co/u/soad20000)\ **Post date:** [December 8, 2023, 9:06pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/11 "2023-12-08T21:06:14Z")
Ahhhh nevermind I'm an idiot. I started collecting those logs a few days ago, so of course there is no data from before. I just had to scroll down 😅 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/4/a467b56a0031d2a80306bedda11520c78da45815.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 5, 2024, 9:06pm UTC](https://discuss.elastic.co/t/how-to-show-one-entry-per-day/348913/12 "2024-01-05T21:06:35Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.