topic Re: A vs B in App Development

A vs B

Spartan27215 — Mon, 22 Aug 2022 13:25:00 GMT

I need to be able to compare a portions of a population. For example Pop A has medical conditions, Pop B does not. I have many measure that give me the dollars and spent by person, plan etc. but I need to be able to compare those measures between Pop A and Pop B. For example Pop A was $3,000 and Pop B was $300. I also need to be able to count these people. I.e. 300 people had conditions, while 3000 did not. how do I go about doing this?

Re: A vs B

Taoufiq_Zarra — Mon, 22 Aug 2022 20:58:02 GMT

@Spartan27215 can you share a sample data and the expected output

Re: A vs B

Spartan27215 — Mon, 22 Aug 2022 21:10:13 GMT

Unfortunately, no, the model is too complex. However

Table: Persons(PersonId)

Table: PersonConditions(PersonId, CondId, Description)

Persons contains each person only once.

PersonConditions contains an entry for each condition a person has. Therefore, people without a condition will have no entries in this table.

Example:

Person

Person conditions

1, 1, Heart Disease

1, 3, Diabetes

2, 4, High Cholesterol

2, 10, High Blood Pressure

Measure = Dollars Spent

Desired output

People With Condition(s), $$$$$

People Without Condition(s), $$$$$$