https://community.splunk.com/t5/Splunk-Search/Need-help-for-Predict-command/m-p/121289#M32636 <P>using map command able to filter the results,</P> <P>index="akamai-bill" |table BU, SBU| map search="search index="akamai-bill" SBU=$SBU$ |stats sum(BU_Total) as "cost" by _time, SBU | predict "cost" algorithm=LLT future_timespan=3 | table _time, SBU,lower95(prediction(cost)) ,prediction(cost),upper95(prediction(cost)) | eval SBU=if(SBU=$SBU$, $SBU$,$SBU$."1") | table _time, SBU,lower95(prediction(cost)) ,prediction(cost),upper95(prediction(cost)) | where SBU!=$SBU$ | table _time, SBU,lower95(prediction(cost)) ,prediction(cost),upper95(prediction(cost)) | eval SBU=$SBU$ "</P> Mon, 28 Sep 2020 20:04:07 GMT dhavamanis 2020-09-28T20:04:07Z https://community.splunk.com/t5/Splunk-Search/Need-help-for-Predict-command/m-p/121288#M32635 <P>Need your help,</P> <P>We need to get the prediction for each business unit and sub business unit. But the below query giving the overall business unit prediction. Please provide the working example to get each business unit and sub business unit wise split-up for next 3 month prediction.</P> <P>index="akamai-bill" |stats sum(BU_Total) as "cost($)" by _time, BU, SBU | predict "cost($)" algorithm=LLT future_timespan=3 | sort + SBU +BU</P> Mon, 28 Sep 2020 20:02:30 GMT https://community.splunk.com/t5/Splunk-Search/Need-help-for-Predict-command/m-p/121288#M32635 dhavamanis 2020-09-28T20:02:30Z https://community.splunk.com/t5/Splunk-Search/Need-help-for-Predict-command/m-p/121289#M32636 <P>using map command able to filter the results,</P> <P>index="akamai-bill" |table BU, SBU| map search="search index="akamai-bill" SBU=$SBU$ |stats sum(BU_Total) as "cost" by _time, SBU | predict "cost" algorithm=LLT future_timespan=3 | table _time, SBU,lower95(prediction(cost)) ,prediction(cost),upper95(prediction(cost)) | eval SBU=if(SBU=$SBU$, $SBU$,$SBU$."1") | table _time, SBU,lower95(prediction(cost)) ,prediction(cost),upper95(prediction(cost)) | where SBU!=$SBU$ | table _time, SBU,lower95(prediction(cost)) ,prediction(cost),upper95(prediction(cost)) | eval SBU=$SBU$ "</P> Mon, 28 Sep 2020 20:04:07 GMT https://community.splunk.com/t5/Splunk-Search/Need-help-for-Predict-command/m-p/121289#M32636 dhavamanis 2020-09-28T20:04:07Z