The first image shows the data table I designed in Kibana, while the second image is the CSV file downloaded from that table.
You can see that the columns are duplicated from "Initiated" to "Errored." However, there are no actual columns in my data table; I’ve only used rows and metrics. Interestingly, if the events are created using columns, the exported CSV doesn’t have duplicates. Unfortunately, I can’t use columns because I need to display MRR data, which isn’t possible with columns, so I rely solely on metrics.
I was able to achieve the desired visualization, but the exported CSV still has duplicated columns. Notably, the MRR data isn’t duplicated, even though it’s in the metrics. For the rest of the fields in the metrics, I used formulas, as shown in the image. Could this be the reason why duplicates appear in the exported CSV?
All the metrics have been given unique display names, yet the duplication persists. Each formula calculates the count of event.keyword for different events (e.g., "Initiated," "Dialing," ..., "Errored").
