Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a field called readtimestamp% . we have some books where people read we get timestamp. we need to find how many people read per hour on a day.
It has something like
02/02/2014 01:07:00
02/02/2014 00:00:14
How can i round them to
02/02/2014 01:00:00
02/02/2014 00:00:00
Thanks,
Venkata
Can you suggest me how can i achieve that since i don't have timestamp in the consumption QVD .
Any method that would be possible ?
Venka,
You can send me a sample of the two QVD's? I believe it would be easier to mount something.
The only thing you can sort on is the day itself. If you do not have the hour of day in your data model, you cannot do what you want. When I look at your data in the table viewer, it shows only the date, and does not contain the hour (and minutes, seconds) of each reader. Yuo need these to do what you want.
Thanks for your help.check the sample qvds iam sending them in excel .You can try to link them
Thanks,
Venkata
Hi, Venkata
You need to get your consumption with date and time. In your data, you have only date.
Eduardo
Venka,
Unfortunately, upon receiving the worksheets, I found that you need to create the timestamp in the table consumption ... field without this information we will not get the amount by date / time.
Thank you so much for everyone for all the efforts.
I understand that without timestamp in the table we cannot join to calender and get it by renaming it.
Thanks,
Venkata