ssibrahimbas / deno-sheet-kpi Goto Github PK
View Code? Open in Web Editor NEWLicense: MIT License
License: MIT License
A drawing describing the structure of the project and how it works can be added to Readme
If a request comes in while the cache is loading, a request is made that asks for the request to be refreshed a few seconds later.
A readme should be prepared explaining the purpose of the project, its setup and how it works.
add mongodb to project for cache and queries
the main structure of the project should be developed
rough code has been written so far. This code should be made review-friendly :)
sheetsapi can return a response up to 10 seconds. Therefore, using cache, even for a few minutes, will increase performance.
The metric named Net Revenue of Each Customer
by Brand should be developed.
Example Request
GET /metrics?id=net-revenue&dimensions=customer&aggregate=sum&filter.date.from=2020-09-10&filter.date.to=2020-09-15
Example Response
{
"metric": "net-revenue",
"dimensions": ["customer"],
"aggregation": "sum",
"filters": {
"date": {
"from": "2020-09-10",
"to": "2020-09-15"
}
}
"data": {
"Tim": [
{
"value": "321.40"
}
],
"Jane": [
{
"value": "25.00"
}
],
"Alex": [
{
"value": "78.00"
}
]
}
}
The metric namedWeekly Sessions
should be developed.
Example Request
GET /metrics?id=sessions&dimensions=date.weeknum&aggregate=distinct
Example Response
{
"metric": "sessions",
"dimensions": ["date.weeknum"],
"aggregation": "distinct",
"data": {
"49": [
{
"value": "2342"
}
],
"50": [
{
"value": "2322"
}
],
"51": [
{
"value": "1643"
}
],
"52": [
{
"value": "34"
}
]
}
}
environment variables required by the application should be kept in env files and be traversed through docker
The metric named Avg. Revenue by Brand
should be developed.
Example Request
GET /metrics?id=revenue&dimensions=brand&aggregate=avg
Example Response
{
"metric": "revenue",
"dimensions": ["brand"],
"aggregation": "avg",
"data": {
"Nike": [
{
"value": "1.23"
}
],
"Samsung": [
{
"value": "2.00"
}
],
"Apple": [
{
"value": "3.00"
}
]
}
}
the project should be containerized with docker and can be booted up with docker-compose
The metric namedDaily Conversion Date %
should be developed.
Example Request
GET /metrics?id=conversion&dimensions=date&aggregate=distinct
Example Response
{
"metric": "conversion",
"dimensions": ["date"],
"aggregation": "distinct",
"data": {
"2020-10-09": [
{
"sessions": 100,
"purchases": 10,
"value": "10.00"
}
],
"2020-10-10": [
{
"sessions": 1000,
"purchases": 250,
"value": "25.00"
}
]
}
}
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.