Interactive Dashboards in R | Data Visualization with Popular Plots, Data Tables & Pivot Charts

[@alphar85]

What the heck. Never thought you could create a dashboard in R. What a legend.

[@bkrai]

Thanks for comments!

[@flamboyantperson5936]

This tutorial is awesome. You are the first person to make it. I have been eagerly waiting for your new video and here comes the unique tutorial. Thank you so much Sir, you are great.

[@bkrai]

Thanks for your comments!

[@flamboyantperson5936]

Sir can you send me data set?

[@bkrai]

I've added link below the video.

[@AyanMajumdar]

where is the link?

[@bkrai]

It's below the video in description area. I'm copying it below too: Data File: drive.google.com/open?id=1tHAdr3V1N8BzZShg0A5ZU6eAUN_9kZZf R Markdown File: drive.google.com/open?id=1S5JE63vij2Mqptl8caCO3ILAFyids8Sj

[@mahendrank4909]

Dr Rai, of all the R Shiny tutorials available in the KZbin, this is the best and the most innovative one.Thanks for the amazing work!!

[@bkrai]

You are welcome!

[@bowieoscar2984]

Instablaster.

[@pcsksa5]

Thank you. Really well paced and detailed. I paused-started your video, following your steps using my data. This way I was able to understand a good deal of what this is about

[@bkrai]

Great to hear!

[@immaculatesahai]

Fantastic and lucid explanation @Dr. Bharatendra Rai

[@bkrai]

Glad you liked it!

[@bhavikdudhrejiya4447]

Thank You, Sir, for this great video. With the help of this tutorial, I have created a coronavirus analysis dashboard.

[@bkrai]

Excellent!

[@birasafabrice]

this is an interesting tutorial, I immediately subscribed to your channel. Hope to getting more videos on R programming. thanks!

[@bkrai]

Thanks for the sub! You may find this recent series useful: kzbin.info/www/bejne/qWOWdIB_n8uqfs0

[@bouseuxlatache4140]

This is an extremely impressive project. Bravo

[@bkrai]

Thanks!

[@markmcc74]

Thank you so much for this clear and succinct tutorial, simplified so many concepts I was struggling with as I learn.

[@bkrai]

You're very welcome!

[@eduardolima5052]

Excellent video about dashboards, thank you very much!!

[@bkrai]

You are welcome!

[@paulturner8584]

Very clear, concise and informative tutorial. Flex dashboard seems less restrictive than Shiny dashboard when publishing - particularly for restricted content - and I'm going to rebuild some apps to test. This has been very helpful, thank you.

[@bkrai]

Thanks for your comments!

[@adarsha1981]

Excellent Bharatendra... very useful video...

[@bkrai]

thanks!

[@PicaPauDiablo1]

Your content is always AWESOME. Thank you Dr Rai

[@bkrai]

You are very welcome!

[@mohsinramay]

Great video. Very informative and easy to follow. Thanks Dr. Rai.

[@bkrai]

Glad it was helpful!

[@erice.8683]

Thank you so much for the video, it provided the help that I needed to make a dashboard! Much appreciated!

[@bkrai]

You're welcome!

[@damiigonzo]

GENIUS!!!!!! Thanks you help me a lot with my coding applied to finances class!!!!! And also I’ve learned a lot more for much other things. Thanks!!!! This videos are gold

[@bkrai]

Great to hear!

[@ravindarmadishetty736]

Dear Sir, this video given better understanding in making Dashboards

[@bkrai]

Thanks for comments!

[@josevalencia9233]

Very insigthful thank you. Dr. Bharatendra

[@bkrai]

Thanks for comments!

[@cwlindWX]

Thank you, extremely helpful for an "R" newbie.

[@bkrai]

You're very welcome!

[@hirenkakkad3747]

Awesome video sir. Really valuable. waiting for more videos from you.

[@bkrai]

Thanks for comments!

[@jdpinod]

Amazing explanation, clear, complete and brief. Thank you for share it!

[@bkrai]

Thanks for comments!

[@fowobajek]

Excellent tutorial Mr Rai. I must confess I have learnt a lot from you in my Data Science journey.

[@bkrai]

Thanks for your comments!

[@andresadam]

What's the R version you were using in this video. Have some syntax incompatibilities with the newest one.

[@bkrai]

