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
0
votes
0 answers

How to remove grand totals in R using the RpivoTable library?

I am using the rpivotTable library but I can't find how to remove the grand totals from the result table. Has anyone had the same problem? I have searched the library documentation but it only shows how to remove the subtotals, but I can't find…
Pawel Alayon
  • 1
0
votes
0 answers

make a tabPanel x scrollable in Shiny

I am using rpivotTable inside a tabsetPanel in Shiny. tabPanel("Pivot Table", tags$head(tags$style(" div[data-tabsetid='7008'] { width:500px !important, height:500px !important, …
smackenzie
  • 2,880
  • 7
  • 46
  • 99
0
votes
0 answers

Is there a way to drill down from rpivotTable in Shiny

Is there a way to make an rPivotTable reactive so if you click on a value you can get to the underlying rows? tabPanel("Pivot Table", shinycssloaders::withSpinner( rpivotTableOutput("pivot_table") ) )
smackenzie
  • 2,880
  • 7
  • 46
  • 99
0
votes
0 answers

rPivotTable in Shiny showing black areas outside of pivot when scrolled

I an using rpivotTable in a Shiny app in UI it is inside a tabSetPanel: tabPanel("Pivot Table", shinycssloaders::withSpinner( rpivotTableOutput("pivot_table") ) ) in Server it is updated once the dataframe is…
smackenzie
  • 2,880
  • 7
  • 46
  • 99
0
votes
0 answers

R shiny: rpivottable, how to make a reactive table from it

I have a rpivottable but from that pivottable output table I want to make a table. And when I change the filters in the pivottable it should change the other table i.e reactive. I have a rpivottable but from that pivottable output table I want to…
Omer
  • 1
0
votes
1 answer

Pivoting with Multiple Variables?

I am trying to build a pivot table in the following way: Within variable "A", I am trying to look at "B", to look at the average of the Z values of C1, C2, C3, and C4. I have tried using the rpivottable, but the average(Z) is not the same for C1,…
codable
  • 19
  • 7
0
votes
1 answer

R: Getting incorrect result in added summarised column

R: How to plot rpivotTable or dcast table with summarised column in between same as excel for reporting. Check data set, tried different way to add summarised column in dcast and rpivottable but not getting it. Check below code where i getting…
Nirav Prajapati
  • 265
  • 2
  • 15
0
votes
1 answer

R: How to plot rpivotTable or dcast table with summarised column in between same as excel for reporting of continues data

R: How to plot rpivotTable or dcast table with summarised column in between same as excel for reporting of continues data. Check attached screenshot and data set, tried different way to add summarised column in dcast and rpivottable but not getting…
Nirav Prajapati
  • 265
  • 2
  • 15
0
votes
2 answers

How to convert rpivotTable result in to dataframe

How to convert rpivotTable result in to dataframe. I want to create new datafrmae with the result of rpivotTable, Is it possible do in R? Data Set Like User Order_Bin a PPL b CCD c CCD d OLP a OLP c …
Nirav Prajapati
  • 265
  • 2
  • 15
0
votes
1 answer

Export rpivottable output as image

I recently started using rPivotTable to produce some impressive charts and tables. I am using rPivotTable in a Shiny application. I was wondering if it is possible to export the output of the rPivotTable(Table, Bar chart, line chart etc) as image…
Suneel Kumar
  • 127
  • 1
  • 2
  • 8
0
votes
1 answer

rpivottable does not work with login module

Im trying to use the package rpivottable in my app but unfortunally it seems there is a bug. First a short introduction in the problem and my app: The app uses an login interface for authentification. If the user input was valid the ui changes from…
Andreas Ph
  • 51
  • 4
0
votes
1 answer

How to insert rpivotTable to Shiny UI dynamically

I need to generate dynamically user interface in my shiny App. This involves inserting rpivotTable to UI page under some conditions with insertUI. I found that I can successfully do it only ones. After removing the element and inserting it again it…
Sergiy Iurenko
  • 39
  • 4
0
votes
1 answer

plotting multiple charts in rPivotTable

I want to plot multiple columns in rPivotTable. Here is my dataset. data_plot = data.frame(month = c(1,2,3,1,2,3), SALES = c(47, 90, 23, 75, 19, 28), promotions = c(3,4,2,5,1,2)) rpivotTable(data_plot) see here for pivot Table 1 see here for…
Sriram Ananthakrishna
  • 43
  • 4
0
votes
1 answer

freeze the header of rpivotTable shiny

In shiny rpivotTable how can I freeze the header? I know how to add a scroll bar in css to the pivot table, however I don't know how to freeze the header. #PivotFinal { overflow-y: scroll; }
MLS
  • 108
  • 14
0
votes
1 answer

rpivottable shiny date descending order

How can I sort my rows which are in yyyy-mm-dd format to be descending in rpivottable output in Shiny r? I expect rows to be most recent to older dates. I know for example how to sort by month using the below code in the sorter part, but not in date…
MLS
  • 108
  • 14
1 2 3
4
5