trying to create a PDF from a selection of data pertaining to WEEKNUM, but shows all data regardless of the data I think I have selected
PDF if expression:
<<If: (COUNT(SELECT([Related TimeCards][ID], [WeekNum]=WEEKNUM([Created timestamp])))>0)>>
then filtered to PDF table through this:
<<START:SELECT([Related TimeSheets][ID],[WeekNum]=WEEKNUM([Created timestamp]))>>[the days of the week per column] <<END>> |
but it is pulling all created data regardless of the WEEKNUM(Created timestamp] that i would have thought would have selected weeknum I want to view.
any help would be appretiated
That would suggest that the [WeekNum] is the same as WEEKNUM([Created Timestamp]) for all records. You're saying that is not the case? Can you provide an example of the data?
Der Weeknum-Ausdruck zum Abrufen von Daten für die aktuelle Woche lautet: WEEKNUM([Timestamp_ID])= WEEKNUM(TODAY()-1)
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |