Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
@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