Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Line Chart - Emphasize last day, changes daily

  • 30 March 2018
  • 2 replies
  • 75 views
K

Hello,


I have an hourly line chart that draws in a new line daily, “current day”. I want the last line emphasized each day and a consistent color. Right now when I go into series (example: I can make March 30 YELLOW in the “series” formatting section, but when March 31 comes in tomorrow, it’s random.


I want the last line each day to be emphasized with the same color, bolded, or something else to stand out. (without having to go in and edit daily)


Is this possible?



Thanks,

Karl

2 replies

anakarina.lance
Rank

Hi @Karl,


Thanks for reaching out! One way I can think of working around this is to create two custom filters. One for the current day and one for the “older day” within the range date that’s selected. Logic for this would be something like: ${orders.created_date} = trunc_days(now()) OR ${orders.created_date} = add_days(-7, trunc_days(date(now()))


Now this should only show two dates in the visualization. The colors for these two dates should stays the same with this logic implemented.

K

Thank You. This seems to have worked and taught me a few extra tricks.


Much Appreciated!

Reply


Terms of Service