Moving Average Overlay on stacked column

[darkins]

i have this on other panels but cant get it on a stacked column chart

| streamstats current=f last(Timestamp) as HaltedCycleLastTime by Cycle
| eval HaltedCycleSecondsHalted=round(HaltedCycleLastTime - Timestamp,0)
| eval HaltedCycleSecondsHalted=if(HaltedCycleSecondsHalted < 20,HaltedCycleSecondsHalted,0) | streamstats time_window=30d sum(HaltedCycleSecondsHalted) as HaltedCycleSecondsPerDayMA
| eval HaltedCycleSecondsPerDayMA=round(HaltedCycleSecondsPerDayMA,0)
| chart sum(HaltedCycleSecondsHalted) as HaltedSecondsPerDayPerCycle by CycleDate Cycle limit=0

this produces a stacked column based on the chart command , but in dashboard studio i expect to see HaltedCycleSecondsPerDayMA as a pickable field and i dont. I added to code as overlayfields but still not showing.

[ITWhisperer]

HaltedCycleSecondsPerDayMA is not included in the chart command which is why it is removed from the event fields. What were you expecting to be there? How was it supposed to have been calculated (by the chart command)?

[darkins]

HaltedCyclesPerDayMA is computed in the eval line above

as shown the query gives me a stacked column chart (stacked by cycle), i want the HaltedCyclesPerDayMA as a line overlay (showing the moving average on top of the raw data

[ITWhisperer]

But it is not included in the chart command so it isn't in your results and therefore not available to be shown as an overlay. You may need to find a way to calculate the value after the chart command.