Is it possible to have a drillable chart if the data from the chart is not from a record?
I am getting my data from multiple tables and mapping it to what I need
Discussion posts and replies are publicly visible
Yes. This pattern can be adapted to any data.
docs.appian.com/.../recipe-configure-a-chart-drilldown-to-a-grid.html
It is possible as mentioned in other comment. You might want to use database view for easy configuration