time dimension problem,

[BlazkoG]

hi, I'm doing a user activity chart, showing their pick times on 24h axis. I have a dimension table with a whole 24 hou, every minut, every second, as a dictionary.
Problem is I'm missing data, as you can see not every time value has its equivalent value in the dictionary table. Both are time(value,'hh:mm:ss'). Any hint? Thanks in advance!

[fosuzuki]

Can you post the app?

[BlazkoG]

I can't ;/
Although I got it working by joinin both tables (data and dictionary) with 

text(time(value,'hh:mm:ss'))

but I'd like to now why it didn't work before, where for ex.  time format of both 07:35:02 is somehow not equal to 07:35:02

[fosuzuki · Accepted solution]

Not sure. Maybe because one of them has milisseconds and the other doesn't? Although you set the format to show as hh:mm:ss, the number behind it can contain milisseconds which would explain the not matching.