[O11y][Cassandra] Lens Migration

[rajvi-patel-22]

Manually migrate Cassandra visualizations to lens in current Kibana version 8.3.0 itself.

Preparation of data for testing

• Use sample_event.json / setup live instance using docker / mock data using mock server to populate dashboards

Migration stats

	Before Migration		After Migration
	Lens	Visualization	Lens	Visualization	New Control Panel
[Logs Cassandra] System Logs	0	3	1	1 (Markdown)	1
[Metrics Cassandra] Overview	0	19	17	1 (Markdown)	1
	0	22	18	2 (Markdown)	2

Notes:

• 2 visualizations are migrated to new control panels.
• 2 visualizations are markdown which can not be migrated to the lens.

Data stream: Metrics

• Migrate 17 visualizations to the lens and 1 visualization to new control panel.
  • [O11y][Cassandra] Migrate Overview dashboard visualizations to lens in kibana 8.3.0  #5714

Data stream: Log

• Migrate 1 visualization to the lens and 1 visualization to new control panel.
  • [O11y][Cassandra] Migrate System Log dashboard visualizations to lens in kibana 8.3.0 #5715

Verification and Validation

• Verification of functionality remains the same after migration in Kibana
• Verification of data count of after-migrated visualization with before-migrated visualization in Kibana
• Verification of Dashboard are not distorted in supported Kibana version (8.3.0)

Issues Identified

• Visualizations with multiple breakdowns could not be migrated to lens
  [Cassandra] Visualizations with multiple breakdowns could not be migrated to lens #5531
  Impact : [ Severity : Critical, Workaround : Yes (Use multiple breakdown in lens)]

[rajvi-patel-22]

@SubhrataK, Cluster Info [Metrics Cassandra] visualization contains 4 slice in donut chart but in Lens we can only add maximum 3 slices.

Cluster Info [Metrics Cassandra] panel in visualization:

Cluster Info [Metrics Cassandra] panel in Lens (the last slice cassandra.metrics.system.rack is not added):

What should we do in this case? Should we migrate the panel in lens with 3 slices or keep the visualization as it is?

CC: @agithomas

[agithomas]

@rajvi-elastic , can you please clarify what is the information getting represented in the panel? Because the resolution of the image above is not great, i could not figure out.

[agithomas]

Is the visualisation showing - { datacenter, cluster, ip } tuple as a donut chart ? Or is my understanding wrong?

[rajvi-patel-22]

@rajvi-elastic , can you please clarify what is the information getting represented in the panel? Because the resolution of the image above is not great, i could not figure out.

@agithomas I have updated the image.

Is the visualisation showing - { datacenter, cluster, ip } tuple as a donut chart ? Or is my understanding wrong?

The current visualization is showing { version, cluster, datacenter, rack} as donut chart. But in lens we can show upto 3 slices.

[agithomas]

The current visualization is showing { version, cluster, datacenter, rack} as donut chart. But in lens we can show upto 3 slices.

If there are no real metrics shown, wouldn't a simple table format be better? @SubhrataK , what you think?

[SubhrataK]

If there are no real metrics shown, wouldn't a simple table format be better? @SubhrataK , what you think?

@agithomas, This has been discussed with @rajvi-elastic already. The team will make sure that as and when such cases arise during the migration, the team will look into representing the data with an alternative visualization. This may change the type/format of visualization from the original dashboard, after migration, which is fine as long as the data displayed is making sense to the user.

For this use case specifically, I have asked @rajvi-elastic to populate some more sample data, before we can make a decision on the type of visualization we should go for. She is working on it.

[rajvi-patel-22]

For this use case specifically, I have asked @rajvi-elastic to populate some more sample data, before we can make a decision on the type of visualization we should go for. She is working on it.

@agithomas @SubhrataK, Please find the below generated visualizations in lens:

Original visualization [Donut chart]:

Suggested visualizations:

1. Table visualization with 4 columns {version, cluster, datacenter, rack}
   

2. Donut chart in lens [with 3 slices {version, cluster, datacenter}]
   

3. The line chart/Area chart/Bar chart won't improve the readability because those visualizations are mostly used to visualize the timeseries data. In our case it would look something like this:
   

[SubhrataK]

@rajvi-elastic As you can notice, the donut chart looks extremely confusing in this case. As a user, I do not know where to focus. Please go ahead and replace it with the table format.

[rajvi-patel-22]

PR is approved and merged, hence closing this issue:
#5714
#5715