Skip to main content
Announcements
Happy New Year! Cheers to another year of collaboration, connections and success.
cancel
Showing results for 
Search instead for 
Did you mean: 
george55
Partner - Creator III
Partner - Creator III

If-statement in combination with changing Label

Hi all,

When using a formula like this, then in the chart you can label a point. e.g. for point '9' will be shown as "Last 10 Days"

If([TimestampField] > FirstWorkDate(Today(), 5, $(Holiday)), 'Last 5 Days'))

2020.0317-114530.jpg

But if the 'if' contains a 'then' with a calculation, is it possible to put a label simultaneously? Something like:

If([TimestampField] > FirstWorkDate(Today(), 5, $(Holiday)),
         FirstWorkDate(Today(), 30, $(Holiday)) / 5,
         'Last 5 Days'),

 

Info: [TimestampField] is used in a filter pane

Thank you.

Labels (1)
0 Replies