Different Time Series Types dispalying the same results

Legacy Contributor

Hi,

I have the same measurment (oeeh.totlineamt) - configured exactly the same with the exception of Time series type.

I tried to compare the same measure for Time Series Types: Week-To-Date, Current and Year Ago.

To my suprise I am getting exactly th same values. I would expect that the sales values will be different for all these three time series.

Why this is the case? What should I add to the report to get intended values? 

Extract from the report and querry below.

Any suggestions greatly appreciated. 

SELECT USING OUTER JOIN [ARSC.arsc_name] 'COL0' , [ARSC.arsc_slsrepout] 'COL1' , [ARSC.custno] 'COL2' , [WTD oeeh_invoicedt: Sum: oeeh_totlineamt] 'COL3' , [YAGO oeeh_invoicedt: Sum: oeeh_totlineamt] 'COL4' , [oeeh_invoicedt: Sum: oeeh_specdiscamt] 'COL5' , [oeeh_invoicedt: Sum: oeeh_totlineamt] 'COL6' , [oeeh_invoicedt: Sum: oeeh_wodiscamt] 'COL7' FROM [ALL] WHERE ( ( [ARSC.arsc_statustype]='true' ) AND ( [ARSC.custno]=23761 OR [ARSC.custno]=23638 OR [ARSC.custno]=19695 OR [ARSC.custno]=10721 ) )

AI

Legacy Contributor

This will only work when you actually have something from the Time dimension in your report, I believe.  I see you have Year/Month as a filter but I don't see it in the WHERE clause, so I'm assuming you have that filter turned off.  If you add anything, like a filter for [Time.Year]>2000 then I believe this will work.