topic Re: Data Modelling, "and" and "or" in App Development

Data Modelling, "and" and "or"

firmographs — Thu, 14 Feb 2019 19:02:36 GMT

We have a situation where 1 data type (call it a site) has 5 attributes.

Each attribute is a dimension in the site table. The possible values for each attribute is yes, no, n/a, unknown, or null. For example, if the dimension is "near water", those are the 5 possible attributes.

We are trying to report using some "and" and "or" logic. For example, which results are "yes" for dimensions 1, 2, 3, and 4, but not 5.

What is the best way to approach this situation?

Re: Data Modelling, "and" and "or"

pradosh_thakur — Thu, 14 Feb 2019 20:47:07 GMT

I guess you can use the if () and comine the and/or to get the logic as per your requiremnt.

You need to upload some sample data to get a concrete answer on this.

Re: Data Modelling, "and" and "or"

firmographs — Thu, 14 Feb 2019 23:08:54 GMT

Sure, I understand. This is a picture representing our situation. At least, we'd get a list of results with this logic hard-coded. Better yet, we could use filters to drive the logic.

Re: Data Modelling, "and" and "or"

pradosh_thakur — Fri, 15 Feb 2019 06:15:19 GMT

=Concat(DISTINCT {<Dim1={'Yes'},Dim2={'Yes'},Dim3={'Yes'},Dim4= {'Yes'},Dim5-= {'Yes'}>}Site)