rpivotTable | A R wrapper for the great library pivottable

You can use the HTML function to just use tags like this:

HTML("

There are multiple issues here.

• you can specify renderers via the anonymos renderers argument in rpivotTable(). I have the JS code form here.
• however, there is a bug when only selecting one option. In this case, rpivotTable() wraps the argument in a list again (see the Map() call in the original function code) and the forwarding to JS fails.

Therefore, I accounted for this issue and extended the function a bit. Play around with aggregators/renderers to see how it behaves differently to the original rpivotTable() function.

A pivotTable is a htmlwidget, so you can use htmlwidgets::saveWidget to save the table in a html file and webshot::webshot to export it to png (or pdf).

This seems to work. You need to have sidebarMenu for your menuItems. Also, you need to change tabName to farmer so it matches your menuItem. And I don't think you need mainPanel in there (you can use mainPanel with sidebarPanel as part of a sidebarLayout if you wanted that layout - see layout options). See if this works for you.

According to the documention of rpivotTable, there is no export facility.

So, you have to aggregate on your own. One possibility is

OK - here's a bit more elaborate example that should be closer to what you want to achieve: for modifying labels on x-axis to show date ranges you need to put in a simple function. And, I'm using breaks instead date_breaks in order to move the tick marks more or less in the middle under the bars of the histogram.

The problem is that your variable start_year_month is a character string (or factor) and sorted alphabetically.

After calling