[Kibana]Data from Multiple Tables MySQL

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

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