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
It is possible as mentioned in other comment. You might want to use database view for easy configuration