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,
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
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.