We are seeking your support for information on Drag and Drop functionalities in Grafana. Drag and Drop functionality means all variables (columns) of a particular table are available for selection in view panel, and end user can drag and drop those variables into the panel for preparing graphs. This functionality is available in tools like Power BI or Tableau. There is no need of SQL queries for preparing dashboards or graphs, as the same can be performed by drag and drop. Do grafana support this functionality?
Thank you for your question. There is no need to ask it twice with identical
wording.
I believe the answer is “no”, but someone else might have looked at this idea
in more detail than I have.
Antony.
If the client is not familiar with SQL language, in that case he/she will not be able to use Grafana for making dashboards. Is there any alternative or solution related to this query
Firstly, I disagree. Yoiu do not have to be familiar with SQL to build
Grafana panels and dashboards - that is what the Query Builder is for - to
help you create a query without having to know the language it gets created
in.
Secondly, SQL as such would only be used for certain back-end data stores (the
ones which support SQL, such as Postgres). Plenty of the other data stores
either have something similar to, but much simpler than, SQL (InfluxDB for
example), or else use a quite different query language altogether.
Finally, if someone is supposed to be creating Grafana dashboards, they need
to have a good understanding of the data they’re working with and the
visualisations of it that would be useful, so what’s the problem with learning
at least the basics of SQL?
Antony.
Thanks for your revert. I am using Clickhouse as Database for building Dashboards, and for same SQL is the language used for building panels and Dashboards.
Can you go through the screenshot and suggest me, how I can avoid use of SQL for building dashboard
Click on the “pencil” icon (it should say “Toggle text edit mode” if you hover
the pointer on it) and you will switch from the “Raw” editing mode to the
“Query Builder” mode, which offers you a series of drop-down selections and
variable name fields, together with the aggregation functions supported by your
data store.
This will enable you to create queries without knowledge of the query
language.
The Query Builder is more restricted than the Raw editing mode in what you can
end up with, but that’s the trade-off between something being simple and not
needing knowledge of the query language, and the full flexibility of writing
your own queries.
Good luck 
Antony.
Thanks again. Although this hasn’t helped the cause, but I appreciate your time and efforts.
This topic was automatically closed after 365 days. New replies are no longer allowed.