Visualizing download trends by day and time using Pivot Tables and slicers in Excel

[vk7]

Hi everyone,

I have a dataset sample like the one that I have attached but for different dates (i.e Dates are in this format, Refer Column F)

What I would like to do is the following,

1. Create a visualization (like a Pivot Chart or Table) showing which content (Tutorial Name) has been downloaded more times.
2. Also display how much time the downloads have taken (Duration or DurationInSeconds).
3. Add slicers to filter the visualization by a given date

I tried creating a Pivot Table, but I’m not sure how to best structure the data or slicers to achieve this. Could someone guide me on the right approach or suggest a better visualization method within Excel? Thanks in advance!

 

[vletm]

One rough sample after using those datas as those should be.
You could modify layout as You would like to have.