Percent of total keeping completed month fixed?

Question & Answer
, ,
2

You wouldn’t partition by status.

You would get this calculated field and then plot on a visual the status as a group.

percentOfTotal(sum({Number of order}),[{Completed Date}])

If you are running into issues to group by month you can trunc your date.

percentOfTotal(sum({Number of order}),[truncDate('MM',{Completed Date})])

1 Like