Here I created this report by calucalting total trips,total miles using DAX Measures.
And I also got a chance to implement Drill Through Filter for the visual total trips by category.
Here I also implemented drill down filter for total trips by year,month and dates.
Insights:
1.Majority of the trips were for business purposes.
2.Fridays were the busiest days of the week for the rider.
3.December was the busiest month with 146 rides and September was the least busy month with 36 rides.
4.Other than rides for unknown purposes, the top 5 purposes for rides were meetings- 187, meals and entertainment- 160, errands/supplies- 128, customer visits- 101, and temporary site-50.