frm_graph_data

This example will add a row of data to a graph. Replace 'My graph' with your graph title. Please note that you must include the title parameter in your graph shortcode.

add_filter('frm_graph_data', 'my_custom_graph_data', 10, 2);
function my_custom_graph_data( $data, $atts ) {
    if ( isset( $atts['title'] ) && $atts['title'] == 'My graph' ) {
        $data[] = array( 'X-axis label', 10, 20, 30 );
    }
    return $data;
}

Change the x-axis labels in your graph. Change First Label, Second Label, and Third Label to your new x-axis graph labels. Replace 'My graph' with your graph title. Please note that you must include the title parameter in your graph shortcode.

add_filter( 'frm_graph_data', 'change_my_graph_labels', 10, 2 );
function change_my_graph_labels( $data, $atts ) {
	if ( isset( $atts['title'] ) && $atts['title'] == 'My graph' ) {
		$new_labels = array( 'First label', 'Second label', 'Third label' );

		foreach ( $new_labels as $key => $label ) {
			$row_key = $key + 1;
			if ( isset( $data[ $row_key ] ) ) {
				$data[ $row_key ][0] = $label;
			}
		}
	}
	return $data;
}

Use the code below to change the format for dates on the x-axis of a graph. Replace 'created_at' with the value or date field you are setting for your x-axis. Replace 'F d' with the format you would like to use. You may use any of the date formats described here.

add_filter('frm_graph_data', 'change_my_graph_date_format', 10, 2);
function change_my_graph_date_format( $data, $atts ) {
	if ( isset( $atts['x_axis'] ) && $atts['x_axis'] == 'created_at' ) {
		$wp_date_format = get_option('date_format');
		$new_format = 'F d';

		for ( $i = 1, $l = count( $data ); $i<$l; $i++ ) {
			$date = $data[ $i ][0];
			$date = DateTime::createFromFormat( $wp_date_format, $date );
			$data[ $i ][0] = $date->format( $new_format );
		}
	}
	return $data;
}

Use the code below to convert a line graph of numbers to a cumulative graph. In order for this code to work, your graph shortcode must be graphing one field and an x_axis parameter must be set. It must also include data_type="total" and title="Your title". You can add the code below to the Code Snippets plugin or a child theme's functions.php file. Replace 'Cumulative graph' with the title you have given your graph.

add_filter('frm_graph_data', 'generate_cumulative_graph', 10, 2);
function generate_cumulative_graph( $data, $atts ) {
	if ( isset( $atts['title'] ) && $atts['title'] == 'Cumulative graph' ) {

		for ( $i=2, $l=count($data); $i<$l; $i++ ) {
			$data[ $i ][1]+= $data[ $i-1 ][1];
		}
	}
	return $data;
}

Use the code below to display a graph of a field with text values on one axis and the corresponding stats on the other. For example, you could display business locations and the gas they use, employees and the hours they've worked, or bank account holders and their withdrawals.

add_filter( 'frm_graph_data', 'frm_stats_graph', 10, 2 );
function frm_stats_graph( $data, $atts ) {
	if ( isset( $atts['title'] ) && $atts['title'] == 'gas' ) {
		$data[0][1] = "Gas (in gallons)";
		for ( $i = 1, $l = count( $data ); $i++){
                  $data[$i][1] = FrmProStatisticsController::stats_shortcode( array( 'id' => 4134, 'type' => 'total', '4135' => $data[$i][0] ) );
		}
	}

	return $data;
}

Notes:

• The graph should have only one field in the fields param.
• The graph shortcode needs a title param so it can be identified by the code. Use this title in line 3 in place of 'gas'.'
• Change "Gas (in gallons)" to the label you want for the stats on the graph.
• Change 4134 to the id of the field you want to use for the stat.
• Change 'total' to the type of stat you want to use.
• Change 4135 to the other field in the graph, which will be used a filter for the stat.
• Add any other params you want to the stat. You could filter by date, for example.

With this code example, you can create a graph which shows the value from a single entry and the average, across multiple fields. Forr example, in an hbar graph, each field will have two bars, one showing the value from the specified entry and the other showing the average value for that field across all entries.

Sample graph shortcode:

[frm-graph fields="4250,4251,4252,4253,4254" type=hbar entry=[id] data_type=average title="Your results"]

1. For the fields param, list the fields you want to show in the graph.
2. Use the entry param to set the id of the single entry. Or use [id] in a View to use the current entry.
3. Set the data type to 'average' so the values for the single entry are shown.
4. The graph shortcode needs a title param so the code will work on the proper graph. The title is added to the code in line 4.

add_filter('frm_graph_data', 'frm_compare_average_graph', 10, 2);

function frm_compare_average_graph( $data, $atts ) {
	if ( ! isset( $atts['title'] ) || $atts['title'] !== 'Score comparison' ) { // Change 'Score comparison' to the title of your graph.
		return $data;
	}
	
	$data[0][1] = 'Your score';  // Change 'Your score' to the label for the values of the single entry
	$data[0][2] = 'Average score';  // Change 'Average score' to the label for the average values 

	for ( $i = 1, $l = count( $data ); $i id ) ) {
  		if ( ! isset( $atts['fields'][ $i - 1] ) || ! isset( $atts['fields'][ $i - 1]->id ) ) {
			continue;
		}
		
		$total = $data[$i][2] = FrmProStatisticsController::stats_shortcode( array( 'id'   => $atts['fields'][ $i - 1 ]->id,
				                                                                     'type' => 'total'
		) );
		
		$count = $data[$i][2] = FrmProStatisticsController::stats_shortcode( array( 'id'   => $atts['fields'][ $i - 1 ]->id,
				                                                                     'type' => 'count'
		) );
																						 		
		$data[ $i ][2] = ( $total - $data[$i][1] ) / ( $count - 1 );																		 													 
	}

	return $data;
}