I want to know which stocks volume is more than 2,3,4(by parameter, valid:2,3,4) times than the average 50 day volume.
I expect 3 params in this case:
(1) volume how much more than the avg volume
(2) avg volume of last 50, or 20 days
(3) analysis to be done on the latest day or say 5 days back the latest date.(so this param can be: exclude from latest: 0,20)
avg_volume for window calc for 50 days can be given by window_avg(trad_volume, -49, 0)
The expected output has to be in cross tab,
stock name, trade_volume, 50/20 day mov avg, how many times more is trade volume.
I feel i am quite ok in tableau, I just dont have time to implement this. I expect the output in cross tab
This is an ongoing work, so this workbook already many calculated fields, parameters etc....i can spend upto 3000 INR for this work.
Though the description contains a lot of information but only after looking at the database, data source and the worksheet I will be able to sail through and commit.
hi this is sharan, i just looks at your post and i really like to work and i have 2 year of experience in tableau please provide this project to me and i will give you the best results and i will provide best dashboard.
thank you