Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want latest data on sheet .. i tried this on chart and through this i got latest data
count({<LMax_Date={'$(vLMaxDate)'},[No]-={'NA'}>} distinct [No])
in VLMaxDate i did this
=Max(LMax_Date)
now i call this variable on input box just for checking latest date is displayed or not.. in my folder latest sheet for the month of Aug 2021
so in LMaxDate date is 31-08-2021
now here i want when user the change the date then according to date data will also change
i created this varaible L_Date and call date column
=LMax_Date
and drag in list box and also in input box but both objects are empty .
where as these dates are in LMaxDate column
any help
Hi
Try like below
You can see all the laptop_max_date in the dropdown menu of the variable .
thanks
Good suggestion!
Few down sides though -
1. The user is not able to change the expression outcome in the chart using this variable.
Workaround: use a Logical Island date column as suggested earlier or use a more complex expression in the measure to take user triggered change in the LDate if it is not same as LMaxDate!
2. The variable will always display one 'date value' only (either user selected or default min date).
3. The user can change the default from the drop down list. Variable is primarily used as an info only.
Regards.
Hi Nagesh,
Yes, but Its depends on the requirements need to change the option.