GitHub user saha23412 edited a discussion: Compilation of query data for a POST request
I want to make a query to build a multi-level X-axis. How to create a post_processing for a chart/data POST request with type result_type: "results", the screenshot shows an example of an array that stores ds and TAXI_OUT, how to correctly form queries[0].post_processing to get the data for "results"?I want to get the values of the ds and TAXI_OUT axes? <img width="213" height="88" alt="image" src="https://github.com/user-attachments/assets/bca6a831-1c98-4f15-870c-e4727bd1a618"; /> With this kind of Json, a strange result is obtained: `queries:[ { "filters": [ { "col": "ds", "op": "TEMPORAL_RANGE", "val": "No filter" } ], "extras": { "time_grain_sqla": "P1D", "having": "", "where": "" }, "applied_time_extras": {}, "columns": [ "ds", "TAXI_OUT" ], "metrics": [ "count" ], "orderby": [ [ "count", false ] ], "annotation_layers": [], "row_limit": 50, "series_columns": [], "series_limit": 0, "order_desc": true, "url_params": { "slice_id": "141" }, "custom_params": {}, "custom_form_data": {}, "time_offsets": [], "post_processing": [ { "operation": "pivot", "options": { "index": [ "ds" ], "columns": [ "ds", "TAXI_OUT" ], "aggregates": { "count": { "operator": "mean" } }, "drop_missing_columns": false } }, { "operation": "flatten" } ] } ]` The ds and TAXI_OUT and metric values are glued together into one column: <img width="1084" height="210" alt="image" src="https://github.com/user-attachments/assets/bd5685d1-885b-45c9-8aff-024c736045bc"; /> GitHub link: https://github.com/apache/superset/discussions/38011 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
