Medication Log Tracker Google Sheets with Graphs

Hello, looking to prepare a presentation for a client, as we’ve compiled as much data possible tracking what medications are being taken, how often, the precise amount, and is all logged each day with time stamps and fully detailed information. We are looking to see back from 2020 until now, why some medication usage has increased. We need visual data insights into what changed, frequency of usage per day, has there been a dosage increase, and so on. We have all the raw data, and need the pros to show us how to compile all the information, and create charts, trends, analysis ranging from average dose per medication per day from few month ago, vs same medication but dosage has increased significantly, and so on. We need visual insight data to see where things are changing and help our clients be aware of theor behavioral changes and come up with a plan to get them back on track. So another aspect would be if we suggested client to reduce intake, we’ll need a template that can use actual data based on historical usage, and give us a recommendation for the safest, and most effective way to Taper down usage. Graphs, Chart, super important for clients to see. Even being able to pull their google sheet and see oh wow, I’ve already taken X amount of XYZ too quickly and will likely run into issues unless they make some changes, which we hope to suggest based on the data. Shouldn’t really be a too difficult task, we’ve already considered using Sales Performance Templates and modifying them to suit our needs, but we are not programmers, and would prefer to leave it to the pros! Phase 1: Current Agenda -Raw Data Files available and ready to go. -Need insights on Activity -Need Visualizations that can easily show different months, time of day, day of week, and even have a side by side showing the difference between the current month and moth prior. -Say there was an increase in usage. Well, let’s see the Month over Month Increass in Visual so client can understand what they are doing, and see if there are spikes in certain time of the day perhaps, or day of the week. Which will all likely tie back to some psychological event that triggered the behavior, however that will be Phase 2. Phase 2: Analyzing Data & Sentiment (Future Goals) Analysis with AI to find key trigger points and exact moments of change. So it can be addressed accordingly.