I've trying to convert the Google Analytics API data into minutes and seconds and getting quite stuck.
So at the moment I have visit duration as one measure and visits as another. I created a calculated field which divides the sum of visit duration by 60 (seconds essentially) to give a minute and then divided that by the sum of visits.
It doesn't look wildly wrong but I know it is, then when I try and change the format to mm:ss it turns them in to time of day which I don't want!
Any help greatly appreciated
Can you post a packaged workbook (.twbx) file? Its difficult to tell what the problem is without seeing the data/workbook. Cheers!