This is something Tableau is really good at.
When you load in the data make sure that your ([Searched Date]) field is recognised as a date.
Then use Day([Searched Date]) on a column.
Then use sum([Searched Count]) on row, before right-clicking on this in the shelf and choosing Quick Table Calculation, then Difference (or Percentage difference). This will show how the more recent date compares to the first date.
You only have two dates in the data provided, but if you had multiple dates it would should the change between each date, so you will need to filter on the last two dates.
I suspect you would want t then show this by Destination or Client.
Please mark Answered if this works as expected.
20180917 Sales data.twbx 29.0 KB
Thank you for writing back. Sorry, I'm using Tableau 10.1 and can't open the file attached. My aim is to see whether there is any correlation between the searches & booking count.
Whether the client search increased or decreased for the same city pair.
Whether the bookings increased or decreased for the same city pair.
Sounds like you want to plot two measures against eachother, so you may want a scatter plot with the growth in searches vs. the growth in bookings. You won't be able to do this using this Difference Tableau calculation I mentioned,so will need to create calculated fields for the growth/difference, using something like this:
([Latest Date searches] - [Previous Date searches]) / [Previous Date searches]
I've been off 10.1 for a while and can't turn around a downgraded version right now.
Thanks Jonathan, let me cross check it.