Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
i have field date that i use in my filter pane , user should select only 1 date and results should be less than or equal the date the user choose
Any Clue ?
@Zahmed14
For user should select only 1 date -- Use "Always one value selected", So user can only select a single value from a filter. Note by default first value of date field will be auto selected when we use "Always one value selected".
results should be less than or equal the date the user choose -- Use set Analysis
SUM({<Date={"<=$(=MAX(Date))"}Sales)
Hello Thanks for response how to get date values which is less than the user choose
Here as example this ID have several dates if i select one date the other status does not appear
If i choose 1/1/2021 no data for this ID although i want to appear all dates execpt 3/1/2021
if i choose 15/11/2020 i will get only one record as below although i want to appear the 14/11/2020 and 27/08 and 30/09 and etc ..
how can i write that in terms of date if possible ?
Try this
SUM({<Date={"<=$(vVar)"}Sales)
vVar=Concat(GetFieldSelections(Date),',')
and in all measure use vVar as a part of set analysis.
Try this
SUM({<Date={"<=$(vVar)"}Sales)
vVar=Concat(GetFieldSelections(Date),',')
and in all measure use vVar as a part of set analysis.