Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys! I have a doubt.
I have this filter:
It shows me year and Month. Now, I put on this filter : Year 2018 and Month July .
Also, I have 2 KPI. Current Month and Previous Month.
Current Month shows percentage of disponibility of a service from. And Previous Month has to show me percentage of previous month (June ) but my code is not working.
The sentence to get Current Month is :
1-(sum({<Disponibilidad={'NO'},[Disp.DeviceName]={'FW_PAITA(.1)'}>} [Disp.Minutos])/(24*31*60))
Previous Month is:
1-(Sum({ $< Disp.Num_Fecha = { $(=Max(Disp.Num_Fecha) - 1)},Disponibilidad={'NO'},[Disp.DeviceName]={'FW_PAITA(.1)'}>}[Disp.Minutos])/(24*31*60))
I have this fields:
I used that sentence to previous Month on different sheets(with different data) in the same app and it work it, I don't know why it doesnt work in this sheet.
Thankss
Try this instead:
1-(sum({<Disponibilidad={'NO'},[Disp.DeviceName]={'FW_PAITA(.1)'}, Disp.FechaCaida={'>=$(=MonthStart(Max(Disp.FechaCaida),-1))<=$(=MonthEnd(Max(Disp.FechaCaida),-1))'}>} [Disp.Minutos])/(24*31*60))
It doesn't work
What's the column you're supposed to filter?
You have FechaComun on your filter panes, but Dist.FechaCaida on your table
FechaComun is the name of asociation between Disp.FechaCaida and other field from another data.
Try using just these formulas in a KPI object while you have 2018 and July filtered
=MonthStart(Max(Disp.FechaCaida),-1))
=MonthStart(Max(FechaComun),-1))
What do you get as a result?
Nothing
Okay.. what about these:
=Monthstart(Date(Max(Disp.FechaCaida)),-1)
or just
=Max(Disp.FechaCaida)
I messed up the syntax, there's an extra parentheses you have to delete on those
Nothing either, but it works with FechaComun