Hi,
I am trying to create a Straight Chart that the Dimensions are free Text and the expresssion is calculated as such
=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))
E.G.
| Free Text (Dimension) | Expression |
|---|
| Last Updated 3 Days ago | 121 |
Last Updated more than 3 Days Ago | 30 |
| Last Updated more than 5 Days Ago | 32 |
Last Updated more than 10 Days Ago | 40 |
| Last Updated more than 14 Days Ago | 5 |
| Last Updated more than 20+ Days ago | 16 |
The above table is how I want the chart to look, with the Free Text being what I want to enter and the expression being above, obvisouly with changes made to the expression.
Regards,
Jon Ditchfield
