0 votes
1 view
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 !


Categories

...