Help with dimension calculated

[#1]

Good day.

I need showing in a table the total days leading open support tickets asset.

For this I have in my database a field called "date of creation" (format: 01/30/2015 11:51:42 am) and a field called "State", I need to subtract the [creation date - current date ] of tickets with [state] = 'active' to show how long they open current ticket.

I can not create the Dimension calculated to perform this calculation.

Greetings.

[#2]

Thanks Max Dreamer for your support, yet still displays all data without applying the filter, I see that now only does the calculation for all tickets with status = 'Active' and resolved that only show data actives using triggers and markers.

The expression remained well:

if ([Status] = 'Active', Interval (today () - [Date Creation], 'D'))

Thanks for the support, the solution helped me and have adapted to cover all my needs.

Greetings.