Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have this as a measure
count OrderID
This as a dimension
time(round( frac([OrderTimeMinutes]) + (7/1440), 1/24/4) , 'hh:mm')
this shows on the
but only showing positive time x axis in 15 minute intivals as
00:00, 00:15, 00:30 as I want
but some dates have been entered wrong in the system
thus I should have time buckets of
-00:15 , -00:30
How do I get those to appear please
Kind Regards
Hard to say without knowing what kind of entered wrong in the system
Maybe share some sample data and a sample qvf that demonstrates your issue.
Have you tried to create this in the script to see if it ever gets a negative value?
time(round( frac([OrderTimeMinutes]) + (7/1440), 1/24/4) , 'hh:mm')
if I put it as a measure
I do get the buckets
of 00:00, 00:15, 00:30 ect
but it does not work in the load...
I get 00:00 for all values
the format of OrderTimeMinutes looks like
-28
-1
0
2
3
20
58
please help
I guess time cannot be negative... try with Interval instead of time
Interval(round( frac([OrderTimeMinutes]) + (7/1440), 1/24/4) , 'hh:mm')
Hi
the same happens in the data load and a measure
all appear as 00:00
I would prefer time, but it looks like cannot produce a negative time
is there a way of making
OrderTimeMinutes
going into buckets of 15 (just have to label as minutes )... hence I may be able to get negative values
e.g
-30
-15
0
15
30
45
please help
Hi
I am happy to go with + time, and get uses to sort out the time field to stop negative values
however
I have the
OrderTimeMinutes
how do I change below to use the OrderTimeSeconds field please?
Interval(round( frac([OrderTimeMinutes]) + (7/1440), 1/24/4) , 'hh:mm')
so e.g
600 seconds would be in the 00:00
755 seconds would be in the 00:00
900 seconds would be in the 15:00 ect
Kind Regards
No idea what you mean....