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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sujiwan
Contributor
Contributor

Question on Qlik Sense graph & measurement

Hi I have a problem on Qlik Sense.

I have created this graph in Qlik Sense.

Measurement is 

Count(distinct{<[Call Status]={'COMPLETE','SENT'}>} [Call ID])/
Count(distinct total{<[Call Status]={'COMPLETE','SENT'}>}[Call ID])

Dimension are [Call End Date.autoCalendar.YearMonth]  and [Detail Type].

[Detail Type] show each activity of each Call.

In the graph, it calculates total activity (100%) from the data of 3 months sum together.

However, I want my graph to show total activity for each month = 100%.

How should I  revise my measurement?

Could you please help advise? Thanks.

 

Sujiwan_0-1648123276294.png

 

Labels (5)
1 Reply
vinieme12
Champion III
Champion III

Try below

Count({<[Call Status]={'COMPLETE','SENT'}>}distinct [Call ID])/
Count(TOTAL <Period> {<[Call Status]={'COMPLETE','SENT'}>}distinct [Call ID])

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.