# Breaking limitations of visualization builder

**URL:** https://discuss.elastic.co/t/breaking-limitations-of-visualization-builder/172885
**Category:** Kibana
**Created:** [March 19, 2019, 3:17am UTC](https://discuss.elastic.co/t/breaking-limitations-of-visualization-builder/172885 "2019-03-19T03:17:34Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Primordial](https://avatars.discourse-cdn.com/v4/letter/p/ea5d25/32.png) [@Primordial](https://discuss.elastic.co/u/Primordial)
#### Post date: [March 19, 2019, 3:17am UTC](https://discuss.elastic.co/t/breaking-limitations-of-visualization-builder/172885/1 "2019-03-19T03:17:34Z")

</div>

I am working on trying to display a metric which aims to measure the number of users of the application that have used the platform for at least 5 unique days in a quarter.

Every use is sent to a log file document, with the relevant timestamps being used to track unique days of use.

I can correctly achieve the desired count value returned in a JSON object from the Kibana Dev Tools Console, however, the visualisation builder for a metric does not allow for me to create an equivalently complex query to retrieve this value. Is there a way of directing writing the full query with all necessary aggregations and bucket filters to create a visualisation or am I limited by the restrictions of the UI tool?

---

<div class="post-metadata">

### Author: ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [March 20, 2019, 5:01pm UTC](https://discuss.elastic.co/t/breaking-limitations-of-visualization-builder/172885/2 "2019-03-20T17:01:56Z")

</div>

Sure, you can actually use the full query DSL in the query bar when you have Lucene selected as your query language. So you should be able to take the JSON and paste it directly into the query bar to achieve what you want.

---

<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: [April 17, 2019, 5:08pm UTC](https://discuss.elastic.co/t/breaking-limitations-of-visualization-builder/172885/3 "2019-04-17T17:08:14Z")

</div>

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