But what I can understood from your example, you are calculating an averge of the data. I think in my case I´m looking for something to create "buckets" that contains the count of the numer of sales. Each "bucket" will be the period of time of every half hour.
Sale Hours Quantity
9:00 am - 9:30 am I 20 sales
9:31 am - 10:00 am I 23 sales
10:01 am - 10:30 am I 5 sales
10:31 am - 11:00 am I 8 sales
.... and so on.
So the plot of the data will be:
Sales hourse as a dimension and quantity as a measure.
But... when I try to see the data arrange or the formula for the field you created (TimeOrderBucket) I got this "The execution of the loading data script was completed with errors, one or many data tables are not going to be shown "
So can you help me, pasting the formula of the new field you created "TimeOrderBuckets" so I can reproduce it here?
Thanks a lot !
ps. I know i´m a little bit a pain. but thanks again.