​Hello,

I have a viz on my dashboard which is using a dataset (not created from data modules).  This viz using an 'Dollar Amount Tier'  and the number of accounts that fall into each tier.

Example:
when Amt < 25000 then '< $25,000'
when Amt between 25000 and 49999.99 then '  $25,000 - $50,000'
when Amt 50000 and 99999.99 then '   $50,000 - $100,000'
ETC...

I'm using the loan tiers are my 'color'.  The Date as my 'x-axis' and the 'Number of Accounts as my 'y-axis'.

All works fine except when I want to sort the date.. it then resorts the appearance of the 'legend/Dollar Amount Tier'. 
I need the 'Dollar Amount Tier' to stay in a specific order and be able to sort the date.

Any ideas how to apply secondary sort in a dashboard chart that will work?

Thanks,
Jen

------------------------------
Jenifer Broughton
------------------------------
​
#CognosAnalyticswithWatson