Support the actual query granularity of the datasource

[nevets1219]

In Pivot, we only have granularity of one minute, five minute, hourly, daily, and weekly which means we can't specify a granularity in Pivot that matches our query granularity. I tried using the next lower granularity but the timeseries shown is fairly spiky and doesn't really portray what's actually happening.

For one of our datasource, we have 10 minute query granularity with hourly segment granularity. The followings are table and timeseries from Pivot with five minute and hourly granularity:

5-minute-granularity

Hourly-granularity

Please let me know if you need any other information or feel that I may be doing something wrong.

[vogievetsky]

have you tried setting granularities ?https://github.com/implydata/pivot/blob/master/docs/configuration.md#dimensions

try: ['PT10M', 'PT30M', 'PT1H', 'P1D', 'P1W']

[nevets1219]

I generated a config and added what you suggested to the config for my desired datasource:

      - name: __time
        title: Time
        kind: time
        granularities: ['PT10M', 'PT30M', 'PT1H', 'P1D', 'P1W']
        expression: $__time

Then I restarted Pivot, however I don't see the change reflected in the UI for my datasource, it's still using the 5 default granularities. Nothing strange in the logs indicating anything wrong, any thoughts?

[evasomething]

Hi, what version of pivot are you running?

[nevets1219]

@evasomething We are using 0.8.26

EDIT: It looks like it's a feature in 0.8.28 ?

[vogievetsky]

Yep! @evasomething added that feature as part of 0.8.28 (https://github.com/implydata/pivot/blob/master/CHANGELOG.md#0828)

Going to close this issue as it is already fixed. Please file an issue if you experience any problem after you upgrade.