# Terms aggregation on both axes of line graph and dot size using doc count

**URL:** <https://discuss.elastic.co/t/terms-aggregation-on-both-axes-of-line-graph-and-dot-size-using-doc-count/195063>\
**Category:** Kibana\
**Created:** [August 13, 2019, 4:37pm UTC](https://discuss.elastic.co/t/terms-aggregation-on-both-axes-of-line-graph-and-dot-size-using-doc-count/195063 "2019-08-13T16:37:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nitesh.nawada](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nitesh.nawada/32/52211_2.png) [@nitesh.nawada](https://discuss.elastic.co/u/nitesh.nawada)\
**Post date:** [August 13, 2019, 4:37pm UTC](https://discuss.elastic.co/t/terms-aggregation-on-both-axes-of-line-graph-and-dot-size-using-doc-count/195063/1 "2019-08-13T16:37:26Z")

</div>

I have documents like this  
{  
"\_index": "bbd-smartaccess",  
"\_type": "transaction",  
"\_id": "361989",  
"\_version": 1,  
"\_score": null,  
"\_source": {  
"transaction\_id": 361989,  
"@timestamp": "2019-08-12T10:23:41.154Z",  
"lastname": "Sen",  
"firstname": "Ajay",  
"employeecode": "001",  
"cardholder": "Ajay Sen (0003202870)",  
"transactiontime": "2019-08-09T10:17:25.000Z",  
"transactiontype": "OFFICE\_OUT",  
"cardno": "0003202870",  
"@version": "1"  
},  
"fields": {  
"time\_of\_day": [  
"15:47"  
],  
"@timestamp": [  
"2019-08-12T10:23:41.154Z"  
],  
"transactiontime": [  
"2019-08-09T10:17:25.000Z"  
],  
"slot\_of\_day": [  
"15-Q2"  
],  
"day\_of\_week": [  
"#5 Friday"  
]  
},  
"sort": [  
1565605421154  
]  
}

I want to visualize a scatter plot with `day_of_week` on **y-axis** , `slot_of_day` on **x-axis** and **dot size** representing the `doc count`.

I am trying to use line graph for this (with line option off). I am able to plot `slot_of_day` on **x-axis** and **dot size** representing the `doc count`, but can't see any option to plot `day_of_week` on **y-axis**. Y-axis seems to accept only numeric data.

Can someone suggest me a way to achieve this?

---

<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:** [August 13, 2019, 9:59pm UTC](https://discuss.elastic.co/t/terms-aggregation-on-both-axes-of-line-graph-and-dot-size-using-doc-count/195063/2 "2019-08-13T21:59:56Z")

</div>

Kibana visualizations don't currently support scatter plots with unaggregated data. You might be able to accomplish what you're hoping inside of Canvas, however.

---

<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:** [September 10, 2019, 9:59pm UTC](https://discuss.elastic.co/t/terms-aggregation-on-both-axes-of-line-graph-and-dot-size-using-doc-count/195063/3 "2019-09-10T21:59:56Z")

</div>

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