COUNT of amount

Question

Hello, I have a metric that calculates for me the travel amount (see below) which has three dimensions, Parent Department, Version, and Travel lines. This metric eventually goes into a table where we have all the drop downs you see in the formula. Now I need to add another metric for display that will count the number of travel inputs each parent department has (or maybe just a KPI instead). So in this example, for Parent Department I would like to see “4”. How do I use the COUNT formula or another one to do it?

Issam Moalla · Accepted Answer

Hello@Vikatzen,You can create an additional metric dimensioned byParent Department, Version and apply the following formula:‘Travel Amount Calculated’[REMOVE COUNT: 'Travel lines']Where theCOUNT aggregator would get you the count of input lines and aggregating it at the Version and Parent Departmentlevel with the removal of the Travel lines dimension.Hope this helps

Vikatzen · Answer

Thanks!

Ask your question here!

Not finding what you're looking for?

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded