group by 15 minute intivals, but show negative times in 15 minutes

[joeybird]

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

[Anonymous]

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.

[sunny_talwar]

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')

[joeybird]

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

[sunny_talwar]

I guess time cannot be negative... try with Interval instead of time

Interval(round( frac([OrderTimeMinutes]) + (7/1440), 1/24/4) , 'hh:mm')

[joeybird]

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

[joeybird]

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

[sunny_talwar]

No idea what you mean....