project_dashboard

Projects Dashboard

🚀 Active Projects

TABLE 
    status as "Status",
    started as "Started",
    file.mtime as "Last Modified"
FROM "01-Projects"
WHERE status = "active"
SORT file.mtime DESC

📊 Project Progress

TABLE 
    status as "Status",
    length(filter(file.tasks.completed, (t) => t = true)) + " / " + length(file.tasks) as "Tasks",
    round(length(filter(file.tasks.completed, (t) => t = true)) / length(file.tasks) * 100) + "%" as "Progress"
FROM "01-Projects"
WHERE status = "active" AND length(file.tasks) > 0
SORT file.mtime DESC

📝 Project Tasks

TASK
FROM "01-Projects"
WHERE !completed AND status = "active"
GROUP BY file.link
SORT file.mtime DESC

🔍 Projects by Area

TABLE 
    status as "Status",
    started as "Started"
FROM "01-Projects"
GROUP BY tags
SORT tags ASC

📅 Recently Completed Projects

TABLE 
    status as "Status",
    started as "Started",
    file.mtime as "Completed"
FROM "01-Projects"
WHERE status = "completed"
SORT file.mtime DESC
LIMIT 5

🗓️ Project Timeline

TABLE
    status as "Status",
    started as "Started",
    file.ctime as "Created"
FROM "01-Projects"
SORT started DESC