Fixed Calculation: Tableau ~upd~
Result: Tableau looks at all chairs, finds the single highest sales number, and highlights only that row. Do not try to memorize every LOD syntax. Instead, memorize this question:
But what if you want the FIXED calculation to respect the year?
Have you used FIXED to solve a tricky business problem? Share your example in the comments below. fixed calculation tableau
But LODs require you to think .
If you just count Customer Name by Month of Order Date , you are counting transactions , not unique customers. Worse, if someone bought in Jan and Feb, they appear in both months. Result: Tableau looks at all chairs, finds the
[Sales] = FIXED [Sub-Category] : MAX([Sales]) Drag this Flag to the Color shelf. Filter to True .
Create the FIXED calculation.
This is wrong. You need a calculation that ignores the date filter. The FIXED calculation tells Tableau: "Compute this value using these specific dimensions, and ignore all other filters (except context filters and data source filters)." The Syntax FIXED [Customer Name] : MIN([Order Date]) Translation: "Lock onto each unique Customer. Look at all the Order Dates available for that customer (ignoring my current date filters). Give me the very first one." Real-World Example: Customer Retention Imagine you want to know how many new customers you acquired each month.
About Qwirkle Online
Qwirkle is a popular tile-based board game where players score points by building lines of tiles that share a common attribute—either color or shape. The game is easy to learn but offers deep strategic possibilities, making it fun for both families and experienced gamers.
On this site, you can play Qwirkle for free directly in your browser against three computer opponents. No registration or download required. The game follows the official Qwirkle rules and is optimized for both desktop and mobile devices.
How to Play Qwirkle
- Drag tiles from your rack onto the board to create or extend lines of matching colors or shapes.
- Each line can only contain unique combinations—no duplicates allowed.
- Score points for every tile in the lines you create or extend. Complete a line of six to earn a Qwirkle bonus!
- The game ends when all tiles have been played and no more moves are possible. The player with the highest score wins.
Result: Tableau looks at all chairs, finds the single highest sales number, and highlights only that row. Do not try to memorize every LOD syntax. Instead, memorize this question:
But what if you want the FIXED calculation to respect the year?
Have you used FIXED to solve a tricky business problem? Share your example in the comments below.
But LODs require you to think .
If you just count Customer Name by Month of Order Date , you are counting transactions , not unique customers. Worse, if someone bought in Jan and Feb, they appear in both months.
[Sales] = FIXED [Sub-Category] : MAX([Sales]) Drag this Flag to the Color shelf. Filter to True .
Create the FIXED calculation.
This is wrong. You need a calculation that ignores the date filter. The FIXED calculation tells Tableau: "Compute this value using these specific dimensions, and ignore all other filters (except context filters and data source filters)." The Syntax FIXED [Customer Name] : MIN([Order Date]) Translation: "Lock onto each unique Customer. Look at all the Order Dates available for that customer (ignoring my current date filters). Give me the very first one." Real-World Example: Customer Retention Imagine you want to know how many new customers you acquired each month.
The History of Qwirkle
Qwirkle was first published in 2006 and quickly became a family favorite. The game has won several prestigious awards, including the Mensa Select Award and the Spiel des Jahres (Game of the Year) in 2011. Its simple rules and deep strategy make it a timeless classic for board game enthusiasts.
Questions or Suggestions?
Have feedback about the game, found a bug, or have suggestions for improvements? I'd love to hear from you!
Contact me at:
