Calculated field with hourly ranges
I have an interesting requirement that I am not sure how I can cover and it it's doable altogether in Yellowfin. Please see below:
"Would it be possible to add custom fields to X Custom view showing what hour a given date field falls into ie todays date 19/09/2018 13:30 would fall into 13:00 - 13:59.
This is to allow for trending by hourly time bands across submission time, modified time, resolution time, etc....."
As a workaround i tried to edit an existing field's format and only leave the hour (ie 1 PM), but even if it looks good it's not something that can be aggregated and the latter is the goal.
Please help :)
All the best, Radoslav