May be a basic question, but I’ve built a few BAQs and Dashboards and cannot seem to determine what data is accessible in the Chart views as X,Y, and Z-axis. Is this affected by calculated fields? I have a basic BAQ pulling receipt information and I am trying to highlight the difference between the Receipt and Arrival dates and have create two calculated fields, one for the number of days between the two and one to give it a status based on the number of days late, 1-2, 3-5, 5+. When I try to create a chart based on the status, I can select any of the filed in the X-Axis, but the Y-Axis is only allowing me one option and then the remainder of the fields in the Z-Axis. Is this because of the nature of the data I am trying to chart? Since the days between Arrival and Receipt is the only count or Int, maybe that’s why I can’t do anything else? Am I going about it the wrong way? Any help would be appreciated.
Thanks,
Eric