MM Week 15 |Small Multiples

 So, I've been a bit out of pocket for weeks due to some personal stuff going on that I am sure I'll blog about in the near future.  In the meantime, here is my thoughts on MM_Week15.  I created a small multiple chart this week with help from Daniel Foster and a TTipTuesday from Andy Kriebel.  Here are my notes and the link; 

This is what is in the Columns & Rows.  The tutorial link explains the Column\row formulas. The Sum(-20) is a dual axis for alignment purposes. 

This is the formulas for the Column\Row s;

nCols = 10

Column Divider =

//(INDEX()-1)%(ROUND(SQRT(SIZE()))) // uses display size

(INDEX()-1)%[nCols]

Row Divider =

//INT((INDEX()-1)/(ROUND(SQRT(SIZE())))) // uses display size

INT((INDEX()-1)/[nCols])

Created a parameter to break out the descriptive 

 

NOTE: made mistake on the 2 field above and so had nulls for my rank and service level rank

Formula for Rank =

CASE [Choose Ranking]

WHEN 'Cashrank' THEN [Cashrank]

WHEN 'Budgetrank' THEN [Budgetrank]

WHEN 'Lrrank' THEN [Lrrank]

WHEN 'Servicelvlrank' THEN [Servicelvlrank]

WHEN 'Trustrank' THEN [Trustrank]

WHEN 'Overallrank' THEN [Overallrank]

END

Formula for Rank Description =

CASE [Choose Ranking]

WHEN 'Cashrank' THEN 'Does a state have enough cash on hand to cover its short-term bills?'

WHEN 'Budgetrank' THEN 'Can a state cover its fiscal year spending with revenues, or does it have a budget short-fall?'

WHEN 'Lrrank' THEN 'Can a state meet its long-term spending commitments? Will there be enough money to cushion it from economic shocks or other long-term fiscal risks?'

WHEN 'Servicelvlrank' THEN 'How large a percentage of personal income are taxes, revenue, and spending? How much “fiscal slack” does a state have to increase spending if citizens demand more services?'

WHEN 'Trustrank' THEN 'How much debt does a state have? How large are its unfunded pension and healthcare liabilities?'

WHEN 'Overallrank' THEN 'Overall fiscal ranking, generated from the equally weighted sum of the five dimensions of solvency (cash, budget, long-run, service-level, and trust fund solvency).'

END

Formula for Label=

IF INDEX()=ROUND(SIZE()/2)

THEN ATTR([State])

END

Struggled with getting the name of states to the top; once  reversed the axis it worked!

The Title Page is a polygon; pulls in the title into the title of the page which is just the rank description

here is public link; feel free to send questions.