Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
try once
Date(YearStart (today()),'YYYY-MM-DD hh:ss:mm.f') instead of Year(today())-01-01 00:00:00.0" this
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