topic Re: Line chart and multiple values in App Development

Line chart and multiple values

Ludvig — Thu, 09 Jan 2020 14:30:14 GMT

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?

Re: Line chart and multiple values

Stoyan_Terziev — Thu, 09 Jan 2020 14:52:58 GMT

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.

Re: Line chart and multiple values

Ludvig — Mon, 13 Jan 2020 14:37:47 GMT

Thanks!

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