Dear experts,
I having a line chart for each day of month and 4 measures in line and showed the number of each measure. However, it is difficult to see that numbers because there are too many items, so i would show up data for day 5 -10- 15- 20 -25 -30 only instead of each day of month.
Has anyone help me to do that? Please list steps to do that because i am new in Tableau and will need to learn so much!..
Regards
Michael
4 answers
Hi Michael
This should start you off
IF DATEPART('day',[Date]) <6 THEN '0-5'
ELSEIF DATEPART('day',[Date]) <11 THEN '6-10'
ELSE NULL
END
Swap [Date] for your date field and add extra tests as needed...
IF DATEPART('day',[Date]) <6 THEN '0-5'
ELSEIF DATEPART('day',[Date]) <11 THEN '6-10'
ELSEIF DATEPART('day',[Date]) <16 THEN '11-15' < with extra test
ELSE NULL
END
Cheers
Mark
