Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I want to define hourly time slots (midnight to 1 a.m., 1 to 2 a.m., ... 3 p.m. to 4 p.m. and so on) to follow the activity throughout the day and identify the period of the day when it there is no more charge.
Can you help me ?
thanks in advance
Dayname(YourField) + Hour(YourField)/24
If you want them as a string rather than a timestamp, replace the + with an & and remove the /24.
thank you for your answer
here is what it gives in abscissa
The distribution of the activity is good but just the abscissa display which is erroneous
I don't know what abscissa is.
You need to format this expression to match the format you want, e.g.
Timestamp(Dayname(YourField) + (Hour(YourField)/24),'DD-MM-YYYY hh)
the abscissa is the Horizontal coordinate