profile

Hi! I'm sqlbelle!

Color tricks and resources - Learn data with sqlbelle 2024.04.27 edition

Published 22 days ago • 1 min read

Hello Reader,

Hope you are having a wonderful day. Here are the data tidbits for this week.

Tableau Tip - Use your own color

Do you know how you can use your own colors in Tableau?

You can use a double-click trick:

  • Double-click any entry in your color legend to bring out the “Edit Colors” window
  • Double-click any entry under “Select Data Item” to bring out the “Select Color” window
  • From the “Select Color” window, you can change color in the following ways
  1. Color slider
  2. Pick screen color
  3. RGB value = Red Green Blue
  4. HSV = Hue Saturation Value (more often referred to as HSL - Hue Saturation Lightness)
  5. Hex value

Here is a quick shorts for your reference:

video preview

Coolors for Palettes

If you are looking for some color tools, whether you’re trying to generate a color palette or trying to pick colors from an existing image, Coolors can be a good resource to try - https://coolors.co/

If you choose the palette generator, you can simply press space to generate a palette each time. Be careful though, it could be quite mesmerizing and may not realize how much time has already passed you by.

If you use the image picker and upload your own image, you can decide how many colors you want to pick from your image.

You also export the colors and corresponding HEX color values in different formats:

Canva for Meanings, History

Another great resource for colors is Canva. While you can also generate color palettes from their inspiration gallery or your own image, I appreciate the extra resources on colors, including the history and psychology of colors and their meanings (https://www.canva.com/colors/color-meanings).

For example, did you know that the color "amber" was first used in the 1500s, that it's also an eye color, and that it can denote safety? In traffic lights, it signifies "wait". (Source: canva.com/colors)

Learning about colors is fascinating!

That's it for this week.

Hope you found some tidbits and resources from this week helpful. What else would you like to see in future editions?

If you are enjoying these emails, please kindly share them with others. Your support means a lot.

Until next time,

Donabel

Hi! I'm sqlbelle!

Weekly bite-sized data tips, lessons and practical tutorials. 5 minutes to read.

Join 4.4K subscribers who receive weekly, bite-sized data lessons, and practical SQL and Tableau tutorials | Subscribe for additional resources, and start with free tutorials at youtube.com/sqlbelle

Read more from Hi! I'm sqlbelle!

Hello Reader, Greeting here Tableau Tip - working with untidy data Imagine you have to work with a lot of text, for example, needing to extract the hashtags or reformat phone numbers easily. Does Tableau have the functionality to help you? Sample untidy data The answer is yes - with regex. What is Regex? Regex, or Regular Expressions, is a powerful way to work with text. Think of it as a search tool that goes way beyond finding simple text matches. It finds patterns within text, which can be...

8 days ago • 2 min read

Hello Reader, I hope you had a great week this week. Here are the data tidbits for this week. Tableau Tip - Crosstab Here is a simple but overlooked Tableau Tip. Look at your data in crosstab. Benefits of Crosstab view: Provides a clear view of raw data numbers, which can help in your validation processes. Particularly useful for verifying complex calculations such as table calculations or LOD calculations. In Tableau, you can right-click on your view name (the tab at the bottom of the...

15 days ago • 2 min read

Hello Reader, Hope you are having a wonderful day. Here are the data tidbits for this week. Tableau Tip - Pasting Parameter Values Did you know that if you have a string parameter that accepts a list, you can copy values into your parameter? That’s right, you don’t have to type the values in one by one. You can copy the values: from an existing field’s values from clipboard You can copy and paste from a text editor or spreadsheet Copy = Ctrl + C in PC, or Cmd + C in Mac Paste = Ctrl + V in...

29 days ago • 1 min read
Share this post