Visualization not working on Azure billing dashboard

[pmusa]

For confirmed bugs, please report:

• Version: 7.12.0 (did not test other versions)
• Steps to Reproduce: Ingest billing metrics from Azure and open the Azure Billing dashboard. The [Billing resource name] visualization will be empty.

After further investigation, I noticed that we are using a field that does not exist in the collected documents. In the visualization, we bucket on azure.resource.name, but the correct field is azure.resource.type. I also noticed that the visualization is not filtering documents that contain the field, which results in a slower aggregation (~40ms vs. ~2ms) and wrong results (see screenshots).

Bucket using azure.resource.name with no results:

Bucket using azure.resource.type no filter with wrong results:

Bucket using azure.resource.type and filter with correct results:

[elasticmachine]

Pinging @elastic/integrations (Team:Integrations)

[ChrsMark]

Thanks for reporting this @pmusa!

@narph could you please verify if this is actually a bug?

[narph]

confirmed this looks like a bug, azure.resource.name should be still there, it looks like we took it out while working on the inventory fields (replaced with cloud.instance.name), this might not have been the goal for billing as well. I will investigate this further.

[narph]

@pmusa , I have fixed the visualization in the above PR, in the visualization above we split by resource name. Maybe in the future we can add a visualization splitting on the resource type as well.