Stack Overflow
Stack Overflow

Questions tagged [rpivottable]

`rpivotTable` is an R library that allows for the creation of interactive drag'n'drop pivot tables and charts. It is an R wrapper for the PivotTable.js library.

rpivotTable is an R library that allows for the creation of interactive drag'n'drop pivot tables and charts. It is an R wrapper for the PivotTable.js library.

74 questions
13
votes
2 answers

Save/Load rpivottable configuration

I use rpivottable on several (rmarkdown) web pages. I have seen an example here of saving/restoring table configuration to/from cookie. Since I am not good in javascript, I would like to ask if it is possible to programmatically add two buttons in…
gd047
  • 29,749
  • 18
  • 107
  • 146
8
votes
2 answers

rpivottable: drop down lists open in wrong position

When clicking on drop down arrow, near grouping categories, the corresponding list opens on top of the page. (At first I thought it didn't work at all.). The correct position is next to the arrow, as shown in the picture. rmarkdown reproducible…
gd047
  • 29,749
  • 18
  • 107
  • 146
8
votes
3 answers

download rpivotTable output in shiny

I've found an interesting package rpivotTable. I'd like to create shiny app which includes rpivotTable with the possibility to download generated data using downloadHandler. However, I am unable to find the solution, how to create data.frame or…
AK47
  • 1,318
  • 4
  • 17
  • 30
6
votes
2 answers

How to set size of rpivotTable in rmarkdown document

I would like to include several rpivotTables in an rmarkdown HTML output (document, flexdashboard, other options that result in a standalone HTML file are ok; I can't use Shiny for this). How can I specify a fixed width and/or height for this…
RyanStochastic
  • 3,963
  • 5
  • 17
  • 24
6
votes
1 answer

RPivotTable being able to list more than allowable amount

I have created an rpivottable and my problem with it is that when it runs, I can't click on one of the options on the side bar to filter out a specific factor because it says there are too many to list. Pivottable: And then when I click on…
R Guru
  • 171
  • 1
  • 12
5
votes
0 answers

R rpivotTable add Plotly chart renderers

I want to add Plotly chart renderers to the rpivotTable() function from the R package rpivotTable. I followed the instructions given in the Javascript Pivot Table Wiki to add optional extra renderers. Unfortunatey, following these instructions will…
Andreas Kitsche
  • 51
  • 2
4
votes
0 answers

rpivotTable & Shiny: change column sizes & colors

Using rpivotTable in a Shiny app. It works wonderfully; however, I would like to customize the column widths & background colors/theme within the table itself. Seems it might be possible via CSS, but I presently have no idea where to start. Here's…
Mach5RacerGoGo
  • 97
  • 10
4
votes
2 answers

R Webshot jpeg image is blank

I am trying to get a screenshot image of rPivotTable in Shiny. I am saving the rpivottable using saveWidget() from htmlwidgets. I then want to use webshot() to convert the html to jpeg image. The html generated from the saveWidget is displaying…
user98180
  • 149
  • 1
  • 4
  • 12
4
votes
0 answers

Creating aggregators in rpivotTable

I'm starting to use the rpivotTable function: library(rpivotTable) rpivotTable(mtcars, rows="gear", col="cyl", aggregatorName="Average", vals="mpg", rendererName="Bar Chart") With this code I have the average mpg by cyl and gear. What if I would…
dax90
  • 1,088
  • 14
  • 29
3
votes
2 answers

adding Calculation row to PivotTable in r

here's my data df=data.frame("indication"=c(1,1,0,0,1,0,1,1),"indication2"=c(1,0,1,0,1,0,0,1),"grade"=c(65,67,80,20,100,91,70,55), "group"=c("blue","red","green","blue","green","blue","red","green")) indication indication2 grade group 1 …
nomi
  • 91
  • 7
3
votes
3 answers

Scroll long pivot table (package rpivottable and knitr)

I would like to generate a pivot table from rpivotTable library with a vertical scrollbar to allow viewing long outputs. The pivot table is generated with knitr in RStudio and is embedded in a flexdashboard template. I am not using shiny…
Jacek Kotowski
  • 620
  • 16
  • 49
2
votes
1 answer

How can I avoid rpivotTable overlapping rest of HTML report?

I am trying to include an rpivotTable in my HTML report but it keeps overlapping the graph I have below. This is an example code so that you can see that when you render Rmd to HTML it will overlap whatever is below. library(tidyverse) mt <-…
meri
  • 29
  • 2
2
votes
1 answer

rpivottable: How to Statically Show Values on rpivottable Where renderName is a Chart

Using rpivottable function in my code. rpivottable provides us readymade graph options which we can choose. eg 1. Heat map 2. Bar chart 3. Tree map 4. Horizontal stacked bar chart etc. For example, when "Horizontal Bar Chart" is selected, whenever I…
Shweta
  • 23
  • 7
2
votes
1 answer

Is it possible to customize the size of rpivottable treemaps

This code works and the pivot table is drawn but the treemap is huge and I need it to render to about 50% of the current size, 500px would be fine for now. It seems to ignore the size settings. One pivot table overlaps the other when…
lejdale
  • 69
  • 6
2
votes
2 answers

Shiny: Re-using the same plot in multiple tabs is not working

I am trying to create a shiny dashboard that has two tabs. First tab (called: dashboard) shows two graphs, and the other one (called: widgets) is intended to show the first graph from the first tab (called: mpg) and below it is the rpivottable.…
Fahadakbar
  • 488
  • 1
  • 8
  • 26
1
2 3 4 5