com.softwarefx.chartfx.server

Class CompactFormulas

java.lang.Object

com.softwarefx.chartfx.server.CompactFormulas

public final class CompactFormulas
extends java.lang.Object

Compacts the data in order to display more summarized information.

When compacting data, the data will require summarization of some form. Chart FX allows you to specify how to summarize data in the form of a DataCompacting formula. For convenience, Chart FX provides predefined formulas for popular compacting schemes such as First, Last, Min, Max, and Average.

Here is a sample how to compact 251 bars (corresponding to 1 year of data) into 13 by grouping them into 1 bar for every month.

• image
• Java

• 

• PopulateOilPriceandEuroRate(chart1, "Price");
  chart1.getTitles().add(new TitleDockable("Price of Oil per day (USD)"));
  chart1.setGallery(Gallery.BAR);
  chart1.getLegendBox().setVisible(false);
  chart1.getAxisX().setLabelAngle((short)90);
  chart1.getAxisY().getLabelsFormat().setFormat(AxisFormat.CURRENCY);
  

  public static void PopulateOilPriceandEuroRate(Chart chart1, String fieldNames) {
          OilPriceandEuroRate[] data = new OilPriceandEuroRate[] {
              new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 19).getTime(), 110.12, 1.3636),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 20).getTime(), 113.45, 1.3697),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 21).getTime(), 110.21, 1.3724),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 22).getTime(), 102.94, 1.3446),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 23).getTime(), 96.42, 1.3518),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 26).getTime(), 97.84, 1.3516),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 27).getTime(), 99.09, 1.3606),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 28).getTime(), 95.21, 1.3628),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 29).getTime(), 95.17, 1.3639),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 30).getTime(), 96.72, 1.3449),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 3).getTime(), 98.85, 1.3281),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 4).getTime(), 92.61, 1.3294),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 5).getTime(), 97.1, 1.3328),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 6).getTime(), 98.95, 1.3408),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 7).getTime(), 97.71, 1.3512),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 10).getTime(), 101.37, 1.3584),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 11).getTime(), 102, 1.3657),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 12).getTime(), 103.21, 1.3805),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 13).getTime(), 100.86, 1.373),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 14).getTime(), 102.85, 1.3861),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 17).getTime(), 100.66, 1.377),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 18).getTime(), 101.73, 1.3719),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 19).getTime(), 99.25, 1.3775),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 20).getTime(), 99.02, 1.3672),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 21).getTime(), 100.04, 1.3873),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 24).getTime(), 104.31, 1.3932),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 25).getTime(), 110.38, 1.3911),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 26).getTime(), 111.04, 1.3838),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 27).getTime(), 110.72, 1.4172),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 28).getTime(), 112.14, 1.4164),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 31).getTime(), 109.57, 1.3947),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 1).getTime(), 110.28, 1.3676),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 2).getTime(), 113.72, 1.3803),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 3).getTime(), 118.74, 1.3744),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 4).getTime(), 118.66, 1.3761),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 7).getTime(), 119.41, 1.3744),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 8).getTime(), 118.57, 1.3785),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 9).getTime(), 116.46, 1.3596),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 10).getTime(), 115.07, 1.36),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 11).getTime(), 119.29, 1.3612),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 14).getTime(), 117.1, 1.3625),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 15).getTime(), 119.44, 1.3524),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 16).getTime(), 117.97, 1.3505),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 17).getTime(), 114.19, 1.3522),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 18).getTime(), 111.01, 1.3521),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 21).getTime(), 107.04, 1.3525),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 22).getTime(), 109.04, 1.35),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 23).getTime(), 105.93, 1.3347),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 25).getTime(), 103.88, 1.3244),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 28).getTime(), 97.46, 1.3334),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 29).getTime(), 104.51, 1.3343),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 30).getTime(), 106.91, 1.3453),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 1).getTime(), 106.83, 1.3487),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 2).getTime(), 104.26, 1.3386),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 5).getTime(), 104.38, 1.3463),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 6).getTime(), 106.38, 1.3397),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 7).getTime(), 108.8, 1.3386),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 8).getTime(), 106.65, 1.3324),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 9).getTime(), 108.51, 1.3368),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 12).getTime(), 105.47, 1.3188),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 13).getTime(), 102.53, 1.3094),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 14).getTime(), 99.57, 1.2972),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 15).getTime(), 98.21, 1.3013),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 16).getTime(), 101.8, 1.3025),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 19).getTime(), 100.62, 1.3017),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 20).getTime(), 105.12, 1.3076),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 21).getTime(), 104.64, 1.304),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 22).getTime(), 103.74, 1.3045),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 23).getTime(), 104.35, 1.304),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 27).getTime(), 102.38, 1.3074),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 28).getTime(), 100.51, 1.2926),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 29).getTime(), 101.22, 1.2952),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 30).getTime(), 102.1, 1.2973),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 3).getTime(), 108.29, 1.3061),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 4).getTime(), 108.14, 1.293),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 5).getTime(), 108.27, 1.2783),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 6).getTime(), 106.74, 1.2723),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 9).getTime(), 107.62, 1.2745),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 10).getTime(), 110.97, 1.2782),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 11).getTime(), 108.89, 1.2686),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 12).getTime(), 110.86, 1.2818),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 13).getTime(), 108.83, 1.2682),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 17).getTime(), 109.64, 1.274),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 18).getTime(), 111.54, 1.2825),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 19).getTime(), 109.85, 1.2937),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 20).getTime(), 109.13, 1.2948),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 23).getTime(), 110.11, 1.3035),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 24).getTime(), 107.3, 1.3004),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 25).getTime(), 110.82, 1.2978),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 26).getTime(), 111.94, 1.3152),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 27).getTime(), 114.24, 1.3192),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 30).getTime(), 113.42, 1.3123),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 31).getTime(), 114.41, 1.3053),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 1).getTime(), 114.84, 1.3179),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 2).getTime(), 116.97, 1.3167),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 3).getTime(), 116.17, 1.3106),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 6).getTime(), 118.01, 1.313),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 7).getTime(), 114.6, 1.3244),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 8).getTime(), 114.56, 1.3253),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 9).getTime(), 114.45, 1.3297),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 10).getTime(), 112.56, 1.3187),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 13).getTime(), 112.92, 1.3211),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 14).getTime(), 112.27, 1.3149),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 15).getTime(), 111.36, 1.3087),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 16).getTime(), 111.38, 1.311),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 17).getTime(), 111.05, 1.3149),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 21).getTime(), 113.06, 1.3255),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 22).getTime(), 114.74, 1.3251),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 23).getTime(), 116.88, 1.3308),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 24).getTime(), 115.73, 1.3463),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 27).getTime(), 114.86, 1.341),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 28).getTime(), 117.41, 1.3452),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 29).getTime(), 114.73, 1.3359),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 1).getTime(), 115.98, 1.332),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 2).getTime(), 114.02, 1.3202),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 5).getTime(), 111.17, 1.3226),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 6).getTime(), 108.48, 1.3114),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 7).getTime(), 109.3, 1.3149),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 8).getTime(), 111.66, 1.3256),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 9).getTime(), 112.41, 1.3108),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 12).getTime(), 111.38, 1.3141),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 13).getTime(), 110.62, 1.3109),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 14).getTime(), 106.67, 1.3025),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 15).getTime(), 104.01, 1.307),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 16).getTime(), 101.49, 1.3171),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 19).getTime(), 101.97, 1.3242),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 20).getTime(), 102.35, 1.3222),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 21).getTime(), 103.4, 1.319),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 22).getTime(), 90.6, 1.3194),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 23).getTime(), 91.32, 1.3263),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 26).getTime(), 91.62, 1.3328),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 27).getTime(), 89.26, 1.3336),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 28).getTime(), 86.96, 1.33),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 29).getTime(), 87.84, 1.3265),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 30).getTime(), 87.98, 1.3334),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 2).getTime(), 86.33, 1.3325),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 3).getTime(), 83.61, 1.3337),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 4).getTime(), 81.31, 1.3126),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 5).getTime(), 81.44, 1.3064),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 9).getTime(), 88.9, 1.3087),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 10).getTime(), 87.74, 1.3068),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 11).getTime(), 85.29, 1.3104),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 12).getTime(), 90.11, 1.3171),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 13).getTime(), 89.04, 1.3082),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 16).getTime(), 86.79, 1.3067),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 17).getTime(), 87.09, 1.3123),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 18).getTime(), 87.2, 1.3122),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 19).getTime(), 87.27, 1.3132),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 20).getTime(), 87.13, 1.3212),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 23).getTime(), 84.53, 1.3129),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 24).getTime(), 84.86, 1.3207),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 25).getTime(), 88.21, 1.321),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 26).getTime(), 91.01, 1.3232),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 27).getTime(), 91.4, 1.3248),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 30).getTime(), 89.15, 1.3229),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 1).getTime(), 87.35, 1.3226),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 2).getTime(), 86.32, 1.3154),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 3).getTime(), 81.89, 1.3147),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 4).getTime(), 81.62, 1.3091),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 7).getTime(), 80.92, 1.3052),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 8).getTime(), 77.61, 1.3015),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 9).getTime(), 77.7, 1.2954),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 10).getTime(), 77.67, 1.2959),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 11).getTime(), 76.72, 1.2937),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 14).getTime(), 74.68, 1.2847),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 15).getTime(), 73.13, 1.2769),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 16).getTime(), 74.03, 1.273),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 17).getTime(), 76.55, 1.2709),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 18).getTime(), 76.45, 1.2721),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 21).getTime(), 79.63, 1.2769),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 22).getTime(), 77.65, 1.2735),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 23).getTime(), 79.7, 1.2569),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 24).getTime(), 80.75, 1.2583),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 25).getTime(), 80.96, 1.2518),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 29).getTime(), 80.8, 1.2488),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 30).getTime(), 80.41, 1.2405),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 31).getTime(), 79.35, 1.2364),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 1).getTime(), 87.26, 1.242),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 4).getTime(), 88.13, 1.2495),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 5).getTime(), 88.63, 1.2437),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 6).getTime(), 91.52, 1.2535),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 7).getTime(), 87.11, 1.2568),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 8).getTime(), 87.59, 1.2482),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 11).getTime(), 87.18, 1.2504),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 12).getTime(), 89.78, 1.2477),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 13).getTime(), 90.54, 1.2596),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 14).getTime(), 91.99, 1.2608),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 15).getTime(), 92.7, 1.2633),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 18).getTime(), 94.41, 1.2578),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 19).getTime(), 94.43, 1.2692),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 20).getTime(), 94.27, 1.2703),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 21).getTime(), 88.91, 1.2586),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 22).getTime(), 89.44, 1.2545),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 25).getTime(), 90.14, 1.248),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 26).getTime(), 89.89, 1.2471),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 27).getTime(), 89.27, 1.2457),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 28).getTime(), 87.15, 1.2433),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 29).getTime(), 90.01, 1.2668),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 2).getTime(), 90.83, 1.2584),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 3).getTime(), 93.7, 1.262),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 5).getTime(), 92.59, 1.2384),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 6).getTime(), 91.21, 1.2283),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 9).getTime(), 90.86, 1.2299),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 10).getTime(), 89.89, 1.2255),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 11).getTime(), 89.89, 1.2244),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 12).getTime(), 89.67, 1.2199),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 13).getTime(), 90.41, 1.2232),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 16).getTime(), 90.31, 1.2267),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 17).getTime(), 89.03, 1.2234),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 18).getTime(), 88.04, 1.2261),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 19).getTime(), 87.82, 1.2257),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 20).getTime(), 86.19, 1.2176),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 23).getTime(), 83.96, 1.2126),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 24).getTime(), 83.73, 1.2062),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 25).getTime(), 87.69, 1.2132),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 26).getTime(), 89.24, 1.228),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 27).getTime(), 91.35, 1.237),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 30).getTime(), 91.9, 1.225),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 31).getTime(), 89.48, 1.2315),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 1).getTime(), 88.84, 1.2299),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 2).getTime(), 89.3, 1.2149),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 3).getTime(), 90.63, 1.239),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 6).getTime(), 93.03, 1.2422),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 7).getTime(), 95.3, 1.2422),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 8).getTime(), 94.72, 1.2364),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 9).getTime(), 98.28, 1.2278),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 10).getTime(), 99.41, 1.2298),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 13).getTime(), 97.89, 1.2339),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 14).getTime(), 96.8, 1.2329),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 15).getTime(), 96.69, 1.2288),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 16).getTime(), 98.04, 1.2356),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 17).getTime(), 97.5, 1.2315),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 20).getTime(), 97.37, 1.2343),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 21).getTime(), 97.53, 1.2472),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 22).getTime(), 98.82, 1.2472),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 23).getTime(), 100.53, 1.2583),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 24).getTime(), 100.71, 1.2533),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 27).getTime(), 99.82, 1.2514),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 28).getTime(), 98.98, 1.2564),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 29).getTime(), 97.93, 1.2538),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 30).getTime(), 97.96, 1.2497),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 31).getTime(), 102.97, 1.2578),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 4).getTime(), 101.66, 1.2566),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 5).getTime(), 102.39, 1.2603),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 6).getTime(), 108.7, 1.2626),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 7).getTime(), 111.47, 1.2796),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 10).getTime(), 110.42, 1.2795),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 11).getTime(), 110.23, 1.2858),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 12).getTime(), 110.59, 1.2894),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 13).getTime(), 114.35, 1.2912),
              new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 14).getTime(), 120.34, 1.3142)
          };
  
          ObjectProvider objProvider = new ObjectProvider(data);
  
          chart1.getDataSourceSettings().setDataSource(objProvider);
  
          if (fieldNames != "") {
          List<DataField> removeFields = new ArrayList<DataField>();
          List<String> includeFields = Arrays.asList(fieldNames.split(","));
          chart1.getDataSourceSettings().fillFromSchema();
  
          for (DataField dataField : chart1.getDataSourceSettings().getDataFields()) {
              if (dataField.isMeasure() && !includeFields.contains(dataField.getDataPath())) {
                  removeFields.add(dataField);
              }
  
          }
  
          for (DataField dataField : removeFields) {
              chart1.getDataSourceSettings().getDataFields().remove(dataField);
          }
      }
  }
  
  public static void PopulateOilPriceandEuroRate(Chart chart1) {
      PopulateOilPriceandEuroRate(chart1, "");
  }
  

  public static class OilPriceandEuroRate
  {
          private java.util.Date privateTransDate = new java.util.Date(0);
          public final java.util.Date getTransDate()
          {
                  return privateTransDate;
          }
          public final void setTransDate(java.util.Date value)
          {
                  privateTransDate = value;
          }
          private double privatePrice;
          public final double getPrice()
          {
                  return privatePrice;
          }
          public final void setPrice(double value)
          {
                  privatePrice = value;
          }
          private double privateEuro;
          public final double getEuro()
          {
                  return privateEuro;
          }
          public final void setEuro(double value)
          {
                  privateEuro = value;
          }
          public OilPriceandEuroRate(java.util.Date transDate, double price, double euro){
              this.setTransDate(transDate);
              this.setPrice(price);
              this.setEuro(euro);
          }
  }
  

