Current year in Set analysis

[sekrish]

Hi, 

I have a bar chart for showing monthly totals . currently i have the year hardcoded, but trying to use Year(today) dosent seem to work in getting the current year. The expression for the Y-Axis is as fllows:

SUM({<time_created={">2020-01-01 00:00:00.0"},tag_name={"Europe"}>} sales)   -  year hardcoded
SUM({<time_created={">Year(today())-01-01 00:00:00.0"},tag_name={"Europe"}>} sales) - tred this and a few other permutations.

seems like something simple i might be missing. appreciate the assistance.
 

[NitinK7]

Hi

try once

Date(YearStart (today()),'YYYY-MM-DD hh:ss:mm.f') instead of  Year(today())-01-01 00:00:00.0" this

[Gabriel]

Hi,

What I can suggest is to go back into the script, find the date field and

DATE(FLOOR(DateField),'DD/MM/YYYY')                       AS [DateField]

So when you come back to your UI, your expression should work