how can I create a aging OTBI report of negotiation by status.

Summary:

how can I create a aging OTBI report of negotiation by status.  the columns i expected is

status, count, days count (rage created date ie,0-5 days, 5-10 days).

Content (please ensure you mask any confidential information):

I need a to get count of negotiation group by days count, status

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

This is how i created the days count.

CASE  WHEN TIMESTAMPDIFF(SQL_TSI_DAY,"- Negotiation Collaboration Team Detail"."Collaboration Creation Date", CURRENT_DATE) <= 100 THEN 0 WHEN TIMESTAMPDIFF(SQL_TSI_DAY,"- Negotiation Collaboration Team Detail"."Collaboration Creation Date", CURRENT_DATE) BETWEEN 100 AND 200 THEN 1 WHEN TIMESTAMPDIFF(SQL_TSI_DAY,"- Negotiation Collaboration Team Detail"."Collaboration Creation Date", CURRENT_DATE) BETWEEN 200 AND 300 THEN 2 WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "- Negotiation Collaboration Team Detail"."Collaboration Creation Date", CURRENT_DATE) BETWEEN 300 AND 400 THEN 3 WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "- Negotiation Collaboration Team Detail"."Collaboration Creation Date", CURRENT_DATE) BETWEEN 400 AND 500 THEN 4 WHEN TIMESTAMPDIFF(SQL_TSI_DAY,"- Negotiation Collaboration Team Detail"."Collaboration Creation Date", CURRENT_DATE) BETWEEN 500 AND 600 THEN 5 WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "- Negotiation Collaboration Team Detail"."Collaboration Creation Date", CURRENT_DATE) BETWEEN 600 AND 700 THEN 6 WHEN