hi,
i want to filter “date/time”-range" of a “slice” with “slider”-Input (numeric value)
e.g. date-range = the last 30 days (slider = 30)
date-range = the last 7 days (slider = 7)
step 1: adding a “vc” with formula for calulation number of days from “Today”
HOUR (TODAY() - DATE([Date/Time])) / 24
table-name: “weight”
vc-column-name: “days”
no problem!
step 2: generating numbers between 1 - 30 with slider in a separate table (only one row with value of slider-input)
table-name= “select”
column-name = “days”
no problem!
step 3:
filtering “slice” with “slider-input”
setting up “row-filter-condition” of “slice”: [weight].[days] >= [select].[days]
this does not work because i cannot select table “[select].[days].” for “row-filter-condition”.
how can i achieve this? - many thanks in advance for your help!
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |