topic Chart with DateTimeStamp - show all values without scrolling in App Development

Chart with DateTimeStamp - show all values without scrolling

nigelapt — Wed, 07 Feb 2024 19:03:44 GMT

Hi Folks

I am plotting the last 30 days Active Directory Replication counters in a line chart.

Over the course of a day each server will be sampled 4 times every hour.

I have a Sample Date Time field and a Sample Date field.

The Sample Date Time shows an average value for each hour through the day so in theory I would have (30 days x 24hrs) 720 points to plot. When I create the chart, with the Sample Date Time Qlik Sense does not summarize the 720 data points. Instead it gives a scroll bar.

If I use the Sample Date it displays the 30 data points without a scroll, but how do I know which order the 24 hourly sample values are plotted for that day?

Any advice how to display the data better would be greatly appreciated.

Thanks

Nigel

Re: Chart with DateTimeStamp - show all values without scrolling

Filipe — Wed, 07 Feb 2024 20:28:42 GMT

Boa tarde @nigelapt se eu entendi bem seu ponto, eu colocaria o gráfico em formato data, e usaria a classificação para classificar em timestamp.
espero ajudar

Re: Chart with DateTimeStamp - show all values without scrolling

LRuCelver — Thu, 08 Feb 2024 07:58:46 GMT

If your DateTimeStamp field is formatted as a timestamp, you can enable the continuous scaling for the x-axis:

With it enabled, you will see all values (the minichart at the bottom can be disabled):

If you don't want the continous scaling, you can set the number of axis values to "max":

Considering you are trying to show a lot points, the labels might be too many to be shown. (I used 120 points vs your close to 3000)