Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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)