It depends how the data is set up. However, this should be easily accomplished in Tableau. If it search terms all in one field, a calculated field that separates them out will be the first step. Similar to:
if contains([search term field], "dog") then [Number of Records] end
Then, do a calculation similar to:
sum([Above Calculation])/sum([Number of Records])
Then, you can format the result to be a percentage.
Hope this helps!
That's awesome! I'll give it a go.
Thanks very much
so would the calculation need to go in the calculated field? (stupid question perphaps) but i just tried it and wouldn't validate.
So i just tried this using [visits] instead of [number of records] as that made more sense in terms of the data I got back - is that right?
So now my issue is that i'd like to do this for multiple search terms, but so far i've been returning the same % even though i've created a new calculated field for the keyword and a new calculation for that field.
So i'd like to compare 'dog' and 'cat' on the same chart essentially.
Any help would be greatly appreciated!