Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to calculate the volume of occurrences that take place by hour in a 24 hour clock, disregarding the day month and year associated with the time stamp. I am trying to establish a trend for these occurrences. Displaying this in a bar chart would be preferable. I read through a couple of discussion questions but, have not found precisely what I am looking for.
Thank you for the help in advance.
Hi Joseph,
Not sure I fully understand your question without an example of what you are trying to do. I have attached an example of a simple chart with hour /volume.
It would be better to calculate some values up-front in your load script, but it can also be done in the UI using objects and simple expressions. I'm assuming that your occurrences are available in an internal table and each have an ID (called OccurenceID) and a timestamp (called OccurrenceTimestamp).
Create a bar chart with (calculated) dimension =hour(OccurrenceTimestamp) and expression =count(OccurrenceID).
Best,
Peter
Hi,
In script create an additional column for hour like below
LOAD
*,
Hour(OccurenceDateTime) AS Hour
FROM DataSource;
Now in chart try like below
Dimension: Hour
Expression: Sum(Volume) or Count(SomeID)
Hope this helps you.
Regards,
jagan.