This video is from April 2018, so it is slightly older version of R.

[@josefaccin]

Thank you for amazing tutorial!! Brazil

[@bkrai]

You are very welcome!

[@ranjitnambisan8023]

Respected sir, Your videos are very easy to understand. Thanks for making such videos. Sir, we would like to see some tutorial on Chatbot using R, Stockprice prediction using LSTM, how to integrate a R model/chatbot to a website.

[@bkrai]

Thanks, I've added your suggestion to my list.

[@supetgis2me]

Thank you so much, for the best presentation.

[@bkrai]

You're very welcome!

[@kinyapop]

This is awesome! You are a genius!

[@bkrai]

Thank you! 😊

[@carlosarturocaceresojeda6887]

Thank you. Amazing tutorial!

[@bkrai]

You are welcome!

[@VivCadence]

simply outstanding..Thanks a lot. Sir plesase let me know if you conduct online class on same. let me know how to join classes

[@bkrai]

Always welcome! I'll be teaching a online class at Harvard and another at UMass Dartmouth in Spring 2022.

[@diegotorresflores3089]

Amazing work, thanks a lot for sharing with us.

[@bkrai]

You're welcome!

[@rajlatte9131]

Thank you for making this, its very informative and a great learning..!!

[@bkrai]

Glad it was helpful!

[@pedrorubiomartinez7055]

Thank you for the amazing video Dr, Rai, excellent for every level. I'm having issues reproducing your dashboard when knit to fleshdashboard appears error validateCssUnit(sizeInfo$width) ... related to labor cost section gauge function. Any advised? Many thanks!

[@bkrai]

If this is for any specific plot, I would suggest replace it with another.

[@alanharbinson9004]

This is superb, thank you for posting this

[@bkrai]

Thanks for comments!

[@mariamartin6205]

Thanks, really helpful!

[@bkrai]

You're welcome!

[@BuonMercatoTest]

Excellent video. Thank you

[@bkrai]

You are welcome!

[@actuariosonline1647]

Dear Dr Rai, It is possible to change the color of the frames in the pivottable. For example I want to reflect the color green when the values ​​are positive and red when the values ​​are negative!???

[@nkd3047]

man super helpful. thanks!

[@bkrai]

You are welcome!

[@WaiguruMuriuki]

Thank you for this. Best so far

[@bkrai]

Thanks for comments!

[@igwegbehenrychinaza7908]

Thank you very much. I cann't wait to replicate this codes. My goodness!!!

[@bkrai]

You’re welcome! Let me know if you have any questions.

[@ruddyeco5494]

Superrr.....Muchas gracias amigo

[@bkrai]

Thanks for comments!

[@arifsultan]

Thank you very much for your great effort! I have one small question. If I want the output to be published to multiple users, is that possible and how? Secondly can I save the the output in the PDF format?

[@bkrai]

Once you save the output on your computer, you can email to any number of people. It may be easier to put it in google drive or any similar space and then share link. Interactive plots cannot be saved as pdf.

[@arifsultan]

@@bkrai thank you! So, can I publish the results as a web page?

[@yousingcountry6693]

Awesome tutorial! Please keep up the good work!

[@bkrai]

Thanks for your comments!

[@prabaldutta]

