Project wise average cost calculation

Question & Answer
, , , ,
1

image
image1184×352 53.5 KB

how to calculate average of projects i mentioned , tried different ways, getting wrong calculation , i want to display average column and sum up the project rows / no.of rows i want that average not able to get correct average

2

Hi @Satyaraj ,
the easiest way is to add a calculaction like:

sum({Cost Measure}) / distinct_count({project})

And then create a second pivot table with your date field in columns and you new calculation in values. Rows are empty. This vizz calculates your average costs per project on a monthly base.

Regards,
Nico

4

Hi @Nico ,
Above formula is not working

5

I inserted your field names to the formula. Please try:
sum({lineItem/UnblendedCost}) / distinct_count({lineItem/UsageStartDate}})

Regards,
Nico

6

tried same before getting syntax error

Regards,
Satyaraj

7

Hi @Satyaraj
There was a typo in the formula:
sum({lineItem/UnblendedCost}) / distinct_count({lineItem/UsageStartDate})

Can you try this and make sure, that your fields are included?

Regards,
Nico