How to go about this question?

benm_2000
benm_2000 Member
in Datasets

Parameters would be:
Policy status = death claim
Termination date has to be less than 2 yrs from Effective Date
Sure Term and Evolution policies
RC4 (Express or Silver)
RC5 (Essence or Bronze)

i am still learning domo so this is quite confusing. im not sure if i need to manipulate filters or add new calculated fields. thank you

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited May 16

    A calculated field something like the following:
    CASE WHEN `Policy status` = 'death claim' AND `Termination date` > `Effective Date` - INTERVAL 2 YEAR AND `Term` = 'sure' AND `RC4` IN('Express','Silver') AND `RC5` IN('Essence','Bronze') THEN 'In' ELSE 'Out' END

    To give you an exact beastmode I would need more specific information.

    If I solved your problem, please select "yes" above

  • benm_2000
    benm_2000 Member

    do i break this up into single lines for each column? if that makes any sense. Im just confused because all of these calculated fields have 1 line of code. so do i first create a column name and then do the CASE to death claim and save that then create another column name for the next set of code like termination date? or is this all one big code in the beast mode?

  • ColemenWilson
    ColemenWilson Coach

    Okay are each of the lines you provided a separate field you want to use in a visualization? I was thinking it was all criteria for how you want to filter your data

    If I solved your problem, please select "yes" above

  • benm_2000
    benm_2000 Member

    Yeah im trying to use in a visualization. so i have a bunch of calculated fields set up through the dataset that is powering the card. so my goal is to create the visualization based on this.

    Parameters would be:
    Policy status = death claim
    Termination date has to be less than 2 yrs from Effective Date
    Sure Term and Evolution policies
    RC4 (Express or Silver)
    RC5 (Essence or Bronze)

    for example, i have status policy as a calculated field but where does the death claim come in? do i create a calculated field for death claim? same thing with termination date has to be less than 2 yrs from effective date. I have a calculated field for 24 months termination but how do i incorporate 2 yrs from effective date? hopefully that is a bit more clear.

Categories