Usage Dashboard!!

\n \n

Grouped by User

All Requests

\n \n

Usage by User

Total Users: ${groupedUsageData.rows.length}

Total Price: ${\n formatPrice(groupedUsageData.rows.reduce((sum, row) => sum + (row.total_price || 0), 0))\n }

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n ${\n groupedUsageData.rows.map(row => `\n \n \n \n \n \n \n \n \n \n \n \n `).join(\"\")\n }\n \n

User ID	Username	Requests	Input Tokens	Output Tokens	Cache Read	Cache Write	Total Price	Images
${row.user_id}	${row.username}	${formatNumber(row.request_count)}	${formatNumber(row.total_input_tokens)}	${formatNumber(row.total_output_tokens)}	${formatNumber(row.total_cache_read_tokens)}	${formatNumber(row.total_cache_write_tokens)}	${formatPrice(row.total_price)}	${formatNumber(row.total_images)}

\n \n

All Usage Requests

Total Requests: ${allUsageData.rows.length}

Total Price: ${\n formatPrice(allUsageData.rows.reduce((sum, row) => sum + (row.price || 0), 0))\n }

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n ${\n allUsageData.rows.map(row => `\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n `).join(\"\")\n }\n \n

ID	User	Timestamp	Val ID	Branch ID	Input	Output	Cache Read	Cache Write	Model	Price	Finish	Images	Our API
${row.id}	${row.username}	${formatDate(row.timestamp)}	${row.val_id}	${row.branch_id}	${formatNumber(row.input_tokens)}	${formatNumber(row.output_tokens)}	${formatNumber(row.cache_read_tokens)}	${formatNumber(row.cache_write_tokens)}	${row.model}	${formatPrice(row.price)}	${row.finish_reason}	${formatNumber(row.num_images)}	${formatBoolean(row.our_api_token)}

\n\n \n \n \n `;\n\n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n });\n}","deleted","label",[171,172,153],"backend","database","permalink","https://www.val.town/x/akj/akjus/code/backend/database/usage-dashboard.ts","extension","actionData","errors"]