Back

Explore Courses Blog Tutorials Interview Questions
0 votes
3 views
in BI by (17.6k points)

Could someone please explain me creating BINS based on Weekdays in Tableau? I tried creating different Calculation Fields but it won't work

1 Answer

0 votes
by (47.2k points)
  • Tableau already knows how to bin values by dates at many levels of granularity: such as year, month, day, weekday, hour, etc. So you don't need to create a new field to bin dates by the day of the week. As creating bins is not a difficult task, it's just already available in this case.

  • You just need to put a discrete (blue) date or datetime field on a shelf. You'll see the date level of granularity displayed like, say, YEAR(MyDateField) with a leading plus sign.

You can either

  • Now, click on the plus sign to drill down by adding a second level, say MONTH(MyDateField) or

  • Now, right-click on the field to select the date level of granularity you want

Related questions

0 votes
1 answer
0 votes
1 answer
asked Jul 25, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Jul 29, 2019 in BI by Ashok (47.2k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers

500 comments

108k users

Browse Categories

...