6

I have the following formula in a signalfx chart, but it's not showing any results because F has 0 timeseries. How can I display it as 0 instead of this blank line.

F = data('myapi.job.count', filter=filter('environment_type', '*') and filter('execution_status', 'failed'), rollup='sum', extrapolation='zero').sum().sum(over='7d').publish(label='F', enable=False)
A = (F).publish(label='A')

enter image description here

S.Dan
  • 1,826
  • 5
  • 28
  • 55
  • If you self-answer, you really should make sure that your answer clearly follows from your question. Please [edit] the question (or answer) to help bridge that gap. – General Grievance Feb 05 '22 at 18:19

1 Answers1

2

The solution was to use fill(0) so the complete solution would be:

F = data('myapi.job.count', filter=filter('environment_type', '*') and filter('execution_status', 'failed'), rollup='sum', extrapolation='zero').sum().sum(over='7d').fill(0).publish(label='F', enable=False)
A = (F).publish(label='A')
S.Dan
  • 1,826
  • 5
  • 28
  • 55
  • Link to the docs here: https://dev.splunk.com/observability/docs/signalflow/methods/fill_stream_method/ – stwr667 Oct 27 '22 at 08:24