Show only Friday date labels in Continuous X-axis?

[praveenpurush6]

Hi All,
I have a chart with a continuous x-axis in which I would like to show only the Friday dates in the x-axis labels.

For example, for the below table I need to show labels only for 1/5/2018 and 1/12/2018.

Dates               Values

1/1/2018	13
1/2/2018	5
1/3/2018	36
1/4/2018	23
1/5/2018	18
1/6/2018	46
1/7/2018	48
1/8/2018	14
1/9/2018	21
1/10/2018	33
1/11/2018	28
1/12/2018	25
1/13/2018	28
1/14/2018	37
1/15/2018	15
1/16/2018	11
1/17/2018	47

Any help?

Thanks!

[shiveshsingh]

may be this dimension.

if(WeekDay(Dates)='Fri',Dates)

[bramkn]

This should work, and It might even be better to add a field in script with this if and use that field as the dimension.

[shiveshsingh]

Yes, that can also help.

[MarcoWedel]

Does it have to be a continuous dimension axis?

I guess this requirement would be easier implemented using a discrete axis.

regards

Marco

[adityaakshaya]

Hi Praveen,

You can limit you values using expression too.

if(WeekDay(Dates)='Fri',sum(Values))

Regards,

Akshaya

[praveenpurush6]

Hi Akshaya,

Doing this will filter down the dates to Friday only right?

I need to show Friday dates on labels only.

One option I can think off is having the first date as a Friday date and keep 7 or 14 in the static step field.

[shiveshsingh]

What issue are u getting in calculated dimension?

[tamilarasu]

Hello Praveen,

May be this?

=Dual(If(WeekDay(Date)='Fri',Date,''),Date)   

[praveenpurush6]

Thanks for replies, everyone.

I replaced the minimum date as a Friday date and added a static step value...now everything looks fine.

Thanks again.