# \[Kibana\]Data from Multiple Tables MySQL

**URL:** <https://discuss.elastic.co/t/kibana-data-from-multiple-tables-mysql/299867>\
**Category:** Kibana\
**Created:** [March 16, 2022, 2:23pm UTC](https://discuss.elastic.co/t/kibana-data-from-multiple-tables-mysql/299867 "2022-03-16T14:23:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![legolas\_bilbao](https://avatars.discourse-cdn.com/v4/letter/l/3da27b/32.png) [@legolas\_bilbao](https://discuss.elastic.co/u/legolas_bilbao)\
**Post date:** [March 16, 2022, 2:23pm UTC](https://discuss.elastic.co/t/kibana-data-from-multiple-tables-mysql/299867/1 "2022-03-16T14:23:49Z")

</div>

Good morning,

I've several tables

- assets (hostname, idos,oss, lastview)
- rules( idrule,idos,value)
- compliance(idrule,idos,date,valueserver)

and i wanna make / visualice tables like this

Assets  
OSSS Date1 Date2 Date3 Date4  
OS1 10 10 10 10  
OS2 8 10 10 10  
OS3 100 100 10 10  
Total

ComplianceOS1 Date1 Date2 Date3 Date4  
OK 85rules 85 rules 100 rules  
No OK 35 rules 35 rules 20 rules

All the information must be in the same Dashboard

regards

---

<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 13, 2022, 2:24pm UTC](https://discuss.elastic.co/t/kibana-data-from-multiple-tables-mysql/299867/2 "2022-04-13T14:24:09Z")

</div>

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