tag:blogger.com,1999:blog-1301643147176033927.post102835014442214357..comments2024-02-11T16:12:00.743+01:00Comments on kasper's source: YADC2SKasper Sørensenhttp://www.blogger.com/profile/03281134453771284315noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-1301643147176033927.post-42148163489093156852011-01-06T10:14:08.474+01:002011-01-06T10:14:08.474+01:00Very nice. :)
But I'm still thinking a normal...Very nice. :) <br />But I'm still thinking a normaldistribution profile would be a feature request. This profile would take a single column, draw a nice little distribution, calculate modus and median, and perhaps even a standard deviationAsbjørn Leethhttps://www.blogger.com/profile/00281878140460732403noreply@blogger.comtag:blogger.com,1999:blog-1301643147176033927.post-20084435556522146492011-01-04T10:36:57.771+01:002011-01-04T10:36:57.771+01:00There's now a Date diff / Period length transf...There's now a Date diff / Period length transformer available. I think that will fit your purpose?Kasper Sørensenhttps://www.blogger.com/profile/05310806961885711209noreply@blogger.comtag:blogger.com,1999:blog-1301643147176033927.post-82867518774887078882011-01-04T08:57:23.055+01:002011-01-04T08:57:23.055+01:00Hmm was just looking further into this. I see that...Hmm was just looking further into this. I see that actually I remembered wrong regarding that last workaround idea with the "Date to age" transformer. In order to get the difference between dates it's actually a bit more complicated (but you can do it with a JavaScript transformer) so I think I will create a separate transformer for just this.Kasper Sørensenhttps://www.blogger.com/profile/05310806961885711209noreply@blogger.comtag:blogger.com,1999:blog-1301643147176033927.post-79131240004998538682011-01-04T08:52:27.365+01:002011-01-04T08:52:27.365+01:00Hmm I think we're maybe talking about differen...Hmm I think we're maybe talking about different things. The gaps that the Date Gap analyzer will find are not the periods between from and to dates. Rather it lays out a complete timeline based on all from and to dates in a dataset and identifies the gaps that are not covered by some activity. For example in a PM registration system, I might register the following periods:<br /><br />from | to<br />03-01-2011 | 05-01-2011<br />07-01-2011 | 10-01-2011<br /><br />That would create a timeline spanning from 03-01-2011 to 10-01-2011. And there would be a single gap in it, ie. from 05-01-2011 to 07-01-2011.<br /><br />In this case I don't think a normal distribution would add much value, would it? I mean, any gap could likely be an inconsistency or DQ issue so getting any distribution of the gaps would not make sense (at least in the scope that I'm thinking, but please tell me otherwise if I'm wrong).<br /><br />On the other hand if you have a different understanding of the word "gap" you might consider each period to be a gap (which I think is probably what is causing confusion in this discussion). So maybe the wording "date gap" is ambiguous or not explained very well. At least i DO see a relevance to create a normal distribution of the length between from and to dates! Something to start with here would be to apply the "Date to age transformer" and then do a Number analysis. The number analysis does not yet show a normal distribution, but it contains both the mean and the std. deviation, so you could probably produce one yourself from those two measures.Kasper Sørensenhttps://www.blogger.com/profile/05310806961885711209noreply@blogger.comtag:blogger.com,1999:blog-1301643147176033927.post-45106503215229632722011-01-03T16:41:18.487+01:002011-01-03T16:41:18.487+01:00I have actual just made such an analysis today usi...I have actual just made such an analysis today using SQL and Excel. I didn't care for the exact gaps but i wanted to know the normal distribution of any gaps.<br />Of cource i could make a view and with that attribute and the use value distribution, which by the way only gives me a pie, not a normal distribution ;), but it would nice if I could do it all in the tool.Asbjørn Leethhttps://www.blogger.com/profile/00281878140460732403noreply@blogger.comtag:blogger.com,1999:blog-1301643147176033927.post-22807682681400385582011-01-03T13:59:49.052+01:002011-01-03T13:59:49.052+01:00Hmm for the value distribution I guess that would ...Hmm for the value distribution I guess that would make a lot of sense actually... But for the Date Gap Analysis a normal distribution would not be fit, since the point of interest is a bit different - it's mostly used to find gaps in a continuity that is expected.Kasper Sørensenhttps://www.blogger.com/profile/05310806961885711209noreply@blogger.comtag:blogger.com,1999:blog-1301643147176033927.post-35774922560078747892011-01-03T13:37:40.016+01:002011-01-03T13:37:40.016+01:00Hi Kasper
Is it posible to get a simple normal dis...Hi Kasper<br />Is it posible to get a simple normal distribition graph instead? For me that would be much easier to read<br />/AsbjørnAsbjørn Leethhttps://www.blogger.com/profile/00281878140460732403noreply@blogger.com