Hello. I have loaded the DT library but when I use datatable(data then datatable is not getting blue like yours in the video

[@bkrai]

In my video too the datatable is not blue.

[@lilytucker2464]

Excellent tutorial Dr. Rai, thank you - I have a question, though - I am running R 3.6.0 but the highcharter doesn't work, is there any help you can offer? Please and thanks!

[@bkrai]

I would suggest try again. It should work fine.

[@sunilthomas7342]

Excellent!

[@bkrai]

Thanks!

[@melodicguitarist]

Awesome Sir...this is something extraordinary. Very useful. Is there any Book which one can study all these in details or R documentation is best..

[@bkrai]

Thanks for comments! You should be able to find books about dashboards on amazon. But for dashboards using R, probably R documentation is a good resource.

[@craftingwithraghav8073]

Hi Bharatendra, this is really great video. I have created my first dashboard in R using this. Just want to understand if in data tables and Pivot tables we can have labels as well. I have imported data from SPSS having labels and I want data table output and pivot table output with labels and not values. Please help me with this.

[@craftingwithraghav8073]

Please review my link as well: rpubs.com/aastha123/FirstDashboard

[@bkrai]

Yes, labels are fine.

[@bkrai]

It looks good!

[@craftingwithraghav8073]

@@bkrai I just want to ask how to add labels as in my dashboard only values are coming. I need labels, plz help me

[@craftingwithraghav8073]

@@bkrai Hi, plz help me in this I am facing big problem as not having labelled data from dashboard but need to share with management with labels. I have uploaded SPSS but its taking only values and not labels. Plz help

[@StoicRichie]

Is the dashboard dynamic ,I mean to say will change dynamically with data

[@bkrai]

Yes

[@InfinitesimallyInfinite]

Just brilliant sir!

[@bkrai]

Thanks for comments!

[@My_Super]

Dr. Rai, In Knit I have HTML, PDF, WORD but no other option to see everything in one page. Do I need to set up something?

[@bkrai]

Since in this examples many pages are used by design, it will not be possible to see everything on one page.

[@karan-aulakh96]

Dr Rai, Thanks for this amazing tutorial. However, I am not able to render the Plotly plots(it shows all blank) either following your code line by line and even by using the script you shared. Can you help here ? Thanks,

[@bkrai]

Try restating R and running codes again.

[@IrinaMax]

Thank you for amazing tutorial, keep learning from you! You make it so easy to absorbing fast :)

[@bkrai]

Thanks for your comments and feedback!

[@sureshvinayaka2963]

Sir, thank you for the amazing video. I have couple of quick question on first page... 1. I am unable to sum using valueBox function for my data and getting zero as result. 2. colors are not appearing on gaugesectors, plz assist.

[@bkrai]

It will be easier to look at the code and suggest corrections.

[@payalatre8491]

Hello sir ! In my template flexdashboard option is not available what should I do? Plz help me

[@bkrai]

You need to install flexdashboard first and then run library(flexdashboard)

[@AlokPratapSingh4001]

Best 😍

[@bkrai]

Thanks!

[@divyaroopsingh334]

When i run the flexdashboard command, i get an error saying "State" is not identified.

[@bkrai]

You can review variable names and make sure there are no errors while using the name.

[@rajlatte9131]

Hello Sir, Greetings, Is there any video which explains Shiny app ? I searched your page but couldn’t find. Kindly suggest if there is any link..!!

[@bkrai]

Not yet.

[@rajlatte9131]

Dr. Bharatendra Rai thank you for the response sir..!! Great day

[@bkrai]

Welcome!

[@moussakeitamoussakeita8519]

Thank you for all . Just I have some probleme when runing the code: it print this error: argument is not numeric or logical: returning NA. I converted factor to numeric it work in consol but error still persist when i run rmd file. Please need help.

[@bkrai]

You need to covert factor to numeric in rmd file too.

[@moussakeitamoussakeita8519]

