Consider the difference between:
IF [WD (Max)] < = ...etc
IF SUM( [WD (Max)] ) < = ...etc
The X-axis is SUM([WD (Max)]), but with the current calc SKUs are being colored based on individual records of [WD (Max)]. A SKU with three records of 20% (each) for WD (Max) will correctly be colored orange, and will correctly chart the sum at 60%. Also, if this SKU has a 4th record with a WD (Max) of 100%, then a separate, second point will be plotted for this SKU ( this one showing as green). Correct by using SUM() in the calc for [SKU Quadrant]. The same logic applies to Velocity.
Thank you for your reply but the solution you have provided is not working in my current scenario.
see the attached possible solution - I had to use superstore data but it should serve as an example
it will return this
step 1 is determining the fixed avg sales and quantity (Note - if your real data is dependant on several dimension you will need to include them in the LOD)
then step 2 is the quadrant designator formula
then just create the viz
set the ref lines as shown
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
quadrant book.twbx 1.2 MB
Thank you for the reply,
Problem is solved by your suggestion
Thank you for the help.
As you suggested earlier, The I have got the 4 Quadrants for a particular period but in this scenario, I have multiple periods but required same Identifiers,
The formula which I'm using to Identify Quadrants: (It will work properly if we have a single period)
Is there any option to fix that formula on period="YTD_CY"
Screenshot for reference :
In an ideal scenario the Blank SKUs in YTD_CY column, They shouldn't be there.
Please let me your thoughts regarding the same.
got your post
this is getting to be beyond the purpose of the Forum - I see you are in Mexico and work for a major corporation - suggest you find a local Tableau resource to work with directly
Thank you for the suggestion !