hourly breakdown of data

[sanjujeeboy]

Hi Team,

I have a table like below which has date campaign clicks and hour.

Every hour when data gets pulled from DB, its a cumulative hourly pull

Eg:  when data is fetched at 3am, it fetches from 12am -3am  & when data is fetched at 4am, it fetches from 12am -4am

So my requirement is to get a hourly breakdown for the clicks for each hour as shown in Output

How to achieve this in back end script?

					Output
Date	campaign	Clicks	Hour		Hour Breakdown	Clicks
24/11/2020	A	100	1		1	100
24/11/2020	A	250	2		2	150
24/11/2020	A	400	3		3	150
24/11/2020	A	700	4		4	300

@Kushal_Chawda @sunny_talwar @Taoufiq_Zarra 

[Kushal_Chawda]

@sanjujeeboy  yes based on requirement if want them in order by you can use them. I don't think you need to add them in if condition but you can try