Bar chart counts, binned every two weeks

[TylerT]

Hello,

I have time stamped data (recognized as date/time with subfields) and would like to create a bar chart with count of records in each two week (or any desired time span) bin like this...

What is the best way to accomplish this?

Thank you,

Tyler

[AkshayHarshe]

Hi @TylerT,

Unfortunately, none of our charts have the capability to summarize data in that way. To achieve this, we need some data manipulation or summarization, which I think might be easier to do using SQL. 

The closest you can come is by using Timeseries, where you zoom in on the chart to achive certain interval.

[TylerT]

@AkshayHarshe,
What is the process for going the SQL route?  Is this accomplished in Insights or are you thinking some ETL outside of Insights?  Thx.

Tyler

[AkshayHarshe]

@TylerT I am thinking of ETL outside of insights. Insighs will not modify data.