After calling the compact method with a step set to one (1) month, the result chart provides summarized data compacting every 30/31 bars into one and producing a new bar which is the minimum Y value of those bars:

• image
• Java

• 

• PopulateOilPriceandEuroRate(chart1, "Price");
  
  chart1.getData().compact(DataUnit.MONTH);
  
  chart1.getTitles().add(new TitleDockable("Price of Oil per day (USD)"));
  chart1.setGallery(Gallery.BAR);
  chart1.getLegendBox().setVisible(false);
  chart1.getAxisX().setLabelAngle((short)90);
  chart1.getAxisY().getLabelsFormat().setFormat(AxisFormat.CURRENCY);
  

  public static void PopulateOilPriceandEuroRate(Chart chart1, String fieldNames) {
          OilPriceandEuroRate[] data = new OilPriceandEuroRate[] {
              new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 19).getTime(), 110.12, 1.3636),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 20).getTime(), 113.45, 1.3697),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 21).getTime(), 110.21, 1.3724),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 22).getTime(), 102.94, 1.3446),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 23).getTime(), 96.42, 1.3518),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 26).getTime(), 97.84, 1.3516),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 27).getTime(), 99.09, 1.3606),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 28).getTime(), 95.21, 1.3628),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 29).getTime(), 95.17, 1.3639),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 8, 30).getTime(), 96.72, 1.3449),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 3).getTime(), 98.85, 1.3281),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 4).getTime(), 92.61, 1.3294),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 5).getTime(), 97.1, 1.3328),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 6).getTime(), 98.95, 1.3408),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 7).getTime(), 97.71, 1.3512),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 10).getTime(), 101.37, 1.3584),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 11).getTime(), 102, 1.3657),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 12).getTime(), 103.21, 1.3805),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 13).getTime(), 100.86, 1.373),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 14).getTime(), 102.85, 1.3861),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 17).getTime(), 100.66, 1.377),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 18).getTime(), 101.73, 1.3719),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 19).getTime(), 99.25, 1.3775),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 20).getTime(), 99.02, 1.3672),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 21).getTime(), 100.04, 1.3873),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 24).getTime(), 104.31, 1.3932),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 25).getTime(), 110.38, 1.3911),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 26).getTime(), 111.04, 1.3838),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 27).getTime(), 110.72, 1.4172),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 28).getTime(), 112.14, 1.4164),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 9, 31).getTime(), 109.57, 1.3947),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 1).getTime(), 110.28, 1.3676),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 2).getTime(), 113.72, 1.3803),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 3).getTime(), 118.74, 1.3744),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 4).getTime(), 118.66, 1.3761),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 7).getTime(), 119.41, 1.3744),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 8).getTime(), 118.57, 1.3785),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 9).getTime(), 116.46, 1.3596),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 10).getTime(), 115.07, 1.36),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 11).getTime(), 119.29, 1.3612),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 14).getTime(), 117.1, 1.3625),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 15).getTime(), 119.44, 1.3524),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 16).getTime(), 117.97, 1.3505),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 17).getTime(), 114.19, 1.3522),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 18).getTime(), 111.01, 1.3521),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 21).getTime(), 107.04, 1.3525),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 22).getTime(), 109.04, 1.35),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 23).getTime(), 105.93, 1.3347),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 25).getTime(), 103.88, 1.3244),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 28).getTime(), 97.46, 1.3334),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 29).getTime(), 104.51, 1.3343),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 10, 30).getTime(), 106.91, 1.3453),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 1).getTime(), 106.83, 1.3487),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 2).getTime(), 104.26, 1.3386),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 5).getTime(), 104.38, 1.3463),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 6).getTime(), 106.38, 1.3397),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 7).getTime(), 108.8, 1.3386),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 8).getTime(), 106.65, 1.3324),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 9).getTime(), 108.51, 1.3368),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 12).getTime(), 105.47, 1.3188),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 13).getTime(), 102.53, 1.3094),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 14).getTime(), 99.57, 1.2972),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 15).getTime(), 98.21, 1.3013),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 16).getTime(), 101.8, 1.3025),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 19).getTime(), 100.62, 1.3017),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 20).getTime(), 105.12, 1.3076),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 21).getTime(), 104.64, 1.304),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 22).getTime(), 103.74, 1.3045),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 23).getTime(), 104.35, 1.304),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 27).getTime(), 102.38, 1.3074),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 28).getTime(), 100.51, 1.2926),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 29).getTime(), 101.22, 1.2952),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2011, 11, 30).getTime(), 102.1, 1.2973),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 3).getTime(), 108.29, 1.3061),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 4).getTime(), 108.14, 1.293),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 5).getTime(), 108.27, 1.2783),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 6).getTime(), 106.74, 1.2723),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 9).getTime(), 107.62, 1.2745),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 10).getTime(), 110.97, 1.2782),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 11).getTime(), 108.89, 1.2686),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 12).getTime(), 110.86, 1.2818),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 13).getTime(), 108.83, 1.2682),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 17).getTime(), 109.64, 1.274),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 18).getTime(), 111.54, 1.2825),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 19).getTime(), 109.85, 1.2937),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 20).getTime(), 109.13, 1.2948),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 23).getTime(), 110.11, 1.3035),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 24).getTime(), 107.3, 1.3004),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 25).getTime(), 110.82, 1.2978),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 26).getTime(), 111.94, 1.3152),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 27).getTime(), 114.24, 1.3192),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 30).getTime(), 113.42, 1.3123),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 0, 31).getTime(), 114.41, 1.3053),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 1).getTime(), 114.84, 1.3179),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 2).getTime(), 116.97, 1.3167),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 3).getTime(), 116.17, 1.3106),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 6).getTime(), 118.01, 1.313),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 7).getTime(), 114.6, 1.3244),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 8).getTime(), 114.56, 1.3253),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 9).getTime(), 114.45, 1.3297),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 10).getTime(), 112.56, 1.3187),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 13).getTime(), 112.92, 1.3211),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 14).getTime(), 112.27, 1.3149),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 15).getTime(), 111.36, 1.3087),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 16).getTime(), 111.38, 1.311),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 17).getTime(), 111.05, 1.3149),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 21).getTime(), 113.06, 1.3255),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 22).getTime(), 114.74, 1.3251),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 23).getTime(), 116.88, 1.3308),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 24).getTime(), 115.73, 1.3463),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 27).getTime(), 114.86, 1.341),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 28).getTime(), 117.41, 1.3452),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 1, 29).getTime(), 114.73, 1.3359),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 1).getTime(), 115.98, 1.332),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 2).getTime(), 114.02, 1.3202),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 5).getTime(), 111.17, 1.3226),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 6).getTime(), 108.48, 1.3114),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 7).getTime(), 109.3, 1.3149),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 8).getTime(), 111.66, 1.3256),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 9).getTime(), 112.41, 1.3108),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 12).getTime(), 111.38, 1.3141),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 13).getTime(), 110.62, 1.3109),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 14).getTime(), 106.67, 1.3025),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 15).getTime(), 104.01, 1.307),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 16).getTime(), 101.49, 1.3171),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 19).getTime(), 101.97, 1.3242),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 20).getTime(), 102.35, 1.3222),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 21).getTime(), 103.4, 1.319),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 22).getTime(), 90.6, 1.3194),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 23).getTime(), 91.32, 1.3263),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 26).getTime(), 91.62, 1.3328),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 27).getTime(), 89.26, 1.3336),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 28).getTime(), 86.96, 1.33),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 29).getTime(), 87.84, 1.3265),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 2, 30).getTime(), 87.98, 1.3334),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 2).getTime(), 86.33, 1.3325),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 3).getTime(), 83.61, 1.3337),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 4).getTime(), 81.31, 1.3126),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 5).getTime(), 81.44, 1.3064),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 9).getTime(), 88.9, 1.3087),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 10).getTime(), 87.74, 1.3068),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 11).getTime(), 85.29, 1.3104),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 12).getTime(), 90.11, 1.3171),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 13).getTime(), 89.04, 1.3082),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 16).getTime(), 86.79, 1.3067),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 17).getTime(), 87.09, 1.3123),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 18).getTime(), 87.2, 1.3122),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 19).getTime(), 87.27, 1.3132),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 20).getTime(), 87.13, 1.3212),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 23).getTime(), 84.53, 1.3129),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 24).getTime(), 84.86, 1.3207),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 25).getTime(), 88.21, 1.321),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 26).getTime(), 91.01, 1.3232),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 27).getTime(), 91.4, 1.3248),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 3, 30).getTime(), 89.15, 1.3229),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 1).getTime(), 87.35, 1.3226),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 2).getTime(), 86.32, 1.3154),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 3).getTime(), 81.89, 1.3147),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 4).getTime(), 81.62, 1.3091),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 7).getTime(), 80.92, 1.3052),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 8).getTime(), 77.61, 1.3015),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 9).getTime(), 77.7, 1.2954),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 10).getTime(), 77.67, 1.2959),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 11).getTime(), 76.72, 1.2937),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 14).getTime(), 74.68, 1.2847),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 15).getTime(), 73.13, 1.2769),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 16).getTime(), 74.03, 1.273),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 17).getTime(), 76.55, 1.2709),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 18).getTime(), 76.45, 1.2721),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 21).getTime(), 79.63, 1.2769),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 22).getTime(), 77.65, 1.2735),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 23).getTime(), 79.7, 1.2569),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 24).getTime(), 80.75, 1.2583),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 25).getTime(), 80.96, 1.2518),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 29).getTime(), 80.8, 1.2488),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 30).getTime(), 80.41, 1.2405),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 4, 31).getTime(), 79.35, 1.2364),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 1).getTime(), 87.26, 1.242),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 4).getTime(), 88.13, 1.2495),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 5).getTime(), 88.63, 1.2437),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 6).getTime(), 91.52, 1.2535),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 7).getTime(), 87.11, 1.2568),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 8).getTime(), 87.59, 1.2482),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 11).getTime(), 87.18, 1.2504),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 12).getTime(), 89.78, 1.2477),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 13).getTime(), 90.54, 1.2596),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 14).getTime(), 91.99, 1.2608),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 15).getTime(), 92.7, 1.2633),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 18).getTime(), 94.41, 1.2578),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 19).getTime(), 94.43, 1.2692),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 20).getTime(), 94.27, 1.2703),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 21).getTime(), 88.91, 1.2586),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 22).getTime(), 89.44, 1.2545),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 25).getTime(), 90.14, 1.248),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 26).getTime(), 89.89, 1.2471),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 27).getTime(), 89.27, 1.2457),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 28).getTime(), 87.15, 1.2433),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 5, 29).getTime(), 90.01, 1.2668),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 2).getTime(), 90.83, 1.2584),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 3).getTime(), 93.7, 1.262),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 5).getTime(), 92.59, 1.2384),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 6).getTime(), 91.21, 1.2283),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 9).getTime(), 90.86, 1.2299),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 10).getTime(), 89.89, 1.2255),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 11).getTime(), 89.89, 1.2244),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 12).getTime(), 89.67, 1.2199),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 13).getTime(), 90.41, 1.2232),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 16).getTime(), 90.31, 1.2267),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 17).getTime(), 89.03, 1.2234),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 18).getTime(), 88.04, 1.2261),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 19).getTime(), 87.82, 1.2257),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 20).getTime(), 86.19, 1.2176),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 23).getTime(), 83.96, 1.2126),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 24).getTime(), 83.73, 1.2062),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 25).getTime(), 87.69, 1.2132),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 26).getTime(), 89.24, 1.228),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 27).getTime(), 91.35, 1.237),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 30).getTime(), 91.9, 1.225),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 6, 31).getTime(), 89.48, 1.2315),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 1).getTime(), 88.84, 1.2299),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 2).getTime(), 89.3, 1.2149),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 3).getTime(), 90.63, 1.239),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 6).getTime(), 93.03, 1.2422),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 7).getTime(), 95.3, 1.2422),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 8).getTime(), 94.72, 1.2364),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 9).getTime(), 98.28, 1.2278),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 10).getTime(), 99.41, 1.2298),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 13).getTime(), 97.89, 1.2339),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 14).getTime(), 96.8, 1.2329),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 15).getTime(), 96.69, 1.2288),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 16).getTime(), 98.04, 1.2356),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 17).getTime(), 97.5, 1.2315),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 20).getTime(), 97.37, 1.2343),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 21).getTime(), 97.53, 1.2472),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 22).getTime(), 98.82, 1.2472),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 23).getTime(), 100.53, 1.2583),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 24).getTime(), 100.71, 1.2533),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 27).getTime(), 99.82, 1.2514),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 28).getTime(), 98.98, 1.2564),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 29).getTime(), 97.93, 1.2538),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 30).getTime(), 97.96, 1.2497),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 7, 31).getTime(), 102.97, 1.2578),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 4).getTime(), 101.66, 1.2566),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 5).getTime(), 102.39, 1.2603),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 6).getTime(), 108.7, 1.2626),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 7).getTime(), 111.47, 1.2796),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 10).getTime(), 110.42, 1.2795),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 11).getTime(), 110.23, 1.2858),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 12).getTime(), 110.59, 1.2894),
          new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 13).getTime(), 114.35, 1.2912),
              new OilPriceandEuroRate(new java.util.GregorianCalendar(2012, 8, 14).getTime(), 120.34, 1.3142)
          };
  
          ObjectProvider objProvider = new ObjectProvider(data);
  
          chart1.getDataSourceSettings().setDataSource(objProvider);
  
          if (fieldNames != "") {
          List<DataField> removeFields = new ArrayList<DataField>();
          List<String> includeFields = Arrays.asList(fieldNames.split(","));
          chart1.getDataSourceSettings().fillFromSchema();
  
          for (DataField dataField : chart1.getDataSourceSettings().getDataFields()) {
              if (dataField.isMeasure() && !includeFields.contains(dataField.getDataPath())) {
                  removeFields.add(dataField);
              }
  
          }
  
          for (DataField dataField : removeFields) {
              chart1.getDataSourceSettings().getDataFields().remove(dataField);
          }
      }
  }
  
  public static void PopulateOilPriceandEuroRate(Chart chart1) {
      PopulateOilPriceandEuroRate(chart1, "");
  }
  

  public static class OilPriceandEuroRate
  {
          private java.util.Date privateTransDate = new java.util.Date(0);
          public final java.util.Date getTransDate()
          {
                  return privateTransDate;
          }
          public final void setTransDate(java.util.Date value)
          {
                  privateTransDate = value;
          }
          private double privatePrice;
          public final double getPrice()
          {
                  return privatePrice;
          }
          public final void setPrice(double value)
          {
                  privatePrice = value;
          }
          private double privateEuro;
          public final double getEuro()
          {
                  return privateEuro;
          }
          public final void setEuro(double value)
          {
                  privateEuro = value;
          }
          public OilPriceandEuroRate(java.util.Date transDate, double price, double euro){
              this.setTransDate(transDate);
              this.setPrice(price);
              this.setEuro(euro);
          }
  }
  

Constructor Summary

Constructors

Constructor and Description
CompactFormulas()

Method Summary

Methods

Modifier and Type	Method and Description
static CompactFormulaListener	getAverage() Description goes here
static CompactFormulaListener	getFirst() Description goes here
static CompactFormulaListener	getHiLowClose() Description goes here
static CompactFormulaListener	getLast() Description goes here
static CompactFormulaListener	getMax() Description goes here
static CompactFormulaListener	getMin() Description goes here
static CompactFormulaListener	getOpenHiLowClose() Description goes here

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

CompactFormulas

public CompactFormulas()

Method Detail

getAverage

public static CompactFormulaListener getAverage()

Description goes here

getFirst

public static CompactFormulaListener getFirst()

Description goes here

getHiLowClose

public static CompactFormulaListener getHiLowClose()

Description goes here

getLast

public static CompactFormulaListener getLast()

Description goes here

getMax

public static CompactFormulaListener getMax()

Description goes here

getMin

public static CompactFormulaListener getMin()

Description goes here

getOpenHiLowClose

public static CompactFormulaListener getOpenHiLowClose()

Description goes here