What is X-axis and Y-axis for a graph, how graph is being plotted? about anemometer

For more information please refer this screen shot:
https://www.dropbox.com/s/t1wthhk1i22hr43/box_ts_cnt_and_lower_pane.PNG

[gtowey]

@Maheshpatilblr

The way in which the count of items are grouped can be change in the config files. For example, the default behavior defined by the sample config is as follows:

$conf['graph_defaults'] = array(
    'fact-group'    => 'hour_ts',     // <----- this determines how counts are grouped. hour_ts is the column name.
    'fact-order'    => 'hour_ts',
    'fact-limit' => '',
    'dimension-ts_min_start' => date("Y-m-d H:i:s", strtotime( '-7 day')),
    'dimension-ts_min_end'  => date("Y-m-d H:i:s"),
    'table_fields' => array('hour_ts'),
    // hack ... fix is to make query builder select the group and order fields,
    // then table fields only has to contain the plot_field
    'plot_field' => 'Query_time_sum',
);

Then to find out what the hour_ts column is, look in the $conf['reports'] section starting on line 296:

    // custom fields
    'custom_fields' => array(
        'checksum' => 'HEX(checksum)',
        'date'  => 'DATE(ts_min)',
        'hour'  => 'substring(ts_min,1,13)',
        'hour_ts'   => 'unix_timestamp(substring(ts_min,1,13))',  <--- this is the expression we are grouping on.  In this case it's the hour in which that sample started.

        'snippet' => 'LEFT(dimension.sample,20)',
        'index_ratio' =>'ROUND(SUM(Rows_examined_sum)/SUM(rows_sent_sum),2)',
        'query_time_avg' => 'SUM(Query_time_sum) / SUM(ts_cnt)',
        'rows_sent_avg' => 'ROUND(SUM(Rows_sent_sum)/SUM(ts_cnt),0)',

    ),

You can increase the graph resolution by adding a new custom field such as:

                'minute_ts'     => 'unix_timestamp(substring(ts_min,1,16))',

And changing the fact-group in the report definition.

[gtowey]

closing old issue. Please let me know if there are still problems here.