RangeNumberAnalysis.java

package timeflow.data.analysis;

import timeflow.data.analysis.DBAnalysis.*;
import timeflow.data.db.*;
import timeflow.data.db.filter.*;
import java.text.*;

public class RangeNumberAnalysis implements FieldAnalysis {

	String[] description;
	static DecimalFormat intFormat=new DecimalFormat("###,###,###,###");
	static DecimalFormat df=new DecimalFormat("###,###,###,###.##");
	
	@Override
	public String getName() {
		return "Value Range";
	}

	@Override
	public String[] getResultDescription() {
		return description;
	}

	@Override
	public InterestLevel perform(ActList acts, Field field) {
		double low=0;
		double high=0;
		int numZero=0;
		double sum=0;
		int numDefined=0;

		boolean defined=false;
		for (Act a: acts)
		{
			if (a.get(field)==null)
				continue;

			double x=a.getValue(field);
			numDefined++;
			sum+=x;
			
			if (x==0)
				numZero++;
			if (defined)
			{
				low=Math.min(low,x);
				high=Math.max(high, x);
			} else
			{
				defined=true;
				low=x;
				high=low;
			}
		}
		if (defined)
			description= new String[]
	  		{
				"Average: "+df.format((sum/numDefined)),
	  			"Lowest: "+df.format(low),
	  			"Highest: "+df.format(high),
	  			"Number of zero values: "+df.format(numZero)
	  		};
		else
			description=new String[] {"No values defined."};
		
		return InterestLevel.INTERESTING;
	}
	
	static String format(double x)
	{
		
		if (Math.abs(x)>.1)
		{
			if (Math.round(x)-x<.01)
				return intFormat.format(x);
			return df.format(x);
		}
		return ""+x;
	}

	@Override
	public boolean canHandleType(Class type) {
		return type==Double.class;
	}
}