And what have you tried?

Drew

There is no way that we can help you troubleshoot this with actual data to work with.  I will say that it looks like you're over-complicating the two CTEs.  I...

Also, there is no purpose to writing UPPER(<some constant string> ), especially if the string doesn't contain alphabetic characters.  

UPPER('%New%') is the same as '%NEW%'
UPPER('%Passwords%') is the same...

There are several things I don't understand about how your trend line is working.

1)  I don't understand why you've hard-coded values for the various trend lines and why...

I posted the outline of a solution in your other thread, and it does work.  Here is the full solution given your test data.

WITH CTE...

The guy complains that my solution doesn't use dynamic dates, even though I've clearly used the date variables that he set up in the sample.  Can't see the forest...