Threshold bars not showing in list report fro business elapsed percentage

[nikeng]

Hi,

I'm creating a list report based on a database view. The database view consists of the task_sla table to which I left join the incident, sc_req_item and problem tables. Basically creating a view with these records and their SLAs.

When viewing the datatbase view via the "try it" link the field "Business Elapsed Percentage" is shown as a nice threshold bar, as described in this article:
https://developer.servicenow.com/app.do#!/training/article/app_store_learnv2_reportanalytics_london_...

But when I create a list report based on this database view the bar is not shown. Instead simply the decimal value is shown in the report, ie "13,5". Why is this, and how do I get the list report to show the field as a threshold bar?

[nikeng]

To add to this, when creating the list report using the task_sla table directly, instead of the database view I created, the Buiness elapsed percentage field is shown as a target threshold bar. So the problem seems to be related to using the database view. However when viewing the list view of the database view, by opening http://instancename.com/databaseviewname_list.do? the field is shown as a bar.

So the following is true:

1. When viewing the database view list the bar is shown

2. When creating a list report using the task_sla table the bar is shown.

3. When creating a list report using the database view of which the task_sla table is part of, the bar is not shown.

[nikeng]

So the way the percentage bar works is that the field is of the type "Percentage Complete". Because of this, when the dictionary attributes are set to: target_threshold_colors=0:#71e279;50:#fcc742;75:#fc8a3d;100:#f95050

The bar appears.

So it seems like when I use the table in a database view the field dictionary attributes don't apply? 

[nikeng · Accepted solution]

The solution turned out to be the column orders. For the business elapsed percentage to show as a progress bar, the column had to be in the rightmost position. Meaning that if I had a column after it, it showed as a decimal. Seems very weird but that was the solution for me.