Is Drop down possible under renderdatatable

Publishing Your Results
1

I have a simple application below. is it possible to create to dropdown for each column with column values

title: "Untitled"
runtime: shiny
output: 
  flexdashboard::flex_dashboard:
    orientation: columns
    vertical_layout: fill
---

```{r setup, include=FALSE}
library(flexdashboard)
```

Column {data-width=650}
-----------------------------------------------------------------------

### Chart A

```{r}
DT::dataTableOutput('a')
output$a <- DT::renderDataTable(
    iris)
2

What do you mean by dropdown ? A filter ?
Something like the column filtering in DT documentation ?
https://rstudio.github.io/DT/#column-filters

3

Hi,

Similar like this

image
image216×212 5.37 KB

4

That is exactly the column filtering on DT, so cderv already gave you the solution, just read the documentation.

5

I tried actually. But renderDT is not taking options as an arguments. Not sure why? Because by setting options we can enable dropdown

6

From the documentation given above, you'd set the filter outside of the options argument, so options is not even required:

DT::renderDataTable(iris, filter = 'top')
7

Ok, where is the reprex for that? how are we supposed to know what are you doing wrong if you don't show what you are doing?

8

Hi Sorry, the reprex was actually that I gave in the question. I tried with putting the option argument there. So did not work and therefore was not able to process reprex.

Apologies for this. Can you please provide few tips on how to produce reprex in this kind of instances. :slight_smile: Will be thankfull to you

9

Hi

Perfect. Actually I tried this earlier but my columns have few alpha-numeric values and only categorical values. So for that the dropdown is not working for those :frowning: . I was not sure so I was asking about options.

10

You have to narrow down the code to just the relevant part, in this case, it would be as simple as one line of code

# This doesn't work
DT::datatable(iris, options = list(filter = 'top'))

And the solution would be

# This works
DT::datatable(iris, filter = 'top')

image
image2355×1012 111 KB