Duration Displayed on Card
Hello, I am working with Google Analytics data and attempting to display a card with the Average Session Duration. I have created a custom column to display this data on my table in Power Query with the following formula: = Table.AddColumn(#"Changed Type", "Average Session Duration", each [Session Duration] / [Sessions]) I know from viewing GA that the outcome I'm looking for is 0:01:17. From working with the data in Excel, I know that I can get the right answer with the following equation: Sum(Session Duration) / Sum(Sessions). When I go to display this value on a card, it shows as a decimal. I changed the Data Type to "Time" to get to the format but I can only Summarize the data with "Count" or "Don't Summarize", neither of which give me the average that I'm looking for. My calculation may be wrong but I can't tell based on the output that I'm getting. Any thoughts on how to get to the right number and display?
