As the title says, how do I create a chart of a nested query in a report?
It just says No Data, however when showing the nested query data in a table all the rows are there.
Never mind, figured it out. Don’t use the “Chose Data Key” button to set the domain key and the data key for pens as it will set it to incorrect values.
Other question though, why is there no “Calculated Values” of nested query columns, e.g. the max or min?
Did you set the checkbox above the data sources for “show calculations”?
I tried that on a nested query and it worked. Granted, your question is from over 2 yrs ago so maybe the response will help others.