# Visualisation with unique values **URL:** \ **Category:** Kibana\ **Created:** [February 3, 2021, 11:17am UTC](https://discuss.elastic.co/t/visualisation-with-unique-values/263111 "2021-02-03T11:17:17Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Deny7](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@Deny7](https://discuss.elastic.co/u/Deny7)\ **Post date:** [February 3, 2021, 11:17am UTC](https://discuss.elastic.co/t/visualisation-with-unique-values/263111/1 "2021-02-03T11:17:17Z")
I have emails in my logs and I parse them like this: ``` "email:" "user1@gmail.com" "name:" "user1" "provider:" "gmail.com" ``` Now I want to make visualiation that will reflect unique providers in given timeframe, for example table like this: ``` "gmail.com"................................................. 343 "yahoo.com"..................................................134 ``` That means each record in "343" is for **unique** email address in selected timeframe. Can anybody help? ---
**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\ **Post date:** [February 3, 2021, 12:36pm UTC](https://discuss.elastic.co/t/visualisation-with-unique-values/263111/2 "2021-02-03T12:36:10Z")
You can do this by creating a chart using a terms aggregation of field provider on the x axis and the unique count / cardinality aggregation on the email field for the metric. ---
**Author:** ![Deny7](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@Deny7](https://discuss.elastic.co/u/Deny7)\ **Post date:** [February 3, 2021, 4:31pm UTC](https://discuss.elastic.co/t/visualisation-with-unique-values/263111/3 "2021-02-03T16:31:57Z")
@flash1293 Thanks. I would like to create one more where when I select week timeframe, I want to get unique provider per day, not the whole week. Lets say ``` Monday: user@gmail.com - 20 occurences in this day Tuesday: user@gmail.com - 10 occurences in this day Wendsday: troll@gmail.com - 10 occurences in this day ``` So the total for [gmail.com](http://gmail.com) in one week is 3 unique occurences regardless **[user@gmail.com](mailto:user@gmail.com)** is same for Monday and Tuesday. How can I do that? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 3, 2021, 4:32pm UTC](https://discuss.elastic.co/t/visualisation-with-unique-values/263111/4 "2021-03-03T16:32:10Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.