How to handle null values in rational insight reports
Hi,
We have generated report by using Rational Insight.
In report, "Due Date" column is showing us the irrelevant data (E.g. Jan 1, 1970 1:00:00 AM) for workitem records in which "Due date" field is not filled in (Due Date is not mentioned).
We want to put null or blank values for those workitem in which Due Date is not specified.
Please assist us regarding the same.
Thanks and regards,
Suyash
We have generated report by using Rational Insight.
In report, "Due Date" column is showing us the irrelevant data (E.g. Jan 1, 1970 1:00:00 AM) for workitem records in which "Due date" field is not filled in (Due Date is not mentioned).
We want to put null or blank values for those workitem in which Due Date is not specified.
Please assist us regarding the same.
Thanks and regards,
Suyash
One answer
Hello Suyash,
you can create a new data item in your query and use an expression like this:
This will replace the value of Due Date with null for all the items having the year you want to filter.
Note: I tested the Due Date field in Insight 1.1.1.3/CLM 4.0.5 and I have null by default for the work items that don't have a due date. Are you using and older version of the the data model?
Best Regards,
Francesco Chiossi
you can create a new data item in your query and use an expression like this:
if((extract(year, [Due Date]))='1970') then (null) else ([Due Date])
This will replace the value of Due Date with null for all the items having the year you want to filter.
Note: I tested the Due Date field in Insight 1.1.1.3/CLM 4.0.5 and I have null by default for the work items that don't have a due date. Are you using and older version of the the data model?
Best Regards,
Francesco Chiossi
Comments
Hi Francisco,
Thanks a lot for your help.
This solves our problem.
We are currently using CLM version 4.0.1/ Insight 1.1.1.
Thanks and regards,
Suyash
Hello Suyash,
I'm glad to hear it helped.
The reason for the different behavior from my system is probably the earlier versions.
Best Regards,
Francesco Chiossi