Thank you for volunteering.
These simple function questions are easier to ask.
Probably this.but not sure, let's see yours soon.
I cannot use GIF by some reason now..
2018-10-02_6-07-03.mp4 80.0 KB
Thank you Shin for taking your time on the teaser.
I'm quite confident you did it right.
Actually, you've done it before:
How did you come to the trick
with the negative value for the bar size?
It was a revelation to me when I saw
it actually working, hence this teaser.
Pity it couldn't work with Measure Names
(but one could use Pivot / Union to workaround).
At least the last case from the KB could have a partial solution:
As for grouping three or more bars the same way
(using the same trick with a negative bar size) --
I've got an idea, but it is hacky and un-elegant.
Grouping 3+ bars is easier with bar positions on the X-Axis, imho.
PS For those who are interested in the answer,
the workbook on the Tableau Public is now downloadable.
PSS For those who wants the 'ultimate' out-of-the-box solution,
here is the Idea to vote: https://community.tableau.com/ideas/1487
Thank you for the sharing.
Yours are always elegant.
Accidentally I lost my workbook, I should have attached it anyways.
My interest was how you set dynamic size according to the date granularity.
I used count size() which is bit complicated and your way of datetrunc is definitely better and I steal it.
I think you are right on
Grouping 3+ bars is easier with bar positions on the X-Axis.
Other pity is cannot use discrete X-axis easily.