Can I get relation between country state and cities in a measurements and also relation between two columns in a table

Hello @saurav_srivastav,
You can use the InfluxDB UI to create dashboards. These dashboards you create. can be populated to view/visualize data however you want. You can use influxql (v1) or flux(v1.7+) to perform data exploration, analysis, and transformation. You can also create alerts (v1) and tasks (v2).
What devices are you using?