Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
lichang422
Creator
Creator

How to limit line chart measure value

I made a line chart .

The measure data is date.

But the date data is very long . So it made line chart display not good .

Could i set measure limt by default (like between now to before one day)

Thank you.

未命名.jpg

1 Solution

Accepted Solutions
kaanerisen
Creator III
Creator III

Hi,

For two day period:

Sum({<updatedate={"<=$(=DayEnd(max(updatedate))) >=$(=DayStart(max(date(updatedate)-1)))"}>}value)

Untitled.png !

View solution in original post

1 Reply
kaanerisen
Creator III
Creator III

Hi,

For two day period:

Sum({<updatedate={"<=$(=DayEnd(max(updatedate))) >=$(=DayStart(max(date(updatedate)-1)))"}>}value)

Untitled.png !