Hey team !
Why does adding the “logins” to the rows, gives me the right info at the total, but removing it gives 1? How do I get that total each DOW?
this is the formula
ifelse(sum({net_cap_2})>=4,1,
ifelse(sum({net_cap_2})>0 AND sum({net_cap_2})<4 ,0.5,
0))
and I tried sumOver, RunningOver, sum … without success ! Does anyone know how to solve this ?
Hello @jimallan, welcome to the Quick Sight community!
So if you remove logins, do you have any values left in the Rows field well, or would you be leaving that empty? You need a group by value for the pivot table so visual would know how to interpret the data you are adding into it.
I may be able to get a better idea of exactly how to manage the issue you are facing if you put together an example of the visual and data you are utilizing in an Arena analysis view. Then I should be able to guide you further.
Appreciate your comment Dylan! I was able to fix it… this was my solution…
1- Using this formula called “actual_net_cap”: ifelse({Net_capacity}=0 OR (truncDate('WK',date) = truncDate('WK',now()) OR truncDate('WK',date) = addDateTime(2,'WK',truncDate('WK',now()))) OR notIn(kpi,["NET_CAP"]) ,NULL,{Net_capacity})… I was able to remove all the noise or numbers that could be affecting my calculation.
2- Finally I just created this formula ifelse(isNull({actual_net_cap}) OR notIn({TASK_REVIEWER},['AT TTs']),0,1) to give me something like this
