Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Can you post the app?
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
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.