Hfrxdjt

Why did the IBM 650 use bi-quinary?

Is it true that "carbohydrates are of no use for the basal metabolic need"?

How do I stop a creek from eroding my steep embankment?

Is there a concise way to say "all of the X, one of each"?

Is there a "higher Segal conjecture"?

Should I call the interviewer directly, if HR aren't responding?

Using et al. for a last / senior author rather than for a first author

How can I make names more distinctive without making them longer?

Is there a Spanish version of "dot your i's and cross your t's" that includes the letter 'ñ'?

Is 1 ppb equal to 1 μg/kg?

Why one of virtual NICs called bond0?

3 doors, three guards, one stone

Why was the term "discrete" used in discrete logarithm?

Output the ŋarâþ crîþ alphabet song without using (m)any letters

Models of set theory where not every set can be linearly ordered

What are the motives behind Cersei's orders given to Bronn?

How to find all the available tools in macOS terminal?

Check which numbers satisfy the condition [A*B*C = A! + B! + C!]

How to recreate this effect in Photoshop?

Are my PIs rude or am I just being too sensitive?

How can I fade player when goes inside or outside of the area?

How do I mention the quality of my school without bragging

Sorting numerically

What causes the vertical darker bands in my photo?

generate a report in R where the value in each Column is to be derived from different tables in sybase databasea

0

$begingroup$

I work in a stress testing team. my boss has asked me to generate an interactive report every day using different tables in a Sybase database. I know the table structure and sql queries, but can't get my head around implementing in Rstudio using shiny or markdown.

Please advise.
thanks,

r data

share|improve this question

asked Oct 12 '18 at 18:10

muditmudit

1

$endgroup$

bumped to the homepage by Community♦ 1 hour ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

$begingroup$

I work in a stress testing team. my boss has asked me to generate an interactive report every day using different tables in a Sybase database. I know the table structure and sql queries, but can't get my head around implementing in Rstudio using shiny or markdown.

Please advise.
thanks,

r data

share|improve this question

asked Oct 12 '18 at 18:10

muditmudit

1

$endgroup$

bumped to the homepage by Community♦ 1 hour ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

$begingroup$

I work in a stress testing team. my boss has asked me to generate an interactive report every day using different tables in a Sybase database. I know the table structure and sql queries, but can't get my head around implementing in Rstudio using shiny or markdown.

Please advise.
thanks,

r data

share|improve this question

asked Oct 12 '18 at 18:10

muditmudit

1

$endgroup$

share|improve this question

asked Oct 12 '18 at 18:10

muditmudit

1

share|improve this question

asked Oct 12 '18 at 18:10

muditmudit

1

asked Oct 12 '18 at 18:10

muditmudit

1

asked Oct 12 '18 at 18:10

muditmudit

1

1 Answer
1

active

oldest

votes

0

$begingroup$

Here is a good overview of recommended ways:

http://r4ds.had.co.nz/r-markdown-formats.html#r-markdown-formats

I suggest using the package flexdashboard (heading "Dashboards"). Interactivity can be provided by htmlwidgets you can find an overview here:

http://www.htmlwidgets.org/

As an example, install:

install.packages('flexdashboards') # the dashboard
install.packages('plotly') # for interactive graphs
install.packages('DT') # for interactive tables
install.packages('tidyverse') # for data transformation etc

now create a dashboard as explained on

https://rmarkdown.rstudio.com/flexdashboard/

and fill it with your graph or tables. Here I use the starwars dataset provided in the package dplyr

---
title: "Single Column (Fill)"
output: 
 flexdashboard::flex_dashboard:
 vertical_layout: fill
---

### Chart 1

```r
library(tidyverse)
library(DT)
datatable(starwars %>% select(-films, -vehicles, -starships))
```

### Chart 2

```r
g <- starwars %>% 
 ggplot(aes(height, mass, color = gender)) +
 geom_point() +
 ggtitle("Mass vs. Height by gender")

library(plotly)
ggplotly(g)
```

output will be a html(interactive) file with table and graph:

share|improve this answer

answered Oct 16 '18 at 15:58

StephanStephan

11114

$endgroup$

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "557"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f39599%2fgenerate-a-report-in-r-where-the-value-in-each-column-is-to-be-derived-from-diff%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

$begingroup$

Here is a good overview of recommended ways:

http://r4ds.had.co.nz/r-markdown-formats.html#r-markdown-formats

I suggest using the package flexdashboard (heading "Dashboards"). Interactivity can be provided by htmlwidgets you can find an overview here:

http://www.htmlwidgets.org/

