I am trying to figure out how can I build a chart that:
1. Consists of 3 panels (Value, Category, Second Value)
2. Value - Count of records from Fact X by Category Xy from the same Fact - standard query, no problem in achieving this
3. Second Value is just a count of unrelated records coming from the same elasticube but data returned is not connected to Value and Category
in result on a single chart, I can stack values that are no related but still are meaningful to be be put together. This is going to be in a form of Pyramid chart coming from Highcharts. so Top part of the pyramid comes from Value + Category and bottom from Second Value.
To give a bit more context, I am trying to stack count of Incidents by category and then add count of Audits in the bottom of the Pyramid.
Is there an easy way of doing that?
Please sign in to leave a comment.