How can I better organize this table data, where rows are repeated since metrics have both a 'lights on' and 'lights off' value

1. Which two ways can be used to reduce the number of rows in a data set?
2. Which visualization should you use to display the total profit value in a sales data?

Which two ways can be used to reduce the number of rows in a data set?

Remove unnecessary rows

It can be achieved by loading filtered rowsets into model tables for two different reasons: to filter by entity or by time. Removing rows is referred to as horizontal filtering. Filtering by entity involves loading a subset of source data into the model.

Which visualization should you use to display the total profit value in a sales data?

Area charts emphasize the magnitude of change over time, and can be used to draw attention to the total value across a trend. For example, data that represents profit over time can be plotted in an area chart to emphasize the total profit.