As an example, install:

install.packages('flexdashboards') # the dashboard
install.packages('plotly') # for interactive graphs
install.packages('DT') # for interactive tables
install.packages('tidyverse') # for data transformation etc

now create a dashboard as explained on

https://rmarkdown.rstudio.com/flexdashboard/

and fill it with your graph or tables. Here I use the starwars dataset provided in the package dplyr

---
title: "Single Column (Fill)"
output: 
 flexdashboard::flex_dashboard:
 vertical_layout: fill
---

### Chart 1

```r
library(tidyverse)
library(DT)
datatable(starwars %>% select(-films, -vehicles, -starships))
```

### Chart 2

```r
g <- starwars %>% 
 ggplot(aes(height, mass, color = gender)) +
 geom_point() +
 ggtitle("Mass vs. Height by gender")

library(plotly)
ggplotly(g)
```

output will be a html(interactive) file with table and graph:

share|improve this answer

answered Oct 16 '18 at 15:58

StephanStephan

11114

$endgroup$

add a comment | 

0

$begingroup$

Here is a good overview of recommended ways:

http://r4ds.had.co.nz/r-markdown-formats.html#r-markdown-formats

I suggest using the package flexdashboard (heading "Dashboards"). Interactivity can be provided by htmlwidgets you can find an overview here:

http://www.htmlwidgets.org/

As an example, install:

install.packages('flexdashboards') # the dashboard
install.packages('plotly') # for interactive graphs
install.packages('DT') # for interactive tables
install.packages('tidyverse') # for data transformation etc

now create a dashboard as explained on

https://rmarkdown.rstudio.com/flexdashboard/

and fill it with your graph or tables. Here I use the starwars dataset provided in the package dplyr

---
title: "Single Column (Fill)"
output: 
 flexdashboard::flex_dashboard:
 vertical_layout: fill
---

### Chart 1

```r
library(tidyverse)
library(DT)
datatable(starwars %>% select(-films, -vehicles, -starships))
```

### Chart 2

```r
g <- starwars %>% 
 ggplot(aes(height, mass, color = gender)) +
 geom_point() +
 ggtitle("Mass vs. Height by gender")

library(plotly)
ggplotly(g)
```

output will be a html(interactive) file with table and graph:

share|improve this answer

answered Oct 16 '18 at 15:58

StephanStephan

11114

$endgroup$

add a comment | 

$begingroup$

Here is a good overview of recommended ways:

http://r4ds.had.co.nz/r-markdown-formats.html#r-markdown-formats

I suggest using the package flexdashboard (heading "Dashboards"). Interactivity can be provided by htmlwidgets you can find an overview here:

http://www.htmlwidgets.org/

As an example, install:

install.packages('flexdashboards') # the dashboard
install.packages('plotly') # for interactive graphs
install.packages('DT') # for interactive tables
install.packages('tidyverse') # for data transformation etc

now create a dashboard as explained on

https://rmarkdown.rstudio.com/flexdashboard/

and fill it with your graph or tables. Here I use the starwars dataset provided in the package dplyr

---
title: "Single Column (Fill)"
output: 
 flexdashboard::flex_dashboard:
 vertical_layout: fill
---

### Chart 1

```r
library(tidyverse)
library(DT)
datatable(starwars %>% select(-films, -vehicles, -starships))
```

### Chart 2

```r
g <- starwars %>% 
 ggplot(aes(height, mass, color = gender)) +
 geom_point() +
 ggtitle("Mass vs. Height by gender")

library(plotly)
ggplotly(g)
```

output will be a html(interactive) file with table and graph:

share|improve this answer

answered Oct 16 '18 at 15:58

StephanStephan

11114

$endgroup$

install.packages('flexdashboards') # the dashboard
install.packages('plotly') # for interactive graphs
install.packages('DT') # for interactive tables
install.packages('tidyverse') # for data transformation etc

---
title: "Single Column (Fill)"
output: 
 flexdashboard::flex_dashboard:
 vertical_layout: fill
---

### Chart 1

```r
library(tidyverse)
library(DT)
datatable(starwars %>% select(-films, -vehicles, -starships))
```

### Chart 2

```r
g <- starwars %>% 
 ggplot(aes(height, mass, color = gender)) +
 geom_point() +
 ggtitle("Mass vs. Height by gender")

library(plotly)
ggplotly(g)
```

share|improve this answer

answered Oct 16 '18 at 15:58

StephanStephan

11114

answered Oct 16 '18 at 15:58

StephanStephan

11114

answered Oct 16 '18 at 15:58

StephanStephan

11114