Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak

Dashboard in Google Sheets for monitoring financial transactions

Key features of the dashboard:

Dashboard:
Technical specifications:
Data is automatically loaded from a tab in this file or can be pulled from external Google Sheets.
Real-time updates are provided through formulas and Google Apps Script.
Flexible adaptation to user needs through interactive filters.

Data for today: current date, update time, total transaction amount (in USDT).
Activity analysis: number and amount of transactions for the last 30 days, week, today, and yesterday.
Graphical visualization:
Histogram broken down by months, showing transaction dynamics over half a year of different years.
Pie charts: analysis of transaction amounts by payers and their share of the total volume.
Detailed data:
Table of the last 20 transactions indicating date, payer, quantity, and amount.
Statistics for the selected period: number of transactions, amounts, and list of payers.
Additional analysis:
List of payers with total number and volume of transactions.
Line chart to display daily transaction activity.

Design features:
Clear zoning of information for ease of analysis.
Contrasting design for quick perception of key indicators.
Interactive elements for data detailing.

This dashboard is an effective tool for monitoring and analyzing financial data, allowing for important insights in a convenient format.
Work details
Budget 84 USD
Added 7 December 2024
358 views
Freelancer
Nadiia G.
Ukraine Ivano-Frankovsk  19  0

A little busy A little busy
19 Safes completed
On the service 9 years