
Re: Bell curve
Henric Cronström Aug 3, 2015 6:19 AM (in response to Kumar Pramod)If you use a calculated dimension for a histogram, everything will become very complicated... Hence, you should define your dimension field already in the script. Then it is straightforward.
But I am not sure the data fits a normal distribution...
HIC

Histogram w Bell curve.qvf 224.0 K

Re: Bell curve
Kumar Pramod Aug 3, 2015 7:49 AM (in response to Henric Cronström )Thanks a lot henric cronstrom,
Now it's working fine.
Regards,
pramod

Re: Bell curve
Kumar Pramod Aug 6, 2015 2:21 AM (in response to Henric Cronström )Hi Henric,
1) your reply was most helpful. But one issue. I was using below script to load the data for 5 minutes time interval:
LOAD *,
If(total_time_taken<='00:05:00' ,Dual('00:0005:00',0),
If(total_time_taken>='00:05:00' and total_time_taken<='00:10:00' ,Dual('05:000:10:00',1),
If(total_time_taken>='00:10:00' and total_time_taken<='00:15:00' ,Dual('10:0015:00',2),
If(total_time_taken>='00:15:00' and total_time_taken<='00:20:00' ,Dual('15:0020:00',3),
If(total_time_taken>='00:20:00' and total_time_taken<='00:25:00' ,Dual('20:0025:00',4),
If(total_time_taken>='00:25:00' and total_time_taken<='00:30:00' ,Dual('25:0030:00',5),
If(total_time_taken>='00:30:00' and total_time_taken<='00:35:00' ,Dual('30:0035:00',6),
If(total_time_taken>='00:35:00' and total_time_taken<='00:40:00' ,Dual('35:0040:00',7),
If(total_time_taken>='00:40:00' and total_time_taken<='00:45:00' ,Dual('40:0045:00',8),
If(total_time_taken>='00:45:00' and total_time_taken<='00:50:00' ,Dual('45:0050:00',9),
If(total_time_taken>'00:50:00',Dual('>50:00',10)
))))))))))) as time_interval;
but now i need show the data for every 1 minute interval , so i need to hard code like below,
If(total_time_taken>='00:01:00' and total_time_taken<='00:02:00' ,Dual('01:0002:00',1),
If(total_time_taken>='00:02:00' and total_time_taken<='00:03:00' ,Dual('02:0003:00',2),
Is their any other way to display without hard coding ?
2) I need to display the data values of bar in combo chart. how can i done this.
3) I need to disable the selection so, i have using {1}, but how this can be used for below expression: which should be applied for whole expression:
only(Normdist(round(total_time_taken,avgTime),Avg({1<subject_id={'2'},subject_status={'passed','completed'}>}total total_time_taken),
Stdev({1<subject_id={'2'},subject_status={'passed','completed'}>}total total_time_taken),1))
*avgTime*Count({1<subject_id={'2'},subject_status={'passed','completed'}>}total_time_taken)
Thanks,
Pramod

Re: Bell curve
Jonathan Dienst Aug 6, 2015 2:37 AM (in response to Kumar Pramod)This discussion is closed  I suggest that you start a new discussion for this question.

