SQLite Database for bar chart (graph)

I'm working in Android Studio in Java and I need someone to make statistical bar charts from data that will be collected in the app. The app is designed in a way where people can add new items (in recyclerview). Each item will have its own group of data ((X)Time, Y(default)) so each item needs its own bar chart (daily, weekly, monthly and yearly). Each bar chart has to have an option to look at previous days, weeks, months and years (see pictures below)

For every click, Sqlite and bar chart(graph) need to be updated.

-daily(each bar represents one hour)
-weekly(each bar represents one day (for 7 days))
-montly(each bar represents one day (for 28-31days))
-yearly(each bar represents one month)