5replies
-
To avoid counting nulls in a formula using an IF expression returning numbers add a default of null(0.0) , for eg -DISTINCT(IF(Test.Table1.OrderStatus='Open',1,null(0.0) ))
Steps:
- Navigate to <incorta home>/IncortaNode/services folder.
- Run the command in linux : cat services.index
- See which is the folder for Analytic services
- Navigate to <Analytic services>/incorta folder
- Edit the engine.properties file to add the line: engine.disable_null_handling=false
- Save the file and navigate to the CMC url and restart the Analytic service.
- Verify the dashboard.