Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the data of the year. I want to display only the current month's data.
I have 2 rows: Date(like this-10/1/2017) and HourRange(0-1, 1-2 etc)
What expression should I write to show only the current month's data?
in expression
Avg({<YearMonthField={"$(=Date(Today(), 'YYYYMM'))"}>} YourField)
in expression
Avg({<YearMonthField={"$(=Date(Today(), 'YYYYMM'))"}>} YourField)