Calculate dynamically if granularity is not set

[Jaehui-Lee]

When sending a query, it would be nice to have a function that dynamically calculates the granularity when the granularity is not set.

In the (old) plugin I am currently using, if 'custom granularity' is not set, it is converted as follows:

interval	granularity
24 hour	15 minutes
1 month	1 hour
1 year	1 month

etc.

I guess with this part (https://github.com/grafana-druid-plugin/druidplugin/blob/33af5d544755a7bbcf7d72fcbd9673ef66a2840c/src/datasource.ts#L67)

However, when I tested the new version, I found that the feature is not there.
Currently, when I set Granularity to 'Simple:minute', 1 hour, 1 week, 1 month, and 1 year intervals all use granularity as minute.
If the number of panels is large and the time interval is long, refreshing can take a long time and consume a lot of memory due to the large amount of data being returned.

The version I am currently using is:
Grafana: v5.4.5
druid plugin : v0.0.5

The version I'm using for testing is:
Grafana: v9.3.6
druid plugin: v1.4.1

thank you !

[jbguerraz]

Hello @Jaehui-Lee
That would be an interesting feature indeed! Would you like to contribute it ? I'd be happy to help!