If you have Date/Time as a field in an object, data are not scaled appropriately in say a line graph with Date/Time on the x-axis. If you don’t have data for a certain day Knack will fill in ‘0’ in a line chart, but if you Hide Empty Fields Knack will treat a 1 week gap the same as a 6 month gap between records. It’s impossible to look at trend lines or analyze seasonal patterns.
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
Charts with dates should reflect time linearly | 0 | 518 | February 4, 2021 | |
Functionality graphs | 1 | 467 | April 29, 2021 | |
Date/time filter | 2 | 394 | February 22, 2024 | |
Matching dates | 1 | 131 | March 22, 2024 | |
Calculating days between two dates | 4 | 2098 | May 4, 2023 |