Straight Chart with manual text and calulcation

[#1]

Hi,

I have the following expression to work out the last time a specific call was updated in a certain time.

=count(distinct if(time(update_time_JD_1,'hh,mm,ss') > time('00:00:00','hh,mm,ss') AND time(update_time_JD_1,'hh,mm,ss') < time('29:59:59','hh,mm,ss'), update_time_JD_1))

What I am looking to do is create a straight chart which has a manual text in and then the count.  It should look like the chart below:

Manual Text	Count
Last Updated within last 3 days	126
Last Updated more than 3 days ago	21
Last Updated more than 5 days ago	19
Last Updated more than 10 days ago	15
Last Updated more then 14 days ago	15
Last Updated more than 20+ days ago	98

I want to create this as a Straight Chart, so that if for example I click on Last Updated within last 3 days, it will show on another Straight Chart I have, all the call reference numbers.

Regards,

Jon Ditchfield

[whiteline]

Hi.

For this:

... if for example I click on Last Updated within last 3 days, it will show on another Straight Chart I have, all the call reference numbers.

The 'Manual Text' should be a real dimension connected with reference numbers or calculated dimension as aggregation of reference numbers dimension.