Creating Bins via Math Formula
Zen Master Jonathan Drummey left a comment in Creating Bins Made Easy, saying that he is not using "IF ... ELSEIF..." statement when creating bins of equal size. Instead, he just creates a calculated field with some math wizardry. How brilliant! Jonathan's repertoire is infinite.
1Creating Bins Made Easy
This is a sequel to Coding Case Statement Made Easy. This topic came up when a colleague needs to create 25 uniform bins on percentiles. Quite a bit of manual work, isn't it?
It is pretty easy if you create bins of equal size on regular measures or dimensions.
Coding Case Statement Made Easy
The title seems to imply that coding case statement is not easy. It's actually more tedious than difficult. It's mechanical, manual and repetitive. The more options in the statement, the worse it gets.
2Speeding up Design with Large Data Sets
The Problem
When dealing with large data sets in a .tde file, the responsiveness of Tableau is reduced to the minimum. The design process may become intolerable. Every bit of change or drag or drop takes long time for Tableau to calculate and to render.
Replacing Data Source the Fast Way
Replacing data source in Tableau has not been a pleasant task for many of us. I wrote about it a while ago:
Replacing Data Source Breaks Everything: Cause, Workaround & Ultimate Fix
To minimize the pain, you can follow these steps.