@@bkrai i tried this: ```{r} data$lc

[@moussakeitamoussakeita8519]

It's ok now, i saw my mistake thanks.

[@bkrai]

Thanks for the update!

[@divyaroopsingh334]

when assigning values in plot_ly for axis, we use x = ~fm .What does ~ do here

[@bkrai]

That's how plotly want us to specify a variable for x or y axis.

[@mutindafestus5619]

wah is is good,how can i add data filters button where one can toggle for example my data has variable years can i add a button so i can see the car failures by years on the value boxes

[@bkrai]

You can choose 'year' variable in the pivot table part or use the radio button in the interactive data table.

[@divijbahl1194]

Hello sir, I ranyour code but it shows this error "object of type closure is not subsettable"

[@lavanyap4160]

Thank you for the detailed video. In first page interactive plots, all three states are printed inside single box.Pls help.

[@bkrai]

Try to have separate chunks.

[@sankarsubramaniam9077]

Thank you so much, Sir. While I am able to create a dashboard with my specifications, the dashboard look itself is raw, with source codes also appearing on the dashboard (even in Browser view as well). Any viable way I can overcome this? I am on R 3.5.1 - Thank you.

[@bkrai]

That has nothing to do with what version of R you use. You can refer to the code that I used.

[@sankarsubramaniam9077]

@@bkrai Thank you so much, Sir. Much appreciated - the code works absolutely fine. The dashboard looks good, thanks to you :)

[@geetanjalipurohit1371]

This is an incredible video sir, is it possible for us to take a file upload input to upload any particular file, i have tried every syntax but not able to do it, please help me out

[@bkrai]

If you are referring to data file, it's better to use csv format

[@juandavidlozadacalderon1356]

Thanks Doc,

[@bkrai]

You are welcome!

[@yellankinaveen2496]

processing file: ca-2.rmd Error in parse_block(g[-1], g[1], params.src, markdown_mode) : Duplicate chunk label 'setup', which has been used for the chunk: library(flexdashboard) library(knitr) library(DT) library(rpivotTable) library(ggplot2) library(plotly) library(dplyr) library(openintro) library(highcharter) library(ggvis) Calls: ... process_file -> split_file -> lapply -> FUN -> parse_block Execution halted what is the sloution

[@netmarketer77]

What is the source of this dataset to expand the features if possible ?

[@bkrai]

The link to dataset is in description area below video.

[@rashashawky365]

Many thanks for the wonderful tutorial, when I tried to run the first chunk, I got the following message "Error in library(flexdashboard) : there is no package called ‘flexdashboard’", any help?

[@bkrai]

Make sure to install package before running library.

[@helena4503]

Such a great tutorial! Thank you so much, sir. By the way, can I add e-mail to the social list? I mean, not only I can share it via Facebook, Twitter, but also send the file or link to an e-mail address. Thank you in advance!

[@bkrai]

You can save it as html file and probably upload on google drive and then share the link.

[@mahendrank4909]

@@bkrai Sir, In that case will the html file be still interactive?

[@ashishashuyou]

Is there a way to publish/share such dashboards with users to view it securely/non-publicly for confidential data?

[@bkrai]

You can save it on google drive and share the link.

[@ashishashuyou]

@@bkrai Thanks... Is it possible to open it directly without having R installed on system?

[@bkrai]

Yes, once you have created a html dashboard, it will open in a browser without need for R.

[@arifsultan]

My plots are not getting displayed...I don't get any errors, but nothing is getting displayed either

[@bkrai]

Probably give more time. If data set is big, it may take more time.

[@arifsultan]

@@bkrai thanks for your reply. It doesn't get displayed ever after I give it time. However, surprisingly, when I open the HTML file everything gets displayed there. Maybe there's someone issue with the settings.

[@sandiptripathy4222]

Hello Sir, I am trying to make a Sales Forecast Dashboard using R-Shiny. Can you please provide any source from where I can get the basic skeleton of the code

[@bkrai]

Thanks, I've added shiny to my list of future videos.

[@agitauditor]

when I am using the exact query on my system, I am getting the results from the data set however I am not getting the icon colour and icons Pls help

[@bkrai]

Difficult to suggest anything without looking at code.

[@mangomilkshakelol]

hmmm. how come I don't have the flex dashboard template

[@bkrai]

You can first install it before using steps shown in the video.

[@andychang2739]

I tried to knit to flexdashboard, but keep getting the following error message: "Error in yaml::yaml.load(..., eval.expr = TRUE) : unused argument (eval.expr = TRUE) Calls: ... parse_yaml_front_matter -> yaml_load -> Execution halted" Does anyone know what might be going on? Thanks.

[@bkrai]

Try to run that specific that's casing error before running entire code.

[@deepansharora7942]

Hello! Could you please make a video on R-shiny? Thanks

[@bkrai]

Thanks for the suggestion, I've added it to my list.

[@parasrai145]

Interesting 👍

[@bkrai]

Thx

[@dnyw0802]

thank you great lesson

[@bkrai]

Thanks for comments!

[@m.charles]

Great tutorial, very helpful and awesome. Only problem for me is that when I run the map chunk i get this error "Error in eval(expr, envir, enclos) : object 'usgeojson' not found" kindly help out.

[@bkrai]

Make sure you have run all the libraries from line 12 to 20.

[@mauricio1780]

fantastic

[@bkrai]

Thank you! Cheers!

[@lisapet160]

Nice!

[@bkrai]

Thanks!

[@taufikwanahmad3246]

great. but i face problem p1% group_by(make)%>% summarise(count=n())%>% plot_ly(x=~make, y=~count, color=rainbow(51), type = 'bar')%>% layout(xaxis=list(title="sada"),yaxis=list(title='Count')) Error: n() should only be called in a data context how can i solve this

[@bkrai]

I do not see any error in code.

[@AsyraffLatiffi]

Hi, How can i use a different map other than US?

[@bkrai]

I'll add it to my list of future videos.

[@Okwach_Kich]

Running the same script from the download link and still bumping into an error something about validateCssUnit(sizeInfo$width). Great work though

[@bkrai]

Difficult to say much without looking at code.

[@kaustubhkulkarni9390]

Dear Dr.Rai, Can you please share sample excel sheet used for building this R Dashboard which will be helpful to understand further

[@bkrai]

Link is available below video.

[@saulofender10]

Thank you!!!

[@bkrai]

You're welcome!

[@davidjackson7675]

How do I read in a existing data.frame? If I do this A

[@bkrai]

You should read your data directly into 'data'.

[@ishansgyan8665]

sir please make a video on creating interactive slicers and filters also

[@bkrai]

Thanks, I've added this to my list.

[@moussakeitamoussakeita8519]

hi it's me again i'm trying to plot the map showing the case of each country i have in my dataset, the map is displayed without the cases. I don't know if I made a mistake in the code. I'm new in R , Need help. ```{r} pays % group_by(country_name) %>% summarize(Cases) highchart() %>% hc_title(text = "Cases of COVID-19") %>% hc_subtitle(text = "Source: covid-19.csv") %>% hc_add_series_map(worldgeojson, pays, name = "country_name", value = "Cases", joinBy = c("woename", "country_name")) %>% hc_mapNavigation(enabled = T) ```

[@bkrai]

I would suggest look at str(dataset) and see if country names are as expected.

[@moussakeitamoussakeita8519]

@@bkrai In joinBy , i replaced "woename" only by "name" and it worked. Thanks!

[@ShobhitSrivastava]

Here is a treat.. Thanks. I don't understand why my Rstudio is treating (```) these three symbols as errors and says unexpected token and even after deleting it doesn't understand r setup. Any help sir!

