hi i would like to enquire about data filtering. for example a target of 8 observation is required n only S and B will be allowed to hit this target. for anyone who have Q observation the target difference would not be deducted but will be in a total column. For S and B, difference in target will be deducted and will be in S+B and total column. how do i go about this as right now my Q is being deducted in difference and added to S+B column?
Hi Eilis,
Could you please give a step by step example of your desired scenario?
What data structure do you intend to use? Do I get it right that you have at least 2 tables: Observations, where each observation is described, and Quality, which consolidates the related observations?
Hi Nikolai, thank you for the question.
Currently I have only 1 observation table for the required scenario, which consists of 3 columns, [Safety + Both], [Difference], and [Safety + Both + Quality]. - These columns are numbered variables.
In my application, there is drop down options of either “Safety”, “Both” or “Quality”, and when either Safety or Both is clicked the [Difference] should -1 and other 2 columns should +1, whereas if Quality is picked, only the column [Safety + Both + Quality] should +1.
Hi Eilis,
I think you should be able to achieve this using a trigger logic with Single Select. For example on “input changes” you can check the value of the selected item and then update the table appropriately.