I need to chart multiple years with one line for each year and the axis showing the week numbers. I've been looking off and on, through the forum, for about four months and no luck finding a solution. Please help. Thanks.
Thanks so much for the response and I'll try to be more clear...you are headed the right way. I want to chart gallons with two lines, one for current year, one for prior year. The x axis = week #, y axis = gallons, user can chose site and activity. four files attached...LIST:PNG = I've created a list for week numbers like you suggested. Module.PNG & module2.png: a module with year as standard time...two views of module. DATA.PNG = file where gallons are imported. I'm stuck and cannot get my gallons data mapped into the module....this is probably basic stuff, but that is some of the stuff I struggle with...and I've been thru both modeling classes.Again thanks for the help...and is this a solution I could have found on the community....did I not look correctly? Also is there additional reading I can do to understand mapping?
If I understood correctly you have the data flowing by weeks for all the years.
1) Current year should be loaded into Gallons and previous year data should be loaded into Gallons PY
2) In your file you have to load the file twice one for Gallon and second for PY
3) Make sure your names week columns match with the week dimension list items
4) IF you could share your error file and data file it might be much easier to help you
If the scenario is that you are getting previous year value from a file for this year and from coming year the previous year value comes from current year value present in Anaplan then you have to redesign your modules.
you are correct...my issue is how to get the gallons to show up in module from the import module, please see pictures I posted earlier....how can i reference the week number when it's not in the import? What is the formula? sorry but this has been very frustrating for over a year now....I keep trying and setting it aside and trying and setting it aside....anytime I've tried to map data from an import like this activity one...where row number is the dimension...i get error regarding no hierarchy. but then sometimes it works and i find a way around it by adding yet another column to the data import. It's sounding like that's the only way to map from modules with row numbers is by ever increasing the imported columns.I'm starting to doubt that this the right way to build...so that's why I'm attempting to get a better answer, again. THANKS and I apoligize for my frustrated tone. I do try to find my own answers on the forum but hours/days of looking and here I am. I would have posted before but until the recent redo of the community I had not been able to find a place to post a question...and I have asked...just never got an answer.