#Tableau

Подписаться 66 тыс.

Просмотров 7 тыс.

50% 1

In this tip, I show you two methods for how I color BANs based on whether there is a positive or negative change. The first method colors the entire BAN, whereas the second method only colors the value of the change itself.
Download the workbook here - www.vizwiz.com...

Опубликовано:

13 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 12

@MrDavekatz 2 года назад

I generally use the SIGN function as there are three possibilities -- increase, decrease, or no change. So SIGN( SUM([Latest Year Sales]) - SUM([Prior Year Sales]) ) would return 1 for an increase in sales, -1 for a decrease, and 0 for no change.

@vizwiz 2 года назад

Ah nice! I always forget about that option.

@TH-vw4qn 2 года назад

Love this tutorial. Thanks, Andy!

@Fannie2uN2010 2 года назад

A big thank you Andy

@BI-Rahul 2 года назад

Excellent!

@jstewart_1 2 года назад

Nice

@JD_018 Год назад

Hi Andy - How can I handle instances whereby the % change calculation returns NULL so it dissappears from my view all together which isn't what I want. I'd rathr it show "--"

@vizwiz Год назад

I'd wrap the calc in the ZN function. Then when it comes to formatting, use this custom format 0.0%;-0.0%;- The third part of this number format is for formatting zero. So ZN will turn the null to zero, then the number format will display it as -

@JD_018 Год назад

@@vizwiz Hi Andy, that is what I have done. Calculation is: ZN(([Selected Period])-ZN([Previous Period ])) / ZN([Previous Period ]) In addition, I've used your formatting instructions but the calc dissappears all together when null :(

@vizwiz Год назад

@@JD_018 That makes sense. If your previous period (denominator) return 0, you should get null since you can't divide by zero.

@JD_018 Год назад

@@vizwiz can’t I not handle this instance in a way that returns “- -“ rather than it disappearing from the view all together?

@vizwiz Год назад

@@JD_018 I don't think so because you are getting an invalid result.