If you want to create an Excel chart that contains clustered columns and stacked columns altogether, this post is for you.
Here is a quick and easy way to perform multiple left joins in R with multiple data frames.
In the last days, I was running into a problem that even all Excel files are closed bunch of EXCEL.EXE processes still running.…
Here is how to schedule a batch file in Windows Task Scheduler.
For me, it worked like this, but there is also modification needed in the actual batch file.
system("cmd.exe", input = paste('C:\\This\\Is\\Path\\Your.bat'))
In the batch file, I…
Sometimes it’s necessary to convert accented characters to non accented in R or Power BI for text analysis purposes. Accented characters might be…
Even there is no straight forward option to build Power BI line chart marker color conditional formatting, you can do that, by using…