1

I am using the very interesting html widget rpivotTable. I know how to preselect variables that are added as rows or columns to the pivottable, but what I really need is a preselection of certain values of these variables.

As an example of what I mean I use the code from the vignette page:

library(rpivotTable)
data(HairEyeColor)
rpivotTable(
  data = HairEyeColor, rows = "Hair",cols = "Eye", vals = "Freq",
  aggregatorName = "Sum", rendererName = "Table",
  sorters = "function(attr) {
  var sortAs = $.pivotUtilities.sortAs;
  if (attr == \"Hair\"){
  return sortAs([\"Red\", \"Brown\", \"Blond\", \"Black\"]);}
  }", width = "100%", height = "400px"
)

If I want, e.g. to preselect the value "Red" of the "Hair" variable, is it possible to do that in this script? Something like:

library(rpivotTable)
data(HairEyeColor)
rpivotTable(
  data = HairEyeColor, rows = "Hair",cols = "Eye", vals = "Freq",
  aggregatorName = "Sum", rendererName = "Table", sorters = "
  function(attr) {
  var sortAs = $.pivotUtilities.sortAs;
  if (attr == \"Hair\") { return select([\"Red\"]); }
  }", width = "100%", height = "400px"
)

I know this doesn't work but is it the way to go?

nicolaskruchten
  • 26,384
  • 8
  • 83
  • 101
rdatasculptor
  • 8,112
  • 14
  • 56
  • 81

1 Answers1

1

Yes, if I understand correctly, this can be accomplished with inclusions and exclusions. The format is a little funky though and requires everything to be a list.

library(rpivotTable)
data(HairEyeColor)
rpivotTable(
  data = HairEyeColor,
  rows = "Hair",
  cols="Eye",
  vals = "Freq",
  aggregatorName = "Sum",
  rendererName = "Table",
  inclusions = list(
    "Hair" = list("Red")
  )
)
timelyportfolio
  • 6,479
  • 30
  • 33