I am interested in this as well as my company is in a similar
situation--this capability would determine whether or not we used RT
for tracking information that requires these types of calculations.
Can anyone offer a hint as to whether or not this is possible to do?
Even if it's a custom
Daniel,
It is certainly possible to write a scrip that updates custom field
values when other custom fields,or core RT fields change.
It is also possible to have columns that are calculated on the fly as
search results are returned, though it takes a bit more work because
RT does not have
Daniel,
We DO this! We have over a hundred Queues that are used for Application
support in many, many scientific applications as well as the regular AP, AR,
GL, etc. Each Queue has a manager and they ALL have a variety of Searches
that provide them with such things as Time Estimated, Time Worked
Kenneth,
Thanks for the suggestion and I'll look to see if this might be workable on our
end, but I was rather hoping that there might be someway to do this all within
RT, automatically, to be able to say display on a dashboard or saved search the
total cost of all the orders or the average
I do things like this similar to how Kenneth described but I use a ODBC
connection directly to the database and use Excel Pivot tables to build
reports. Very flexible and gives you data mining tools right out of the box.
While it isn't built into RT it is in a place where data analysis is
Daniel Farst wrote:
I have a couple of things I'd like to do with RT and haven't been able to find
any clear answers how to do it, or if it's even possible. Can anyone point me
in the right direction? We'd like to do some simple calculations on values
stored in a custom fields and on values
I have a couple of things I'd like to do with RT and haven't been able to find
any clear answers how to do it, or if it's even possible. Can anyone point me
in the right direction? We'd like to do some simple calculations on values
stored in a custom fields and on values from those custom
