This content has been marked as final.
Show 1 reply
-
1. Re: Formatted date calculation then order by original date bug?
Yuriy FalOct 10, 2018 1:23 PM (in response to X T)
Hi X T,
Sorting a Dimension Pill (even using an aggregate for that)
doesn't take into account any other Pill that might be on a view.
Think of it as if the actual sorting happens before rendering a view.
With that in mind it is easy to witness the seemingly 'strange' behaviour
of your 'Day Number & Month Name' combined Dimension Pill,
as it may contain a single Date (from either Year) or many (from several Years),
thus giving a different result when sorting by MIN(Date) or MAX(Date).
Please find the attached as an example.
Yours,
Yuri
-
Sort_Dim_by_Agg_v10.2.twbx 2.4 MB
-