Stacking up multiple metrics

#1

Hi, I have several metrics that add up to a total and I’d like to show them in stacked bars grouped by region for example. I found the stacked bars example in the documentation. However, it groups by 2 attributes (venuestate and venuecity). I need to group only by 1 attribute and stack several metrics. How can I do that?

#2

hi, @pepe that scenario is well covered in the chartfactor toolkit, the only thing you need to do is pass to the visualization an array of metrics instead of only one metric. For example:

/* Configuration code for this widget */
let provider = cf.provider("Elastic Demo");
let source = provider.source('chicago_taxi_trips');
// Define metrics
let metrics = [
	cf.Metric("fare","sum"),
	cf.Metric("tips","sum"),
	cf.Metric("tolls", "sum"),
	cf.Metric("extras", "sum")
];
// Define attributes to group by
let group1 = cf.Attribute("pickup_district")
			.limit(10)
			.sort("desc", cf.Metric("fare", "sum"));

// Add metrics and groups to data source
let myData = source.groupby(group1)
			.metrics(...metrics);
// Define chart options
let myChart = myData.graph("Multimetric Bars")
			.execute();

Let me know if this answers your question. Best Regards.