Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have seen a few previous posts regarding this topic, but I have been unable to find the solution for my seemingly simple problem.
I have a connection to a database table which contains a salary history for employees within the organization. For this particular visualization table, I would like to see only the maximum pay change date, and the associated Employee ID and Salary.
For example:
Employee Number Start Date Salary
1 01/01/2001 10
1 01/01/2002 15
1 01/01/2003 20
What set expression would allow this table to only display the most recent row?
The following did not work, as the table still displayed the multiple rows per employee:
max(aggr(only("Start Date"), "Employee Number"))
AGGR(Max("Start Date"),"Employee Number"))
Thanks,
Chris
Dimension 1: Employee Number
Dimension 2: Start Date
Measure:
if([Start Date]=date(max(total <[Employee Number]> [Start Date])),
sum(Salary),
null()
)
uncheck Add-ons --> Show zero values.
Dimension 1: Employee Number
Dimension 2: Start Date
Measure:
if([Start Date]=date(max(total <[Employee Number]> [Start Date])),
sum(Salary),
null()
)
uncheck Add-ons --> Show zero values.
Thank you for the help, this appears to be the solution.
I am facing one issue in this expression.
If I remove [Start Date] from my table visualization, it doesn't work properly.
Is there any solution?
Please help me it's urgent
I want to achieve this using set analysis