ValueLoop to Timestamp

[morenoju]

Hi all,

I need a list of timestamps between two timestamps with a 15 minute interval.

I'm using this dimension:

=ValueLoop(start_timestamp,close_timestamp,15/(24*60))

It's working, but the result I get are the decimal representation of the timestamps (e.g. 43651.40625). I tried to do:

=Timestamp(ValueLoop(start_timestamp,close_timestamp,15/(24*60)))

But that gives me an "Internal Engine Error". Any idea on how to convert the result to timestamps? Thanks!

Juan

[Yoshidaqlik]

Hi

In this case to format in the dimension I think I would have to create an additional table in the script.

I believe ValueLoop can only be formatted as a measure

you can set a counter and format the measurement as an optional solution

dimension

=ValueLoop(start_timestamp,(close_timestamp-start_timestamp)/(15/(24*60))+1)

measure

=Timestamp(ValueLoop(start_timestamp,(close_timestamp-start_timestamp)/(15/(24*60))+1) * (15/(24*60)) + start_timestamp)

Regards