Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.