value of previous day using relative period without date dimension on cross table does not show

nic2 — Mon, 12 Jul 2021 03:59:47 GMT

I would like to have a daily dashboard analyzing the daily production and daily growth.

Calculated items using Parallel period and relative period have been created to show count of previous day but it does not reflect properly once the date dimension being taken out from the crosstab table.

When I choose 12/02/2020 in the report filter, the cross table should be showing something as below

	CONVENTIONAL	TAKAFUL	Total
	CASE_COUNT	Case Count (Day-1)	CASE_COUNT	Case Count (Day-1)	CASE_COUNT	Case Count (Day-1)
Channel1	16	30	3	5	19	35
Channel2	15	15	2	3	17	18
Total	31	45	5	8	36	53

Need S.O.S on this

Re: value of previous day using relative period without date dimension on cross table does not show

Sam_SAS — Mon, 12 Jul 2021 13:21:43 GMT

Hello,

When you use an aggregated measure with a periodic operator like RelativePeriod, the date column must be assigned to the report object. It is expected that removing the date column causes the aggregated measure to return missing.

Sam

topic value of previous day using relative period without date dimension on cross table does not show in SAS Visual Analytics

value of previous day using relative period without date dimension on cross table does not show

Re: value of previous day using relative period without date dimension on cross table does not show