How to show traffic lights as well as values in a report?

Hi Gabriel,

what do you think of this workaround?

The steps are:

1) make the Traffic Light column left-aligned

2) remove the column heading of the Traffic Light column by following this article

Hope you like it!

regards,

David

Hi Dave,

I have tested your alternative. However, as I am using an advanced conditional format based on a hidden column to simulate totals and subtotals, the end result does shows a white vertical line on each total or subtotal row, making it too evident that they are two different columns, as displayed in the screenshot below. Looking at your example, this white line only shows at the header, which is acceptable. Taking that into consideration do you think there are other alternatives (e.g. I was thinking of custom formatters)?

Thanks!

Gabriel

On Thu, Nov 8, 2018 at 8:39 PM Support Queue <support@yellowfin.bi> wrote:

Hi Gabriel,

I'm sorry you didn't like my workaround, but I understand the point about the white line and the subtotal row.

I imagine that custom formatters should do the job if you've got time to play around with them, also, I would say that the feature called Javascript Charts should give you enough flexibility to achieve your requirement (I remember once finding an open source javascript chart that was a table, that would certainly be a good base to work from). Unfortunately I haven't attempted anything like your requirement using either feature yet, and I don't have the time at the moment to play around with them, so I am not of any use here. But if you would like one of our professional services team to do the work for you then please let me know and I'll ask your account manager to organise it. Please let us know how you get on with this.

regards,

David