Duplicate Date time values in X-axis

[shaan007]

I am having another strange problem here.

This is a List box of Transaction Date and time.

It’s not supposed to show duplicate values.

That’s mean those two dates are not the same.

Do u have any Idea?

please see my attachment image.I made that Date and time field from

TransactionALL:

LOAD
PK_TRANSACTION,
[Trans Start DateTime],
[Trans End DateTime]
FROM
TransactionALL.qvd
(qvd);

TransactionFlow:

load DISTINCT
PK_TRANSACTION
,TimeStamp(Num([Trans Start DateTime])+(((IterNo()-1)/60/24)),'D/MM/YYYY h:mm:ss TT') as [TransCont DateTime]
,1 as [TransCont Count]
Resident Transaction
While (Num([Trans Start DateTime])+(((IterNo()-1)/60/24))) < (Num([Trans End DateTime]))
;

[shaan007]

Thank you so much Michael, helped me

round([Trans Start DateTime]+(((IterNo()-1)/60/24)),1/1440) helped me

--------------------------------------------------------------------------------------------------------------------

TempTrans_Continuing:
NoConcatenate load
PK_TRANSACTION
,timestamp(

     round([Trans Start DateTime]+(((IterNo()-1)/60/24)),1/1440)

     ,'D/MM/YYYY h:mm:ss TT') as [TransCont DateTime]
,1 as [TransCont Count]
Resident Transaction
While

     (Num([Trans Start DateTime])+(((IterNo()-1)/60/24)))

             <= (Num([Trans End DateTime]))
;