I have been participating in this for a few weeks now and am totally enjoying myself. It helps me, and anyone who participates, think in directions one wouldn’t have otherwise. Please find the challenge here.
I will not go into details of how I solved this weeks workout; instead I will only touch the main areas and things that makes these workouts special. I couldn’t resist myself and had to go through the spoilers.
The most important spoiler was **
- ROUND({FIXED [Order ID], [Sub-Category] : SUM([Profit])}/[Round Parameter]) * [Round Parameter]
I think @LukeStanke was feeling very generous this time. Lets get to business now.
Step 1:
Create the Parameter of type integer and type list with all the values in it $25, $50, $100, $250, $500 and $1000. then create the calculated field using the hint as mentioned above as “Profit per order Rounded”. Make sure it’s a “Dimension” and “Continuous”
Step 2:
Filter plays a very important role. Use Ctrl and drag the “Profit per order Rounded” pill into Filter, chose range -1500 to 1500. Also filter it to category “Technology” You may or may not convert them to context filters.
Step 3:
Follow the X axis and Y axis instructions as mentioned in the workout. Create a field called “Bar Size” using the parameter you have created. Make it of the dimension type so that when you put it in the “size” mark it doesn’t do any aggregation. It is important to keep the bar width equal.
Step 4:
Put sub-category pill into colors. In colors use less than 60% opacity. You are almost there now.
Step 5:
Sorting is important, use manual sorting for the field subcategory, so whichever worksheet is highlighting, or whatever subcategory, keep that at the top.
Here is the final and the most fun part: the bars need to overlap, but how?
Analysis->Stack Marks->Off
Follow the formatting as required and we are done. Thanks, Luke, for another amazing workout.
DataVisalytics 