BookmarkSubscribeRSS Feed
nic2
Calcite | Level 5

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

nic2_0-1626062266906.png

 

 

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

1 REPLY 1
Sam_SAS
SAS Employee
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

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 975 views
  • 2 likes
  • 2 in conversation