Hello!
I'm completely new to Qlilksense, so I hope you will help me. I need to make a chart that shows correlation between change of course USD/RUB and EUR/RUB and car sales for whole year.
So in my file I have 5 columns (Brand name, Month,Sales per month ,average course USD /RUB per each month, avg course EUR/RUB per each month )
So I guess I need to use scatter chart. What to choose as measures and dimension? Measures- sales and avg USD/RUB and dimension Brand name?
Where to put the correlation formula?
Thanks in advance,
Sofia