Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a stacked bar chart where i am showing Segments as High-high, High, Medium, Low and others.
These segments are used as a master item with a if wildmatch
=if(WildMatch(SkillsetName,'*HH*'), '1. High High',
if(WildMatch(SkillsetName,'*H*'), '2. High',
if(WildMatch(SkillsetName,'*M*'),'3. Medium',
if(WildMatch(SkillsetName,'*L*'),'4. Low',
'5. Others'))))
I am using below expression to calculate count of each segment.
(count({$<Year=, Month=, Day=,Contact_Center={'121'},Call_Abd_Flag={'Call Answered'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
SequenceID))
now how i can convert this segment label from numbers to percentage contribution by each segment per day - so that when I add these percentage, it add to 100.
Below is current view.
When I added the same in a table with below expression for % it's working well.
((count({$<Year=, Month=, Day=,Contact_Center={'121'},Call_Abd_Flag={'Call Answered'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
SequenceID)))
/
((count(total{$<Year=, Month=, Day=,Contact_Center={'121'},Call_Abd_Flag={'Call Answered'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
SequenceID)))
try this
Count({$<Year=, Month=, Day=, Contact_Center={'121'}, Call_Abd_Flag={'Call Answered'},
Date={">=$(=Date(monthstart(Max(Date))))<=$(=Date(Max(Date)))"}>} SequenceID)
/
Aggr(Count({$<Year=, Month=, Day=, Contact_Center={'121'}, Call_Abd_Flag={'Call Answered'},
Date={">=$(=Date(monthstart(Max(Date))))<=$(=Date(Max(Date)))"}>} SequenceID), SkillsetName)
thanks for the reply. but it worked with below one.
((count({$<Year=, Month=, Day=,Contact_Center={'121'},Call_Abd_Flag={'Call Answered'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
SequenceID))
/
Day(max(Date)))
/
((count(total<Day>{$<Year=, Month=, Day=,Contact_Center={'121'},Call_Abd_Flag={'Call Answered'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
SequenceID))
/
Day(max(Date)))