Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Name | English Grade | Math Grade |
---|---|---|
Lily | A | B |
Lucy | A | A |
Grace | B | C |
Jack | D | A |
May | A | A |
Gigi | B | A |
Hi I have a table show above. And I would like to show the data in a bar chart that
(if([English Grade]='A' and '[Math Grade]'='A', count(Name))
But I just type the above expression, the chart shows nothing. What should I modify in the expression that I could get the number I want?
Thanks so much!
in bar chart
dimension Name
expression count(if([English Grade]='A' and [Math Grade]='A', Name))
in bar chart
dimension Name
expression count(if([English Grade]='A' and [Math Grade]='A', Name))
Try this,
(if([English Grade]='A' and '[Math Grade]'='A', substringcount(Name,Name))
Yes! It looks good now. Thanks so much!
we can achieve this using set analysis also...
count({$<[English Grade]={'A'},[Math Grade]={'A'}>}Name)