bullet_chart_symbols

creates bullet chart with symbols

bullet_chart_symbols(file_name = NULL, sheet_name = "Sheet1",
  dataframe = NULL, indicator_name = "indicator_name",
  actual = "actual", actual_lastweek = "actual_lastweek",
  actual_lastyear = "actual_lastyear", target = "target",
  for_year = year(Sys.Date()), chart_type = "static",
  cal_type = "fis", small = FALSE, legend = TRUE,
  remove_no_targets = FALSE, show_text = FALSE)

Arguments

file_name	path of Excel file
sheet_name	specify which sheet in Excel file, Default: "Sheet1"
dataframe	specify R dataframe input
indicator_name	specify the name of the column that has your indicator/KPI names
actual	specify the name of the column that has the current value of your indicators/KPIs
actual_lastweek	specify the name of the column that has the indicator/KPI value from the previous week
actual_lastyear	specify the name of the column that has the indicator/KPI value from the previous year
target	specify the name of the column that has the target value for the indicator/KPI
for_year	specify the year in which the report is being made, Default: year(Sys.Date())
chart_type	static of interactive (ggiraph) version
cal_type	define what calendar you are using. Options are "fis" for fiscal year starting October 1st, "cal" for calendar year starting January 1st, or enter your own custom date in the format "YYYY/MM/DD", Default: fis
small	specify whether you want the small version of the plot (TRUE or FALSE), Default: FALSE
legend	specify whether you want to show the legend, Default: TRUE
remove_no_targets	remove indicators with Targets == NA or 0, Default: FALSE
show_text	Show 'Last Week' & 'Last Year' text, when `small = TRUE` or `chart_type = "interactive"` then no text will be shown by default.

Details

The bar for each Indicator show the progression along the horizontal-axis presenting the percentage of the yearly target completed. This axis also shows the percent of the year gone by with the vertical line indicating what exact percentage "Today" is, along this percentage.

Each bar is colored "green" if the Indicator completion is close to or past "Today", "orange" if it's close, and "red" if it is far off track.

The symbols represent the indicator value for last week (diamond) and last year (circle).

See also

geom_bar, scale_manual

Examples

data("bc_ex_TC")
bullet_chart_symbols(dataframe = bc_ex_TC)