Line chart and multiple values

[Ludvig]

In a line chart with datetime dimension on the x axis, data sometimes has multiple values for the same second. Hence no points are visible in chart for that very datetime value.
Is there a way to force QS to draw all values or any workarounds you can recommend?

[Stoyan_Terziev]

Hi Ludvig,

The way a line chart usually works is to only show you one measure value per dimension value.

Aka -> Avg Stock price per date for example - in reality the price changed multiple times but you usually only want to see the market exit price in a line chart (last price).

You need to understand what operation makes most sense according to your data.

Is it Sum(ExpressionValue) -> if for example you are analyzing sales per date

Or is it Max(ExpressionValue) / Min(ExpressionValue) -> if you are interested in the extremums

Or is it Avg(ExpressionValue) -> if you want to know the average between all points at that date

I hope that helps!

Kind regards,

S.T.

[Ludvig]

Thanks!

I was expecting that answer and will use suitable "workarounds".