Hi there, I am working with a pivot table that contains some time fields. The problem is that the query is grouping the rows of those fields with the year as the default granularity. How can I specify the granularity for a specific row?
The following is an example code of what I have:
let provider = cf.provider("Elasticsearch"); let source = provider.source('source_name'); let metric = new cf.Metric("count"); let myData = source .rows("timefield") .columns() .metrics(metric); let myChart = myData.graph("Pivot Table") .limit(1000) .set("autoSizeColumns", true) .execute();
After execute that, the result is the one bellow:
Any guidance or suggestions?