I am pretty new to SAP Lumira and Visualization tools. I am trying to create Visualization story board for Sales Bookings.
I have data with columns FW; Order amount. I want to do a Average calculation in SAP Lumira.
My objective is to compare previous fiscal weeks bookings with the current fiscal week ( e.g. if my current FW is 39 then i will do a average calculation on "order amount" from Fiscal 1 to 38 and Average calculation only for FW 25). I have attached raw data for your reference.
Can i use Max function to identify the current fiscal week in SAP Lumira.
How do I calculate Average bookings from FW1 to latest excluding the current week.
Any suggestions/ help on this request is greatly appreciated!
Looking forward for the positive response!