Hello Puja Doona,
That is something we can do with Tableau, yes
Would you be able to share a workbook, .twbx, or some data to play with in order to illustrate this?
We can start with something simple like the following. And then we would have to play with calculations if you need that Increased Demand percentage in order to display it with a line chart ON your actual bar chart with the days compared to the numbers of clicks.
What do you think?
Date Clicks 27/11/2017 20 28/11/2017 15 29/11/2017 35 30/11/2017 50
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Hey - thanks for your reply. Sorry missed replying earlier. I've attached a simple data on the lines of what you provided. From what I've shared, some points:
1. assume normal days to be 7-dec to 9-dec
2. 10-dec to 13-dec - days with some promotion unknown until data is observed
3. from 14-dec data starts falling again
In a hypothetical situation, I'd like to create a view of "breakout" of clicks in last 3 days over rolling previous 3 days (or last week same 3 days as an example)
Then again the trend falls, so want to capture that as well from 14 dec with percentage values.
trend_breakout.twbx 19.7 KB
Hi Lénaïc - any tips?
Just out of curiosity - could you share the workbook. I've love to see how you did the calculation ...even though this is not what I was looking for, but just out of curiosity. Thanks
Hi - any guidance on this one?
Try setting up a control chart How to Make Control Charts in Tableau | Tableau Public
I think it will be suitable. Have a look and check if this is suitable for your requirement
For the rolling 3 months, create a calculated field WINDOW_avg(sum([Clicks]),0,2)
Hey Jyothisree, thanks for your reply. Just saw this today. Will go through.