Hi, I can create a filter here in terms of months but I am not getting data for the line chart, where am I going wrong? Please help me on this.
@AyushT22 Hey, As per your screenshot, change the page selector from ALL products to a child item and it'll visible.
Hi @jagadishdash I did try with that but then also I am not able to get any data
Make summary as sum . u will get data
@AyushT22 - Make sure to keep the summary as sum to see the data at the Top/Parent level.
@AyushT22 In blueprint view, toggle the summary from None to SUM.
@AyushT22 The formula is at week level,
And you are using Months. Can you take a look at that and if not working share the Blueprint view. Thanks.
Thank you everyone for your suggestions it worked.
I thought a formula would be necessary to display this data properly.
Hi,
Anyone can assist me on how to Add a filter to this module to display Months only?
Thanks in advance
Create a system module with month dimension.
Create a Boolean line item with a formula TRUE.
Turn off summaries.
Use this line item as a filter for your module. I hope this helps.
Seyma 🌷🙂
@seymatas1 Thank you for inputs, however, I'm not able to proceed to display Months only.
Any ide what will be the selection to display months only? Weeks are still display in my modules.
I'm looking at below output in a per month.
2. Create a system module with month dimension.
3. Apply the filter to the time dimension of your weekly module:
4. Filter is working.
You can also consider creating a monthly module instead of applying a filter. A new module will increase your cell count but a filter will affect performance. There is a tradeoff and I usually prefer to increase size instead of affecting performance.
Thanks @seymatas1
I tried to filter the data using the Planning Period Filter Weeks Only line item in the SYS01 Time Settings by Week module. However, I'm not able to Filter it. Please see below screenshot.
Please assist.
Thank you.
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…
