Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread.
2. Toggling between dashboards is based on Filter Actions which is enabled based on a Scaffold dataset
Hope it helps
Hi Norbert Maijoor,
Thank you Very much for the response. Actually my requirement is different.
I have attached my workbook here.
If you open the work book,
In the above screen shot, there is a parameter Select View. If select the view (Hourly/Daily/Monthly) the view will be changed automatically.
The below dates are related to the parameter as below.
If the view is Hourly then the corresponding date is Order Date.
If the View is Daily, the the corresponding data should lie between the Shipping Start and End Dates.
Similarly for the Monthly, the data should lie between Order Start and End Dates.
Here the challenge is If I select Hourly, I need to show only Order Date in the view. The remaining date fields should not be displayed. Similarly for the other view also, only the corresponding dates should be displayed and the other dates should not displayed in the view.
It would be great, if we can show the dates in the same location of the dashboard whatever the selection.
Hi Chandrasekhar and Norbert,
I've taken a slightly different approach based of Chandrasekhar's feedback
Step 1 - create a date filter off your start and end dates
Step 2 - create a calculated field to convert the date to desired measurement value
Step 3 - viz it
HTH 10.5 attached
Hi Peter Fakan,
Thank you very much for the response!!!
Here I am not having any problem with the Data. My challenge is Displaying of the Date Parameters. If I select any View, only the Dates which belongs to the particular sheet to be displayed. (Date Parameters).
I have total 5 Date Parameters.
Order Date only for the Hourly View.
Order Start and End Dates only for the Monthly View and
Shipping Start and End Dates only for the Daily View.
Always these 5 Date parameters are displaying in the dashboard when I drag all these three sheets. But I want only related dates should be displayed on the dashboard based on the selected View.
Hope you understand my requirement. (Making the Date parameters display, specific to a selection).
Could you please let me know if you need any more details and it is very urgent..
Appreciate your efforts.
Thanks in Advance