Hi there seems to be a bug with the lot subtotals....
# generall
LP
03/11/2025, 2:41 PMHi there seems to be a bug with the lot subtotals. whenever I order by the dimension that is in the columns section, the subtotals disappear
✅ 1
p
Pylon
03/11/2025, 2:41 PM👋 Thanks for your message - someone from the Lightdash support team will get back to you asap. Feel free to add any additional context to the thread here in the meantime (screenshots, app version if you're self-hosting etc.).
Pylon
03/11/2025, 6:00 PMHey Luke - thanks for sharing. I'll try to reproduce so I can create a bug report to link here.
l
LP
03/13/2025, 6:39 PMalso one to note, it doesnt seem that row totals work in the sub totals either
LP
03/13/2025, 6:47 PMalso I dont think they populate for when a value in sub column is null
p
Pylon
03/14/2025, 8:41 PMHey Luke, sorry I'm having some trouble reproducing. Here's a similar query (I think) that is a bit simpler: https://demo.lightdash.com/share/baNuvmMhTqiyZ_hg1lZ2V
for me the row totals and column totals work, and the subtotals also come through okay - am i missing anything about how you have it set up?
Pylon
03/14/2025, 8:42 PMI also tried switching to a count_distinct metric but that works okay too. I did notice that it takes a second or two to calculate the subtotals so i wonder if something is going wrong on the front end when you click the subtotal checkbox?
l
LP
03/17/2025, 9:09 AMhey jake
you will need to sort by the nested rows
https://demo.lightdash.com/share/dzJ0REgPbucrinmgo5358
LP
03/17/2025, 9:09 AMor by using a table calculation that uses a window function that orderss/partitions by the nested columns
https://demo.lightdash.com/share/jvBMrfnaAPlDY_o_miN9d
I have reproduced in the links provided
p
Pylon
03/18/2025, 2:16 PMGot it, thank you! I'll check these out and log the bug(s).
l
LP
03/18/2025, 2:54 PMamazing thanks Jake!
k
Katie
03/25/2025, 6:55 PM👋 Hey LP
just following up on this with a logged issue here: https://github.com/lightdash/lightdash/issues/14187
Thanks for all of the context/detail - really helpful for debugging!
electric mint heart 1
c
Cloudy
03/25/2025, 6:55 PMI've upvoted issue #14187 for you! You're the first user to request this issue.
I'm tracking it, so I'll notify everyone here as soon as it's fixed.
Cloudy
04/09/2025, 4:11 PM🥳 ZeRego started work on issue #14187!
Cloudy
04/09/2025, 4:11 PM✅ We've fixed issue #14187: subtotals do not appear when adding ordering by the
columnsCloudy
04/09/2025, 4:39 PM🔧 We've reopened this issue: issue #14187: subtotals do not appear when adding ordering by the
columnsCloudy
04/15/2025, 4:37 PM✅ We've fixed issue #14187: subtotals do not appear when adding ordering by the
columnsl
LP
04/15/2025, 5:57 PMWOOOOO