manu-p-1 / meet

💳 Marqeta Hackathon Project - MEET - A structured and plan-based expense management platform for the modern age powered by Marqeta's modern card issuing API
MIT License
5 stars 2 forks source link

Considerations for Display of Statistical Data #9

Closed yimama007 closed 4 years ago

yimama007 commented 4 years ago

Here are a few considerations for the data to display and the type of format

From a "CEO" perspective: view of all departments

1. General data

Department Supervisor (?) Number of Employees Current Number of Plans Expired Plans Total Number of Plans Initial GPA Balance Additional Fund Added to GPA Total Fund Distributed Current GPA Balance
                   
                   
                   

2. Statistical Data: These can be added on to the table above/ or acts as its own table). I just added these on this part (not sure how long you all want the length of the table to be).

*Note: Do you all want to add a filter option for the dates for the user? (ex. selecting all the dates from January )

Department Supervisor (?) Number of Employees Total Number of Plans Average Weekly Distribution Average Monthly Distribution (Can be divided into 4 quarters if desire) Average Yearly Distribution Current GPA Balance
               
               
               

3. General Data of individual employees

Description: A simple display of all individual employees.

Employee ID Last Name First Name Department Plan (?) Initial  Account Balance Additional Fund Added Total Amount Spent Current Account Balance
                 
                 
                 

From a "Department Supervisor" perspective: view of all employees

1. General data of Individual Employees

*Note: Same table as table 3 from "CEO" Perspective.

2. General Data of Individual Employee

Employee ID Last Name, First Name Department

Last 4 Digits of Virtual Card (If there is one) Opening Balance: Closing Balance:

Plan Date Item/Transaction Current Account Balance
       
       
       

3. Statistical Data of Employees

Employee ID Last Name First Name Department Average Weekly Spending Average Monthly Spending Average Yearly Spending Current Account Balance
               
               
               

This is all considerations for now. In a way, these are the most basic and probably most used data.

NOTE: Besides providing a table, we can also allow the user to manually generate a table with their own desired data (A filter or sorting system)

manu-p-1 commented 4 years ago

@yijianma007 Will they all be in tabular form?

yimama007 commented 4 years ago

@manu-p-1 For now, I am working with tabular data since that will seem to be the part that will require the most thinking. There are too many different factors to be taken into. Also, do you think it is possible to add "filtered data"? For instance, if the user wants to see all the transactions that taken place between (October - November). Or will that be too much work?