Currently, in the Time Range section of Board, we have the ability to use generic entities to address specific time-related business needs. Some common examples include:
- YTD (Year-to-Date) Months
- YTG (Year-to-Go) Months
- Monthly references such as JAN, FEB, MAR, etc.
These generic entities are very useful for standard monthly or yearly time periods. However, many businesses require more granular time periods related to weeks or days, such as:
- Week-to-Date (WTD) or Week-to-Go (WTG) entities, which are essential for weekly performance tracking and planning.
- Specific business weeks (e.g., Week 1, Week 2, etc.) aligned with fiscal calendars or retail cycles.
- Day-based entities like Day-to-Date (DTD) or specific weekdays (e.g., Mondays, Fridays) to support daily operations or targeted analyses.
- Rolling periods, such as last 7 days, last 30 days, or custom rolling windows.
Currently, Board allows only 3 generic entities to be defined, which limits the flexibility and scope of time-based analysis. This restriction can lead to users getting stuck or needing to create complex workarounds.
Proposed Idea:
Increase the number of generic entities allowed in the Time Range section, or provide a more flexible mechanism to define and manage a broader set of time-related generic entities. This would enable richer and more diverse time analyses, directly supporting specific business cases related to weeks and days without limitations.This enhancement would significantly improve the user experience and analytical capabilities in Board’s time dimension handling.