Time format

[#1]

Hi All,

Time should be shown as 1-2AM, 2-3AM similarly till 22-23PM 23-24

Please help me with this.

Thanks,

Keerthi KS

[avinashelite]

please find the attachment for the solution:

[#3]

Thanks Avinash.

Please check with the attached qvw.

Data is not matching with the time interval.

[avinashelite]

no , its matching perfectly . Did you check my attachment? based on by solution can quote the example where its not matching

[avinashelite · Accepted solution]

check this attachment

[#6]

Please check my new attachment its not working

[avinashelite]

you have created the interval for the "TimeLeadCreatedOn" time field and your comparing the time for some other time field column i.e. "LeadCreatedOn" ....create the interval for the field you required , if you want the interval on " LeadCreatedOn" then create the interval for the same

[#8]

Even if i check with TimeLeadCreatedOn its not working.

If i check with 6-9 AM . 10 AM data is also coming

[avinashelite]

Are checking the interval for the "TimeLeadCreatedOn " created column only or your trying to check the link for the other field. Can you share the updated app where "TimeLeadCreatedOn "  is not matching

[avinashelite]

are you checking  for the same field which you have created the interval? can you share the updated app where the interval and the time columns are same and still not matching?

[#11]

PFA