data missing in chart dashboard view

[miguel1423]

data missing in chart dashboard view

Hi, I created a chart view with multiple values to show how many users are connected per months through the current year.

My problem is when I select an year period some data are missing because the value per month is not the same if I select only th month.

this my command for the chart

| eval mois=strftime(_time, "%m")
| dedup user
| chart count(eval(source_user="external" AND user_ecole="false")) AS external  count(eval(source_user="internal")) AS internal count(eval(source_user="external" AND user_ecole="true")) AS external_ecole by mois | rename mois AS "Mois"

I show you the screen shot it will be more easy to understand

capture with an period set for 1 year, per example the january month (01) show

 internal=6

external=1

theses results are false.

And if I select only the january month the result is right

internal=42

external=41

Are there an limitation with the amoun of data to analyse ? why the result is not complete when I select an time value of 1 year ?

thank you for your help

regards,

[ITWhisperer]

dedup will only keep the first unique value for the field so what your results are effectively showing is users in month 06, users in month 05 who weren't in month 06, users in month 04 who weren't in month 05 nor month 06, and so on. By the time you look at month 01 you only have a few users who haven't returned in subsequent months