It would be nice to have some added functionality in graphs/reports.
I have all the date in Knack, but still need to use Excel to get correct graphs.
1) If you want to view values from multiple fields in 1 graph and you add a filter 'not blank' to one of the fields, the other field is also removed.
Example: date 28 Jan 2021.
Value field 1 is blank.
Value field 2 is 3.
Add a filter to only show 'not blank' values and the value for field 2 is also no longer visible. It would be nice to be able to filter these independently.
2) It would be nice to have the option to show a dashed line/gap if a value is blank.
3) When hiding empty fields, values of 0 are also hidden. This is not correct since 0 is a possible value in certain cases. This filter needs to be improved, so 0 remains visible.
In connection to this: a blank field is shown as 0 in a graph, which is not correct.