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
2
votes
1 answer

Sorting in groups in rpivottable

I've got a rpivottable generated with this code thanks to rpivotTable package in R: library("rpivotTable") library("dplyr") library("reshape2") dane <- melt(HairEyeColor) rpivotTable(dane, rows = c("Hair", "Eye"), cols =…
Marta
  • 3,032
  • 3
  • 17
  • 34
2
votes
2 answers

rpivotTable: remove unnecessary aggregators

I create a interactive pivot table by using rpivotTable package. However, I found that some of aggregators and renderName are unnecessary for my users. I would like to remove them. For example, I want to remove "Average" from aggregator dropdown…
Joanna
  • 663
  • 7
  • 21
2
votes
2 answers

R Shiny CondtionalPanel not using CSS stylesheet

I'm using R Shiny to build a web application. I'm using conditionPanels to (sometimes) show a pivot table depending on the type of object df. As shown below, if the pivot table is shown within a conditionalpanel, the css is simply ignored and the…
Dendrobates
  • 3,294
  • 6
  • 37
  • 56
2
votes
1 answer

Addition of calculated field in rpivotTable

I want to create a calculated field to use with the rpivotTable package, similar to the functionality seen in excel. For instance, consider the following table: +--------------+--------+---------+-------------+-----------------+ | Manufacturer |…
Red Blanket Dweller
  • 21
  • 3
2
votes
0 answers

How to link data table and bar charts in R shiny

I'm trying to make a dashboard where my data have around 7-8 columns and 1500-2000 entries. There are two columns which are numeric on which I want to do summation. Rest of the columns I want to use for slicing the data(creating subset by adding…
Digvijay
  • 406
  • 3
  • 12
2
votes
1 answer

Changing the colors of rpivotTable in Shiny

I'm desperately trying to change the default colors of the rpivotTable package. I have also posted an issue in the github of the creator of the package, but no one has answered yet, so if someone has an idea how to fix this problem, I'd be more than…
Yordan Ivanov
  • 329
  • 1
  • 3
  • 14
2
votes
1 answer

rpivotTable not fitting in my Shiny Dashboard page

I am using rpivoTable package in my shiny dashboard. The problem is that my tables has close to 25 variables (columns) whereas I am only able to view 10 columns. Rest are out of view and there's no slider also to view them. Best,
Akshit
  • 349
  • 1
  • 3
  • 10
1
vote
0 answers

Rpivotable - Plotly chart renderers

I have created a pivot table in flexdashboard using a code similar to the following: rpivotTable(Titanic, rows = c("Survived"), cols = c("Sex"), width="100%", height="400px" ) I would like to have the capability to save the generated…
VR28
  • 184
  • 6
1
vote
1 answer

Make a radiobutton list for the stored rpivottable configuration name

The following is a link to a code that allows you to make several configuration savings, which you can load anytime as long as you don't clear your cookies. I would like to know if it's possible to make a radiobutton, that displays a list of all the…
Cleverito
  • 25
  • 4
1
vote
1 answer

Make several configuration saves/loadings of rpivottable on R

The following code I found on an other post (I could link if anybody is interested) adds the saving option on the R rpivottable using flexdashboard. The saving is done through cookies. I am trying to recreate it but having multiple saving options,…
Cleverito
  • 25
  • 4
1
vote
1 answer

shiny: Saving rpivotTableOutput as Excel

I could not figured out how to save the output of rpivottable in shiny. My minimum working example is below for reference. library(tidyverse) library(shiny) library(shinydashboard) ui <- dashboardPage( skin = "green", dashboardHeader( …
MYaseen208
  • 22,666
  • 37
  • 165
  • 309
1
vote
1 answer

Only Table in rpivotTable

I'm using the rpivotTable package in Shiny application and I'd like to have only the choice of 'Table' for the users (no charts) The RenderName argument is only used to choose the default display... output$pivot <- renderRpivotTable( …
Damien Dotta
  • 771
  • 3
  • 13
1
vote
1 answer

How to auto restrict the view in rpivottable to be data protection compliant

I am starting a customer lifetime project at work and want to share how the data looks with the business, as I want to be able to identify the important variables with them. I plan to do this using the excellent rpivottable package and launch a…
James Oliver
  • 547
  • 1
  • 4
  • 17
1
vote
1 answer

How to set a RpostgreSQL query as a dataframe object for RpivotTable?

I am trying to use RpostgreSQL to source data to be fed into the rpivotTable package and displayed to the user using shiny. Error: data should be a data.frame, data.table, or table Unfortunately I am new to R and I am unable to work out how to set…
Brr
  • 23
  • 4
1
vote
1 answer

RpivotTable Hiding or removing the Line Chart legend

TL;DR Question: Can I remove the Legend to be displayed when using the Line Chart option in the RpivotTable package in Rstudio/Shiny? Hi all, I am extremely new to Stack Overflow and also R, Rstudio and Shiny a real noob. I absolutely adore the…
Brr
  • 23
  • 4
1
2
3 4 5