# Use case in Kibana

**URL:** <https://discuss.elastic.co/t/use-case-in-kibana/121531>\
**Category:** Kibana\
**Created:** [February 26, 2018, 5:21pm UTC](https://discuss.elastic.co/t/use-case-in-kibana/121531 "2018-02-26T17:21:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tomak](https://avatars.discourse-cdn.com/v4/letter/t/d9b06d/32.png) [@tomak](https://discuss.elastic.co/u/tomak)\
**Post date:** [February 26, 2018, 5:21pm UTC](https://discuss.elastic.co/t/use-case-in-kibana/121531/1 "2018-02-26T17:21:22Z")

</div>

I have a db full of offers from different suppliers. These offers are made for different profiles at different dates and have each a price.

I would like to visualise this in Kibana

I would like to have one line per date.

On that line I would like to see the minimal offer of every supplier. The minimal offer all-round for that date, the default offer (one offer is the "default offer") and the difference between the default and the minimal offer.

How can I do this?

---

<div class="post-metadata">

**Author:** ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)\
**Post date:** [February 27, 2018, 11:11pm UTC](https://discuss.elastic.co/t/use-case-in-kibana/121531/2 "2018-02-27T23:11:28Z")

</div>

Use a data table and add each of those as a metric.

---

<div class="post-metadata">

**Author:** ![tomak](https://avatars.discourse-cdn.com/v4/letter/t/d9b06d/32.png) [@tomak](https://discuss.elastic.co/u/tomak)\
**Post date:** [February 28, 2018, 8:35am UTC](https://discuss.elastic.co/t/use-case-in-kibana/121531/3 "2018-02-28T08:35:59Z")

</div>

This is one of the lines of my db:

```
{"index":{"_id":"5a66751de4b09094a99b173c"}}
{"date":"09-2013","profile":"P1","supplier":"Offre de base","consumerType":"professional","productName":"Offre de base","dgo":"DGA","consumption":"65877.0","price":3694.0060701239668}

```

I don't see how I can make it work.

Somehow, my visualisation should add a column for every supplier but it doesn't know how many there are

The best I manage to do is have a line for each date, supplier, showing the minimal offer of that supplier and the minimal offer for that date

for example one line

```
01-2018 Shell 0.12 0.10

```

But I would like all the suppliers to appear as columns with one line per date and the minimal offer for that date for each supplier.

```
01-2018 0.12 0.10 1 1.10 2.3
```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 28, 2018, 8:36am UTC](https://discuss.elastic.co/t/use-case-in-kibana/121531/4 "2018-03-28T08:36:03Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.