Showing results for 
Search instead for 
Did you mean: 
MarkAKL Frequent Visitor
Frequent Visitor

Time intelligence with half-hourly data

I have several years of data collected at half-hourly intervals. I wish to compare (for example) all the half-hourly data for January 1st 2018 with January 1st 2017 in a graph, overlaying one day's data over the other, at the half-hour level, i.e. not summed for the day.


The two dates need not be infinitely variable with respect to each other - sticking to this year / last year would be OK.


I haven't been able to do this with time intelligence functions as this can only drill down to Date level.


I would welcome any suggestions.



Community Support Team
Community Support Team

Re: Time intelligence with half-hourly data

Hi @MarkAKL,


Please follow this blog to share more detailed information.



Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MarkAKL Frequent Visitor
Frequent Visitor

Re: Time intelligence with half-hourly data

Sample data below:

Interval EndEnergy kWh
Thu 01 Jan 2015 00:30212.93
Thu 01 Jan 2015 01:00219.30
Thu 01 Jan 2015 01:30204.80
Thu 01 Jan 2015 02:00204.86
Thu 01 Jan 2015 02:30203.87
Thu 01 Jan 2015 03:00203.74
Thu 01 Jan 2015 03:30199.17
Thu 01 Jan 2015 04:00183.71
Thu 01 Jan 2015 04:30182.40
Thu 01 Jan 2015 05:00190.02
Thu 01 Jan 2015 05:30225.92
Thu 01 Jan 2015 06:00251.01
Thu 01 Jan 2015 06:30272.35
Thu 01 Jan 2015 07:00276.90
Thu 01 Jan 2015 07:30252.19
Thu 01 Jan 2015 08:00246.66


Ideally I would like to compare the individual data points (i.e. not summed) across time periods, e.g. Jan-2018 with Jan-2017, or week1-2017 with week1-2018, etc, etc.