Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 soniasweety
		
			soniasweety
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi All,
I have 4 measures like below
count({<level={'L1'}>}users)
count({<level={'L2'}>}users)
count({<level={'L3'}>}users)
count({<level={'L4'}>}users)
I want to show this in one chart so can anyone suggest which chat I can use?
hot to create a flag for this and use as single? any other suggestions.
 MayilVahanan
		
			MayilVahanan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		HI @soniasweety 
Dim: level
Exp: count({<level={'L1','L2','L3','L4'}>}users)
 Vegar
		
			Vegar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		The choice of chart depends. Why do you want to present these four measures? Different charts can be better or worse depending on what kind of comparison they want to do.
But in general I would probably start of with some kind of bar chart.
 MayilVahanan
		
			MayilVahanan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		HI @soniasweety 
Dim: level
Exp: count({<level={'L1','L2','L3','L4'}>}users)
 Vegar
		
			Vegar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		The choice of chart depends. Why do you want to present these four measures? Different charts can be better or worse depending on what kind of comparison they want to do.
But in general I would probably start of with some kind of bar chart.
 soniasweety
		
			soniasweety
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi @MayilVahanan , @Vegar
I used Pie chart for this its working fine . but if I select level in listbox chart is not reflecting .. is there anyway to reflect the chat if I select in filter ?
 Vegar
		
			Vegar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try using this expression.
count({<level*={'L1','L2','L3','L4'}>}users)
If you look closely you will see that I used the technique in some of the bar charts on my earlier posted image.
 soniasweety
		
			soniasweety
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thank you.
I tried this aggr(count({<level={'L1','L2','L3','L4'}>}users),Level) working fine.
