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.
Kindly assist me with the below lines. What i need to do first after creating the UX sheet. How to add Product SKU and Time context selectors in the Page. Include the following: Product SKU and Time context selectors. SYS00 Time Settings by Month module, Planning Period Filter for UX saved view (or create a custom viewβ¦
Hi, is it possible to use a Network Card in order to show an organizational structure which cannot be managed through Hierarchy Lists, cause there are branches that don't have the same hierarchy levels associated? Example: In a L1 COMPANY > L2 AREA > L3 SERVICE > L4 OFFICE There is a case like this: COMPANY A AREA Aβ¦
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?