TSVB Visualisation get the filter date Value

[umay_fb]

Hi All....

i want to create a Visualisation using TSVB. can we get a Day of time filter? exp: we get a minday = 1 , and maxday = 31 from time filter like this, or time interval of timefilter.

i need this value to calculate the achievment in script bucket or math.

thanks

[nickpeihl]

Hi @umay_fb.

I'm having trouble understanding your goal. Can you share more of your TSVB visualization with us? More screenshots would be helpful.

[umay_fb]

I want to calculated the selling data. it using date in time picker.
so the formula is (maxdaydatetimepicker-mindaydatetimepicker)/()maxdaytimepicker *(revenue/targetrevenue)

from thia timepicker:
mindaytimepicker:1
maxdaytimepicker:31
rev:3k
targetrev:5k
so if using time picker like that the formula : (31-1)*(3k/5k).

[nickpeihl]

Hi @umay_fb. This was a great question. This is how I found the number of days (max date - min date). The foo aggregation was required to access the Math aggregation even though I never use it. The 86400000 parameter is the number of milliseconds in a day.

I hope this helps.

[umay_fb]

wow thanks for the answer..
I just knew I could use it. but i get the different result like this..

why i get 29.5 not 30? is that any wrong with my script? i use

(params._timestamp - params._all.foo.timestamps[0]) / 86400000

where i can get the documentation about timestamps tsvb kibana?

[nickpeihl]

In the Panel Options tab, change "Drop Last Bucket?" to "No".

[umay_fb]

thanks for answer... why i cant use it when i use Data timerange mode a entire time range? i use this formula and get a zero value..