[Bug]: integer division truncates to 0 in EVAL

[JohannesMahne]

❓ Step of Instructions

The issue occurs in the Data tier and data stream per day section of the dashboards.

🚨 Error Message

N/A

📌 Query or Command Used

N/A

🔢 Elastic Stack Version

9.1.3

🔄 Steps to Reproduce

N/A

✅ Expected Behavior

N/A

🖼️ Screenshot (if applicable)

[JohannesMahne]

To fix it by TO_DOUBLE:

FROM billing_cluster_cost_lookup
| EVAL config_join_key = "chargeback_config"
| LOOKUP JOIN chargeback_conf_lookup ON config_join_key
| LOOKUP JOIN cluster_deployment_contribution_lookup ON composite_key
| LOOKUP JOIN cluster_datastream_contribution_lookup ON composite_key
| EVAL 
    indexing = CASE(deployment_sum_indexing_time > 0, (TO_DOUBLE(datastream_sum_indexing_time) / deployment_sum_indexing_time) * total_ecu * conf_ecu_rate)
//    indexing = CASE (deployment_sum_indexing_time > 0, datastream_sum_indexing_time / deployment_sum_indexing_time * total_ecu) * conf_ecu_rate
| STATS  
    agg_indexing = sum(indexing)
    BY 
        @timestamp, 
        datastream
| WHERE agg_indexing > 0
| SORT agg_indexing DESC

[JohannesMahne]

The same is happening here:

[yannickwellens]

Was this fixed in the 0.2.0 zip? As I currently see this behaviour with that version

[JohannesMahne]

This will be fixed in 0.2.1, see PR #51

[JohannesMahne]

The PR was merged.