This choice component is writing to a user specific column and is used to filter a query to provide data for the charts.
When selecting a choice it doesn’t retain the selection, it keeps the selected value in the user specific column but on the front end for the user it appears their selection has gone.
Any ideas?
screen recording: Watch Screen Recording 2024-08-21 at 15.44.00 | Streamable
Need more information. How is the column configured. What is the value that is stored in the column. How is the list of choices built?
I’m guessing there is a current date time involved somewhere, and when the date updates after 10 seconds, the selected value no longer matches any of the listed choices, but is close enough for the filter to still work.
Here’s the relevant data.
Date Range Options - Display as values for the choice component.
Number of days - used for the Filter Date Math column (today-days)
User Date Filter - This is the column the choice component writes to.
Filter Date All Rows - fed by the user date filter and used in the query as the dated after filter.
Choice Component Settings
Jeff may be right. Does it work if we set the column to Date only?
Yeah I’m guessing the underlying time is factoring in somewhere. You’re working with a moving target as that time updates every 10 seconds. Personally I’d set up the choice component to write the number of days to the user specific column, and not an actual date. Then work out your math and filters from there.
That doesn’t solve the underlying problem of minutes/seconds/milliseconds though. You would have to convert it to a number just to be sure.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
