/
Cool Tips and Tricks

Cool Tips and Tricks

Wanna edit like a pro? Take a gander through some of these tips and tricks to help boost your Tableau toolbox

Found a cool tip you would like to share? Stick it in the comments below, I'll add it and credit you

 (more...)

Please leave your name and email (you can include your company name and job title too if you like) for the credit as once added, I shall delete your original comment 

RequirementExplanation (Optional)Solution
Need to identify the first or last order date each month?

This elegant solution first truncates each day in each month back to MM/YYYY and then identifies the Max or Min date.

Functionally identical to a scoped Window_Max or an SQL Max(Order_Date) Over(Partition By DatePart...

{Fixed DateTrunc('month',[Order Date]) : Max([Order Date])}

Related content

Recipes
Read with this
Tableau Best Practices
Tableau Best Practices
More like this
Tableau Knowledge Base
Tableau Knowledge Base
Read with this
Lets Talk: Parameters
Lets Talk: Parameters
More like this
Waterfalling with Tableau
Waterfalling with Tableau
Read with this
Tuning
More like this