I need help with mapping data from a Straight Table to a Pie Chart. I am working with 2 data source tables, where not all values are shared across tables.
To accomplish what i am looking for in my straight table, I created an 'IF' statement that replaces blank values. Which works perfectly.
Table IF Statement:
- Issue is a common field
- Project only resigns in table 1
Now, when I applied the same logic to my PieChart, all values are visible besides 'TESTING'.
Any recommendations on how to establish relationship between the two charts?