How to go about this question?
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
-
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' ENDTo give you an exact beastmode I would need more specific information.
If I solved your problem, please select "yes" above
0 -
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?
0 -
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
0 -
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.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive