Add icons to the conditional formatting

Hey Stefan,

I hope you are well!

Please check out this article linked here < on creating your own conditional format icons :)

I hope this helps!

Best Wishes,

Lesley

Hi Lesley,

I was actually referring to that article but my link ,for whatever reason, got removed, so my questions were is that still applicable for version 9 and also is it updating the list in the screenshot that i provided?

I did a test in 7.4 and i am unable to see Icon Set in the drop down menu, can you please advise? I've placed the customicons.jar in the right path after updating the .png

Hey Stefan,

I have just tested this on 7.4 and 9.4 and i am seeing the same results as you - there is not custom set to choose from. :(

Let me check with the team to make sure this process has not changed.

I will update you shortly!

Best Wishes,

Lesley

Just my luck! :(

Hey Stefan,

I have been speaking with the team about this and it looks like it has been removed....

However, a possible workaround would be to use images in chart canvas OR dashboard canvas and apply conditional formats to these -

But this will depend on your desired outcome.

Let me know your thoughts on this!

If this is not a viable option for you - I will be happy to raise an enhancement request on your behalf.

Best Wishes,

Lesley

Arrr, of course they took it out...

Not sure i can use your workaround as I don't have your knowledge. Let's see if you can help.

What i try to achieve is to replace some standard icon on formatting, see below the SQL report that i have and then the conditional formatting.

In the second screenshot, i am showing the standard icon from YF which i wish to replace with my new icon (red one).

Once i drag it to the dashboard how do i add a conditional formatting? In the report i dont have the option to add picture nor to choose one (widgets), maybe because it is an SQL report?

Hey Stefan,

So using the chart canvas -

You would just want to add your images > under the Design tab

I have used an SQL report here as an example....please forgive me for how terrible it looks !!

So I created a chart based on my sql report and added some custom images - I placed the images on top of each other, so that I can conditionally format them to HIDE if they meet certain requirements.

(I did get rid of the C2 field after this - because it just got in the way and confused things)

So the Off switch is going to hide if it is equal to or greater than 5

And the On switch will hide if it is equal to or lower than 4.9

So here it is showing as ON...because the overall count is over 5

And then when filtering through to a column with a value lower than 5, it switches off....

To enable the Chart Canvas Abilities, you must create at least 2 charts based on the 1 report.

Does this help at all?

Best Wishes,

Lesley

Hi Lesley,

Few mins back i discovered that too. And it wont work for us as I dont want/need any chart.

I wanted to bring some icons that will show the status of a task like In progress, Completed, On, Off etc

Do you know where the default icons are stored? Mayne i can replace them.

Here is 1 example. Basically i wish to put some nicer icons in the STATUS column

Hey Stefan,

Ah ok, no problem

I Don't think it is as easy as just replacing your icon set - but here is a link to an article for the developer way of creating/adding your own icons

https://community.yellowfinbi.com/knowledge-base/article/creating-your-own-conditional-formatting-customised-icons-for-developers

And I believe this directs you to where the default icons currently are.

I hope this helps :)

Best Wishes,

Lesley

Ok thanks, i'll check that post. Please close this ticket. But before that can you confirm this method still applies to version 9?