Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a Date Range I would like to show in a text box that updates when new data comes in and the dashboard is refreshed. I currently have a field called 'Date' and I would like to show in the text box the date range the other dashboard elements are displaying.
For example, I have a Gauge showing a % change Week over Week for the number of Incidents submitted. I would like two text boxes showing:
1. Current Week Date Range
2. Prior Week Date Range
Maybe something like
=Weekstart(Today()) & ' - ' &Weekend(Today())
resp.
=Weekstart(Today(), -1) & ' - ' &Weekend(Today(), -1 )
Maybe something like
=Weekstart(Today()) & ' - ' &Weekend(Today())
resp.
=Weekstart(Today(), -1) & ' - ' &Weekend(Today(), -1 )