I'm having issues when I knit my R markdown to HTML to have it include the data within the table. It keeps say's no data available in table, but when I do it in regular R, it spits out a table for me. I am using all libraries required- knitR and DT.
price_locked_table <- TEST_Pipeline_extract_NA %>%
filter(SyncedQuote== "Price locked" & ForecastPercent > 50) %>%
select(AccountName, ForecastCategory, ForecastPercent, CloseDate, OpportunityId, Name, TESTPrice, Renewal)
datatable(price_locked_table)
I know there is data in that variable as I've verified in my R script. Not sure why no data is populating in the table when I call to it in R markdown.
Thank you!