Dataset-> computed columns

Hi All,
I want one column having values = diff between two datetime values of same column, like :
Status Time Diffhour
In Recieving 12/12/09 12:00:00 24
Recieved 01/01/10 12:00:00

What query should be added in computed column?

Find more posts tagged with

Comments

mwilliams

Hi Iira,

I'm not sure I'm understanding what you're trying to do based on the data above. Your two dates are 20 days apart, but your diffhour field is 24 on the first line. Let me know.

jayaris

Hi All,
How to compute values in a particular column.

I have to plot a line graph for the below scenario

sprint(Sprint1,sprint2,....sprintn) on X axis.

Valid bug counts(Status as New+Assigned+Reopen) on Y axis.

Here X axis able to form but when we want to compute the value for Y axis,we are not able to add the count bug status means under one column different statuses are available,how to sum these and plot into Y axis.

Thanks in advance.

Jay

mwilliams

Hi Jay,

How is your data set up in your dataSet? Does creating a computed column adding up the other 3 columns not work?