We are working on creating a PA dashboard with weekly indicator and bar chart visualization and facing some issues as described below.
1. X-axis labeling:
Currently, the X-axis displays only *week numbers*. The requirement is to show the *week ending date* instead, to provide clearer analytical context.
2. Conditional color coding:
For one of the percentage-based charts, we need conditional formatting on the bars. Specifically:
• If the value is > 95%, the bar should appear green.
• If the value is < 95%, the bar should appear red.
We need to confirm if such condition-based coloring is supported.
3. Visible week range on charts:.
By default, charts with a weekly trend display around 18 weeks on the X-axis. While there are period-setting options (months/years), there is no configuration
to restrict visiblilty by *weeks*. The requirement is to show only the last 6 weeks of data on the chart. We need to confirm if this configuration is posible.
Looking forward to a good discussion.
Thanks in advance
