Forum Discussion
Visual Interactions - pie chart not working properly
This is really weird. Let's do some tests.
1. Use this measure instead of the automatic count:
CountMeaseure=
var Number=DISTINCTCOUNT(Name)
return
IF(
Number=BLANK();
0;
Number
)2. Tell me if the mouseover value is right.
3. Try with the differents Label styles.
I've tried to re-do the "Edit Interactions", piechart A and B are actually from the same table.
From the screen-cap you can see the YES/NO chart after highlighting area in piechart A.
The numbers in YES did change, NO should be 0 but it remains as the old number.
Thanks for the help though :smileytongue:
Advocate IIIWell, see what I've developed and find what differences you could have. Otherwise, tell us more about your table and we try to help you.
Best,
Jorge Bustillo.
sorry, I may have simplified the dummy data in a wrong way lol
The data is like
- NAME
- COUNTRY
- YES/NO
- AGE GROUP (IF YES, age group is provided. If NO, age group is blank)
When I click on "blank" in piechart AgeGroup,The data just highlighted the NO but not turning YES to zero.
When I click on the other age group, it turns like this
- GeorgeBuster
I see, highlighting works fine, so your problem is the measure that represent the data value. Please tell us what measure is and how is set in the piecharts? You can do a test setting the interaction between piecharts as a filter instead of highlighting.
THe YES/NO is not a measure (cal field) but a static value. The four columns are pulled from Oracle DB directly.
With Piechart AGEGROUP: Details: AGE GROUP Value: Count of Name
With Piechart YES/NO: Details: YES/NO Value: Count of Name
Interactions work fine when set as filter, just the highlighting interaction gives the non-zero presentation.