Forum Discussion

sbuster's avatar
sbuster
Icon for Helper I rankHelper I
3 years ago

record with max value by day

I have a dataset below that has multiple records on a given day.  What I would like to do is find the AssetID with the max number (count) of ExceptionID by day....  I was able to use groupby a...
Need Help
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi sbuster 

how about plot a table visual with three columns in Rollup table and choose Max for Exception Count column?

sbuster's avatar
sbuster
Icon for Helper I rankHelper I
3 years ago

This still returns multiple records for the same day.