Merged query - Column limitation

[kamilll194]

Hello everyone,

I merged results from two different explorers - each presents some data (for the context - number of sold cars per week). I decided to pivot “Created week” field, so basically I have columns with number of weeks and rows with number of cars.

The issue is that both Data and Visualisation present data only from the last 3 weeks. I am not sure what is the issue as:

• Both explores have a filter that I wanna see a data from last 10 weeks
• There’s not column limitation marked

Let me also add that if I open these explorers separately - data is displayed for 10 weeks.

Do you have any clue what is happening?

Thanks in advance