Hi,
I have an expression that calculates the billable wage per location or team id however I will like to modify it to calculate for the entire company meaning all locations and team ids considered regardless if the user selects a specific location. This is the expression below
=sum({$<metric_name={'Billable Wages'},metric_grouping={'OT'} ,group_name=p(group_name), team_id=,LocationDescription=, $(vset12Months_Modifier) >} metrictotal)
/ sum({<group_name=p(group_name), team_id=,LocationDescription=, $(vset12Months_Modifier) >}hours_units)
I tried to remove the team_id=, and locationDescription=, but it is still calculating the same thing as the above expression. The goal is I also have a bar graph with the expression above so I will like the line graph expression to calculate for the entire company. Any help will be much appreciated.
Thank you
