Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
my goal is to count all custommer with more than 1 reboot on a daily base
I can do a table where I can see the reboot per custommer per day
count({<event_type={reboot}>}pps_id) with dimensioning day and PPS_ID I get a that shows per das the custommer with reboots
rom this list I like to know how man custommer has >= 2 reboots?
How can I doo this?
Thanks
Stephan
P.S.: PPS_ID =custommer
I use Qlike View
Try
Count ({<pps_id = {"=count({<event_type = {'reboot'}>}pps_id) >=2"}>} pps_id)