I have a Stock Market data set in Excel having the EOD "End of Day" Stocks Data for various Symbols. There is one Row for Each Symbol for Every Trading Session. This data set has got multiple columns, out of that, there are three columns named -
for which I need to Calculate the "CHANGE" and "% CHANGE " Values in the form of NEW COLUMNS, so that I am able to use these newly calculated columns inside any visualizations in Tableau. The "CHANGE" is calculated as current days value - previous day value. The "% CHANGE " is also calculated in the similar manner by using the current day value and the previous days value of the respective stock.
So basically, we will get these 6 new additional columns added to the data set, named -
Can someone please tell how to best do this task, so that the new columns data become available for any other visualizations within Tableau. That is my main motive. If I cannot use these new columns data for other visualizations, then that will not solve my problem.
Thanks a lot.
Software Versions being used -
Tableau Desktop Professional 2018.2.3 64-bit
Windows 7 Ultimate 64-bit
Microsoft SQL Server Management Studio version -12.0.2000.8
Microsoft Office Professional Plus 2016 64-bit
I have attached the Packaged Workbook, which has the above mentioned excel data in it. I have not yet created any visualizations it it, because first the above mentioned six new columns data needs to be created somehow.