Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Blessy,
Try the following expression:
avg(aggr(EndDate-StartDate,RegID))
Regards
Hi,
Can anyone help me on this?
Well, what is your definition of average? What is "wrong" and what is 'right"? For example, you have the data like this:
RegID End Start Difference
1 20 10 10
1 50 30 20
Now, the average will be 15 - is it wrong? What is the expectaion here? I think as soon you figure out what you want to see, you'll figure out how to do it.
Hi
Sample Data
RegID Startdate Enddate difference
1 2-12-2009 5-12-2009 3
1 2-12-2009 5-12-2009 3
1 2-12-2009 5-12-2009 3
2 1-12-2009 7-12-2009 6
Avg->15/4=3.75
But actual avg->9/4.5=4.5
This is the problem I am facing in Gauge Chart.
I dont want to remove duplicates in loading .i just want to touch layout.Any ways?
Hi Blessy,
Try the following expression:
avg(aggr(EndDate-StartDate,RegID))
Regards
Thanks Karl..
It worked ...