Use this shortcode to display field totals and statistics in a page, post, View, or anywhere else shortcodes are accepted.
Usage
Insert the following shortcode on a page, post, View, or in any field in your form.
[frm-stats id=x type=count]
Replace x with the ID or key of the field you would like to display statistics for
Replace count with the type of statistics to display (all the different types are listed below)
Required Parameters
- id - ID or key of the field you would like to display statistics for
- type - Specify the type of statistic you would like returned. If not specified, this defaults to total.
- total: Adds up all the numeric values
- count: Counts the number of entries
- average or mean: Displays the average of numeric values
- median: Displays the median of numeric values
- star: Displays the average value in the format of a star rating graphic
- maximum: Gets the maximum value from a set of values
- minimum: Gets the minimum value from a set of values
- unique: Counts the number of unique entries
Optional Parameters
-
user_id
Include only entries from a specific user in the statistic. This must be an integer or 'current'. To get a user ID integer, go into Users, select a user, and the user ID number will be in the address bar. Example: [frm-stats id=x type=count user_id=current]
-
entry
Get a total for a specific entry or entries. You may use entry IDs or keys. Example: [frm-stats id=x type=star entry="250,252,255"]. In a View you can use [frm-stats id=x type=star entry="[id]"]
-
limit
Set a maximum number of entries to use for this stat. Example: [frm-stats id=x type=count limit=5]
-
thousands_sep
Set the thousands separator for the displayed total. Example: [frm-stats id=x type=count thousands_sep=","]
-
decimal
Determine how many decimal places to show. Example: [frm-stats id=x type=total decimal=2]
-
dec_point
Determine which character should be used as the decimal point in the displayed number. By default, this will be a period. Example: [frm-stats id=x type=total dec_point=","]
-
drafts
By default, the frm-stats shortcode does not count draft entries. You can choose to include only drafts, or both drafts and entries. This shortcode will count only drafts in the statistic:
[frm-stats id=x drafts=1]
This shortcode will count both drafts and completed entries in the statistic:
[frm-stats id=x drafts=both]
-
created_at_greater_than
Only include entries created after a specific or dynamic date. For example, you may total entries created in the last month with created_at_greater_than="-1 month" or use a specific date like created_at_greater_than="2016-07-31". When using a specific date, it must be in the Y-m-d format.
[frm-stats id="x" type="total" created_at_greater_than="Y-m-d"]
-
created_at_less_than
Only include entries created before a specific or dynamic date. For example, you may total entries created before today with created_at_less_than="-1 day" or use a specific date like created_at_less_than="2016-05-31". When using a specific date, it must be in the Y-m-d format.
[frm-stats id="x" type="total" created_at_less_than="-1 month"]
-
field filters
Filter your statistic by another field's value. Review the filtering options below.
Field filters
Only include entries where a field in the same form is equal to, not equal to, greater than (or equal to), less than (or equal to), or contains a specific value.
Note: you can use multiple field filters in the same shortcode to get more refined statistics.
-
Equals
Only include entries where a field is equal to a specific value. For example, you may get a total for field x when field 25 equals "Yes":
[frm-stats id=x type=total 25="Yes"]
Replace 25 with the ID of any field in the form. Replace "Yes" with any value.
-
Not equal
Only include entries where a field is NOT equal to a specific value.
[frm-stats id=x type=total 25_not_equal="Yes"]
Replace 25 with the ID of any field in the form. Replace "Yes" with any value.
-
Greater than
Only include entries where a field is greater than a specific value. This works well with numbers:
[frm-stats id=x type=total 25_greater_than="10"]
and also with dates:
[frm-stats id=x type=total 25_greater_than="2015-03-01"]
You may also use a dynamic date string:
[frm-stats id=x type=total 25_greater_than="-1 week"]
Replace 25 with the ID of a field in the form.
-
Greater than or equal to
Only include entries where a field is greater than or equal to a specific value. This works well with numbers:
[frm-stats id=x type=total 25_greater_than_or_equal_to="10"]
and also with dates:
[frm-stats id=x type=total 25_greater_than_or_equal_to="2015-03-01"]
You may also use a dynamic date string:
[frm-stats id=x type=total 25_greater_than_or_equal_to="-1 week"]
Replace 25 with the ID of a field in the form.
-
Less than
Only include entries where a field is less than a specific value. This works well with numbers:
[frm-stats id=x type=total 25_less_than="10"]
and also with dates:
[frm-stats id=x type=total 25_less_than="2015-03-01"]
You may also use a dynamic date string:
[frm-stats id=x type=total 25_less_than="NOW"]
Replace 25 with the ID of a field in the form.
-
Less than or equal to
Only include entries where a field is less than or equal to a specific value. This works well with numbers:
[frm-stats id=x type=total 25_less_than_or_equal_to="10"]
and also with dates:
[frm-stats id=x type=total 25_less_than_or_equal_to="2015-03-01"]
You may also use a dynamic date string:
[frm-stats id=x type=total 25_less_than_or_equal_to="NOW"]
Replace 25 with the ID of a field in the form.
-
Contains
Only include entries where a field contains a substring or value.
[frm-stats id=x type=total 25_contains="Activity"]
Replace 25 with the ID of any field in the form. Replace "Activity" with any value.
-
Does not contain
Total entries where a field does NOT contain a substring or value.
[frm-stats id=x type=total 25_does_not_contain="Activity"]
Replace 25 with the ID of any field in the form. Replace "Activity" with any value.
PHP Alternative
echo FrmProStatisticsController::stats_shortcode(array('id' => x, 'type' => 'count', 'user_id' => 'current'));
All of the parameters listed above can be used in this function as well.
Related Customizations
Total entry count across all forms
This shortcode will get the total entry count across all forms for the current user. Add this function to your theme functions.php or to a new plugin, and add the shortcode [entry-count] in your page.
add_shortcode('entry-count','my_entry_count');
function my_entry_count($atts){
global $user_ID;
$ids = FrmDb::get_col( 'frm_items', array('user_id' => $user_ID));
return count($ids);
}
Combined total for two fields
This creates a new shortcode [fields-stats] for use on your page. Your shortcode will look like this: [fields-stats ids="x,y,z"]. Replace x, y, and z with the IDs of the fields you want to total.
add_shortcode('fields-stats','my_fields_stats');
function my_fields_stats($atts){
$defaults = array(
'ids' => false,
);
$atts = array_merge($defaults, $atts);
$ids = explode( ',', $atts['ids'] );
unset( $atts['ids'] );
$total = 0;
foreach ( $ids as $id ) {
$atts['id'] = $id;
$total += FrmProStatisticsController::stats_shortcode( $atts );
}
return $total;
}
Percentage of a specific field value
After inserting this function in a new plugin or in your theme functions.php, add the shortcode [frm-percent id=x value="Option 1"] on your page.
add_shortcode('frm-percent', 'frm_stats_percent');
function frm_stats_percent($atts){
$defaults = array(
'id' => false, 'user_id' => false,
'value' => false, 'round' => 100, 'limit' => ''
);
extract(shortcode_atts($defaults, $atts));
if (!$id) return;
$type = 'count';
$value_count = FrmProStatisticsController::stats_shortcode(compact('id', 'type', 'value', 'user_id', 'limit'));
$total_count = FrmProStatisticsController::stats_shortcode(compact('id', 'type', 'user_id', 'limit'));
return round((($value_count / $total_count) * 100), $round);
}
