Hello everybody.
I need to create an app to record the music lessons and know how many I have left that I have already paid for.
I would like to create a dashboard view with the number of remaining lessons at the top (therefore influenced by the PURCHASES table and the LESSONS table) and below a graph with other data.
How should I go about creating the first part with the remaining lessons? what kind of view do you recommend?
Create a slice that shows only the unpaid/remaining lessons and a view for the slice which goes to the top of your dashboard.
Not sure what you want on the graph “with other data” below. The other data suggests the lessons already taken/paid.
If you need more specific guidance, we need to know how you have structured PURCHASES and LESSONS tables.
2 Likes
Thanks for your interest. I have 2 types of lessons:
- 30 minutes
- 45 minutes
I wanted to create a view with only the number of lessons left (written large and clearly visible, but I don’t know if it can be done), and then add some graphs to it
ES. 3 lessons 45 minutes - 4 lessons 30 minutes
- charts
My problem is not extracting the necessary data with expressions. But how to set up the view of the remaining lessons to get something like this
(imagine that instead of those numbers there are the remaining lesson numbers)
