Hi!
Our customer wants a report that groups lines by the same Order. Would be possible to have something like this? I searched on the forum and also read all the documentation available. I’m pretty sure is not possible unless I use an iframe and create the HTML myself, but I just want to make sure if there are any natives solutions first.
When you say “groups lines,” is it the Timeline column with the dots/lines you’re trying to reproduce? Or something else?
You can group by Order ID and order by Last Transaction Date to get the sorting as show in your image/mockup.
By grouping lines I mean, do you see how theres multiple lines for the same Order ID, but without showing any “lines” in between then, only when the Order ID changes? That is the behaviour I’m trying to create. The images are not very important actually
OK, I see what you mean. No, nothing easy, I can think of a way to do it with a SQL native query, using row counts and CASE statements to suppress the “duplicate” rows in those columns, but it is hacky. If you re-sort the columns in the table it will ruin the output.
SELECT
CASE WHEN order_row_count=1 THEN order_id END AS order_id,
...
FROM (
SELECT ROW_NUMBER() OVER (PARTITION BY order_id ORDER BY transaction_date) AS order_row_count,
order_id
...
transaction_date
FROM table
) t
...
EDIT: If you want to be able to filter as order_id you’ll have to include the original column as another name but hide it in the visualization settings so you can attach the filter to it.