Platform Analytics dashboard bar chart visualization issue with x axis week representation

Vinay Noel · 3 weeks ago

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

snehareddym · 3 weeks ago

X-axis labeling
Currently, the X-axis displays only week numbers. The requirement is to display the week ending date instead, as this provides clearer analytical context.
Visible week range on charts
By default, charts with a weekly trend display approximately 18 weeks on the X-axis. Although there are options to set the period as months or years, there is no configuration available to restrict visibility by weeks. The requirement is to show only the last 6 weeks of data on the chart, and we need to confirm whether this configuration is possible.

Proposed Approach
For both requirements, we can achieve this by defining custom ranges for the X-axis using Report Ranges.

Navigate to:
All > Platform Analytics Administration > Color Settings > Report Ranges

Here, you can configure the ranges by specifying the upper value (integer or duration) and also assign colors if needed.

Based on the requirement, I have created a data visualization of the Case table with the following configuration:

Data Source: Case table
Filter: State = New and Active = True
Group By: Updated field

I then configured the Report Ranges for the X-axis as follows:

And the data visualization appears as below:

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.

For this requirement as well we need to configure the report ranges:

In the visualization shown below, to apply the colors defined in the report ranges, you must set the Color Type to Fixed Element Color in the data visualization settings.

You can refer to the documentation of report ranges : https://www.servicenow.com/docs/bundle/zurich-now-intelligence/page/use/reporting/concept/c_ReportRa...