Hi Alteryx experts,
Could someone please advise me on how to draw a time series trajectory with Alteryx or Power BI?
Assuming we have these dummy data/scenarios below, I would like to verify if the more visitors we have at the restaurant, the less rating the customer will leave on Google Maps.
Thank you in advance!
Rating | Visitor | |
2017/1/1 | 5 | 7698 |
2017/1/2 | 4 | 9076 |
2017/1/3 | 4.166667 | 8180 |
2017/1/4 | 4 | 6973 |
2017/1/5 | 4.333333 | 2011 |
2017/1/6 | 3.28911 | 3904 |
2017/1/7 | 4.333333 | 5465 |
2017/1/8 | 4 | 6990 |
2017/1/9 | 2.1918 | 6176 |
2017/1/10 | 5 | 3813 |
The ideal visualization would look like this.
Take a look at the Interactive Chart Tool. It's not going to give you as much flexibility with your visualizations as Power BI or Tableau, but if you need a native Alteryx solution it should get the job done.