Highlight specific bars in a Bar chart of a pivoted table

[Raghad_Awwad]

Hello Looker Community,

I would like to highlight a subset of my data, specifically I would like to bring attention to the first 7 days of each month.

The dataset is comprised of daily sales of two months, with 2 dimensions [Month, Day of Month] and 1 measure [Sales] and the table is pivoted by month.

I would like to some how visually separate the data based on the value of day of month dimension

Thank you,

[Dawid]

I sometimes do that to highlight the last period for a monthly/weekly graph. You would have to split the measure into two table calculations. One would be when Day of Month < 8, and the other when it’s >= 8. Make sure that the falsy value for each is a NULL.

This works for one series though. If you have more than one then you’d have to do the same thing for each of the series/pivots. I haven’t found any other way to do that

[Raghad_Awwad]

Thank you Dawid, I appreciate your help.

The solution would work if I wasn’t using those values to calculate a moving average. I wish looker would allow you to adjust the color attribute to communicate more information in each chart.