[@bkrai]

Make sure to include all necessary code. For example, after ``` we need {r} too.

[@ShobhitSrivastava]

Thanks sir.

[@OnePanAdventures]

Awesome!!!!

[@bkrai]

Thanks!

[@anantkulkarni367]

Sir I am getting an error,pls any1 guide me to solve the issue Installing package into 'C:/Users/DELL/Documents/R/win-library/3.5' (as 'lib' is unspecified) Quitting from lines 12-40 (Dashboard--2-.Rmd) Error in contrib.url(repos, "source") : trying to use CRAN without setting a mirror Calls: ... withVisible -> eval -> eval -> install.packages -> contrib.url Execution halted

[@bkrai]

Have you installed R and RStudio?

[@anantkulkarni367]

@@bkrai yes sir I am in running in rstudio,my other shiny projects are working here I am getting that error,pls guide sir

[@chandrarekhajewar811]

i don't get the default template how to select or include these template options

[@bkrai]

You should install the libraries beforehand.

[@chandrarekhajewar811]

Bharatendra Rai okay i will try

[@yeshuaeselmashiaj6037]

woooow.

[@bkrai]

Thanks! :)

[@narendrapatidar7363]

this tutorial is very helpful for me. i have one doubt how i load my csv files in this code because i couldn't understand . how to write path in this code

[@bkrai]

You can find location of file on your computer using right click.

[@vipinmurukesh337]

setwd("file path") is a way to set file path before read.csv

[@manishkatiyar2403]

Sir..from where I can learn Markdown?

[@bkrai]

For Markdown you can use: kzbin.info/www/bejne/j4m2oWmMm7-Ui80 For Notebook, you can use: kzbin.info/www/bejne/anzJmoSIptOSrKM

[@ukpraveen]

Awesome tutorial Rai, Please could you send me the data you have used in this

[@bkrai]

Data file should be available from the link in description area below this video.

[@tafadzwazhakata4579]

Hie..I need assistance. Was following your tutorial..How do i add another page that upload csv files. I have this code that i want to put on another page using your demo. This is the code. It has both the UI and the server shinyServer(function(input, output) { #This function is repsonsible for loading in the selected file filedata

[@animeshkumar1684]

Thx!!!

[@bkrai]

Welcome!

[@ravindarmadishetty736]

Sir, can you make a video on Smote

[@bkrai]

Thanks for the suggestion, I've added it to my list.