How to handle null values in rational insight reports

Suyash adsul (9●12●18) | asked Aug 08 '14, 3:54 a.m.

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

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Francesco Chiossi (5.7k●1●11●19) | answered Aug 08 '14, 8:55 a.m.

Hello Suyash,

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

Suyash adsul commented Aug 11 '14, 3:50 a.m. | edited Aug 12 '14, 5:15 a.m.

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

Francesco Chiossi commented Aug 11 '14, 4:25 a.m.

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

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

It's all about the answers!

Related questions

How to handle null values in rational insight reports

One answer

Your answer