Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I trying to create a function in order to have the count of Incident for the last 6 month without currect mont.
I've created both Measure because I've a chart with two bars :
=Count({<CI_APPLI_INFRA={'Infrastructure'}>}CI_APPLI_INFRA) + Sum({1} 0)
=Count({<CI_APPLI_INFRA={'Application'}>}CI_APPLI_INFRA) + Sum({1} 0)
On dimension case I've added that : "MonthYears".
Do you know how can I do that ?
I think I've to add one more thing on my both measures.
Many thanks for your help !
Need more information on your date field to help properly but on a high You need to use set analysis to get data before current month and after a point of time in 6 months
something like below
OrderDate={"<=$(=EXPRESSIONFORENDDATE) >=$(=EXPRESSIONFORENDDATE)"}
e.g. Sum( {<OrderDate={">=$(=AddMonths(Max(OrderDate),-6)) <=$(=Max(OrderDate))"}>} OrderRecordCounter)