1
-
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.
-
Amit Kothari
I would like to know if we can achieve below count in incorta.
select count(*) from table a where a.amount <100
I worte below function in incorta to replicate above query
count(If ( and(table.amount<100, table.amount>0),1,null()))
but still count function is counting all the rows.
-
Amit Kothari
How does this setting change affect other parts of the insight? In other words, I still want the null values showing up in situations like a bar chart displaying transaction by product type - I want to show the transactions with Null product category.
I want to verify that this setting change only affects the distinct count situation and not other situations as I describe above.
-
Jonathan Chang This will only affect the formula using null()
-
Please check if the insight is of type 'Data Field' or Aggregated and if you have added the above line in the engine.properties.
