Watcher generated report missing x-axis labels

[Karolinebryn (Karoline Brynildsen)]

I have set up a watcher that generates a report based on a dashboard and sends it on email as a pdf attachement.
In the PDF the x-axis labels are not visible, but they are visible on the dashboard. Why is that and how can I fix it?

In the pdf report the labels are missing for x-axis (they are shown for y-axis):

On the dashboard the pdf is generated from the labels are visible (however only for every other month, not for every month which is what I would prefer):

I also wonder how I can set up the watcher interval to be every month (preferably the first in every month)?

[Brandon_Kobel]

Hey @Karolinebryn which version of Kibana are you using where you're seeing this behavior?

[Karolinebryn (Karoline Brynildsen)]

@Brandon_Kobel Kibana 5.6.2 (in ElasticCloud)

Also; du you know how to set the watcher interval to be every month?

[spinscale (Alexander Reelsen)]

hey,

you should use a cron expression for that instead of an interval, if it is so long running. The interval starts counting from zero when a master node switches or the cluster is restarted, and I am sure you want to get that report every first of the month or?

--Alex

[Karolinebryn (Karoline Brynildsen)]

@spinscale yes that is exactly what I want Do you have any examples or resources on how to achieve this?

Edit: I think maybe I figured it out. Is it something like this?

"trigger" : {
    "schedule" : {
      "monthly" : { "on" : 1, "at" : "noon" }
    }
  }

[Brandon_Kobel]

Hey @Karolinebryn the x-axis labels were fixed in 5.6.3, could you try updating your Elasticsearch/Kibana to 5.6.3?

[spinscale (Alexander Reelsen)]

yes, that would work as well! Or this cron expression (the croneval tool is part of x-pack)

./bin/x-pack/croneval -c 12 '0 0 6 1 * ?'
Valid!
Now is [Mon, 4 Dec 2017 08:24:33]
Here are the next 12 times this cron expression will trigger:
1.	Mon, 1 Jan 2018 07:00:00
2.	Thu, 1 Feb 2018 07:00:00
3.	Thu, 1 Mar 2018 07:00:00
4.	Sun, 1 Apr 2018 08:00:00
5.	Tue, 1 May 2018 08:00:00
6.	Fri, 1 Jun 2018 08:00:00
7.	Sun, 1 Jul 2018 08:00:00
8.	Wed, 1 Aug 2018 08:00:00
9.	Sat, 1 Sep 2018 08:00:00
10.	Mon, 1 Oct 2018 08:00:00
11.	Thu, 1 Nov 2018 07:00:00
12.	Sat, 1 Dec 2018 07:00:00

--Alex

[Karolinebryn (Karoline Brynildsen)]

@Brandon_Kobel yes, this fixed my problem