[ABUSE] By: CommunityMember123764 / Board: forumsmisc (21836)

Options
CommunityMember123764
CommunityMember123764 Member, ALL USERS, GroupMember Posts: 5 Occasional Contributor
in Anaplan Community
Hi, I posted a question on the community and now it's being marked as spam. I think it may be because I edited it several times to get the detail in there. Can you please help clear this up? The subject line is: Taking an average of specific Quarters, like all Q1 or all Q2 over many years.
Thank you,
Mehmetcan


Link to post:
(Taking an average of specific Quarters, like all Q1 or all Q2 over many years)

by CommunityMember123764



https://community.anaplan.com/t5/Anaplan-Platform/Taking-an-average-of-specific-Quarters-like-all-Q1-or-all-Q2/m-p/95696#M21836



Hi, I'm attempting to generate some historical trends to drive future projections. In doing so, I have % Weekly over a 13-week period (one quarter), and I have this over many quarters. I'm trying to capture an average of all Q1 % weekly values (such as FY18 Q1, FY19 Q1, FY20 Q1, etc.), to predict a likely quarter projection by week for Q1 weeks. This Historical module has the raw data (first snapshot), and each quarter has it's designated quarter value (second snapshot):   On another module, I'm attempting to capture all Q1 values using TIMESUM, but I don't know how to specify "Q1" explicitly: Both tables have "Quarter" as a list and a dimension, but because the Historical module has Time, and Weekly Profiles module does not, I'm unable to do a simple SUM/LOOKUP to get my data. I'm having to try the TIMESUM to overcome this, but now I'm unclear as to how to only pull Q1 values. (I'm only reflecting FY20, but I have FY19 and FY18 I would be adding, and using those 3 years to average out Q1). In both modules, the Week columns are a List and a dimension, not a Time Range. Any direction would be much appreciated. Thank you!      



This message has 0 replies


Categories