Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Senor_Dai
Partner - Creator II
Partner - Creator II

Compare Current Week to Previous 3 Week average

HI,

 

I have the following Expression to count the number of export/send to excel actions from the Governance Dashboard:

sum({<AuditType={'Export','SendToExcel'} >}Audit_Count) 

 

What I would like to do is create a chart that only populates if the current weekly total (Mon-Fri) is greater than the previous 3 week average (Mon-Fri) and show this by the Authenticated_User dimension.

 

Many thanks for any help or advice.

Dai

 

Labels (1)
  • Other

0 Replies