Timeseries with Year1, Year2, Year3..as columns

Get Help
1

Hi,

Is there anyway to display a multiple series line chart with data like this without transpose the table?

Screenshot 2025-04-08 at 16.54.17
Screenshot 2025-04-08 at 16.54.171622×634 28.1 KB

Thanks

2

Yes, use a pivot table.

3

Hi Andrew,

Thanks for your reply. Once I transpose the table, I'll have countries as columns. If I understand the product correctly, it seems like I cannot use "filter" or "click behavior - passing value" feature to zoom in on a particular country on a multi-series chart.

Do you have any recommendations to visualize this kind of table - no aggregation / group by needed, but only present the data as it is in columns ?

Thanks,
Chen