Hello all,
I am trying to display count of unique device_id, error_code pairs over time like the graph below:
I am new to Quick Sight and am trying to find a way to accomplish this. Thank you for your help.
Hi @acy
maybe
will help.
Could be something like
countOver({device_id},[{error_code},{date}],PRE_AGG)
BR
Thank you for the answer. When I add the following calculated field: " distinctCountOver({device_id},[{error_code},date],PRE_AGG)" it looks like this:
It is displaying the count of pairs that are unique to that date without considering previous entries.
Now you can try to build a moving sum
Hello @acy !
Was @ErikG 's suggestion helpful, and if so could you mark their comment as a solution to help the community?
It has been some time since we have heard from you but would still like to help you find a solution. If we do not hear from you in the next 3 business days this topic will be archived.