Forum Discussion
How to create Funnel chart with count based upon filtered values
My data resembles this:
| Name | Count | Type |
| AAA | 5 | A |
| BBB | 10 | A |
| CCC | 15 | B |
| DDD | 20 | B |
I want to create a funnel chart that shows:
- Total Count = 50
- Count of Type A = 15
- Count of Type B = 35
The key point is both #2 and #3 are based upon SUM of the Count column AND where Type = [something].
Is this doable?
Anonymous choose the funnel visual and add Type and Count column as shown below
