Somewhat limited success as year in Down ends badly (4,4,6)
I believe the answer is:
nine days wonder
'somewhat limited success' is the definition.
'nine days wonder' can be an answer for 'success' (I have seen 'Brief success' mean 'nine days wonder' so perhaps 'success' could also mean 'nine days wonder'). I'm not sure about the 'somewhat limited' bit.
'year in down ends badly' is the wordplay.
'badly' indicates anagramming the letters.
'year'+'in'+'down'+'ends'='yearindownends'
'yearindownends' anagrammed gives 'NINE DAYS' WONDER'.
'as' is the link.
Can you help me to learn more?
(Other definitions for nine days wonder that I've seen before include "Brief success" , "the amazing Lady Jane Grey?" , "brief sensation" , "provides a short-lived sensation" , "Something that arouses brief interest" .)