Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.