Say I have table like this.
I want to create a bar chart having Event and Proposed Even as x-Axis, count of Host as y-Axis, so it will show
A Proposed: 4
A Event: 2
B Proposed: 2
B Event: 1
C Proposed: 3
C Event: 2
D Proposed: 2
D Event: 2
I now have Proposed Event as my dimension, and how to build the expression to realise this?
Guess this is to do with calculate Host field against the value in Proposed Event and in Event respectively?
Thanks a lot. I believe it should work
However, actually my table is like this:
So I tried your expression it doesn't work on mine.
Just that I need to change anything in Event but not in Proposed Event to "0" or Blank first.
Do you know how to change that? or if you know how to realise the chart without changing this?