XY Chart - Bar chart problem

Hello, I want to display some data in an XY chart.

The dataset is structured as follows:

  • Session_Date (datetime)
  • Timezone (string)
  • View_Count (int)

An example of the dataset:
Row 1

  • 2025-01-15 00:00:00
  • Europe/Rome
  • 15

Row 2

  • 2025-01-15 00:00:00
  • America/NewYork
  • 32

I would like the result to be separated by date, stacking the counts by timezone.

This is what I have achieved so far, but it’s not what I would like to have

If you do a new XY chart you can see you can see 2 different values, you can render them as columns and I think you get something similar to what you want. You can use those as Europe and America. Then from there



here maybe process temp as Europe and output temp as America.

1 Like

Thanks for the reply, you mean that I should create in the query 4 different columns (not only Timezone so) and then create 4 series and bind every series to that specific column?

Yes, I guess bind the Europe series with one column type and America series with another column type, just play with it the XY component values to get the result you want.

2 Likes

It works properly in this way, thank you very much.

2 Likes