Untitled
Key Metrics
<aside>
Total Applications Submitted:
</aside>
<aside>
Interviews in Progress: count(filter(all(prop("Application Status") == "Interviewing")))
</aside>
<aside>
Applications that Received an Offer: count(filter(all(prop("Application Status") == "Offer")))
</aside>
The key metrics are not showing any results after publishing likely due to one of these reasons:
- The database () is empty or doesn't contain any entries yet.
- The "Application Status" property in the database is not set up correctly or doesn't match the exact values used in the formulas ("Applied", "Interviewing", "Rejected", "Offer").
- The formulas in the callouts might have syntax errors preventing them from executing properly.
To troubleshoot:
- Check if there are entries in the Job DB and ensure the "Application Status" property is correctly set for each entry.
- Verify that the "Application Status" property in the database uses the exact values mentioned in the formulas.
- Double-check the formula syntax in each callout to ensure it's correct.
- Try simplifying the formulas temporarily (e.g., just count all entries) to see if they work, then gradually add complexity back.
If the issue persists after these checks, you may need to review the database structure and formula syntax more thoroughly.