Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I know that the Function Today() generates the current days date.
How do I generate on a straight table the subsequent days across rows as per below so that regardless of when I open the dashboard, the current date will reflect and not be static
For eg. 21/05/2018...... 22/05/2018......23/05/2018...........24/05/2018..........25/052018
But I told you to use this in your expression...
Sum({<CalDate = {"='>=' & Date(Today(), 'DD/MM/YYYY'))"}>} Measure)
You do have these dates in your dashboard, right? If you do... you can use set analysis to show the data range in the object you are looking to show these in.
Hi Sunny
Yes these dates were already generated as a CalDate field up until 31/12/2018 so that the individual dates could show in a straight table.
The challenge is now displaying or updating this table to always reflect the current date and the subsequent dates that follows?
May be use this kind of set analysis in your expression
{<CalDate = {"='>=' & Date(Today(), 'DD/MM/YYYY'))"}>}
Possibly correct however it says Garbage after expression '='
What is the exact expression you used?
{<CalDate = {"='>=' & Date(Today(), 'DD/MM/YYYY'))"}>}
The one you provided
But I told you to use this in your expression...
Sum({<CalDate = {"='>=' & Date(Today(), 'DD/MM/YYYY'))"}>} Measure)