Forum Discussion
Helper VTOTAL SUM OF TARGET PER MONTH
Good day Guys!
Need some help, I have a table here:
and I want to get the total target of team per month and show at as a column.
Thanks in advance!
Hi RanHo ,
The effect that can be achieved is this. Put the actual value and target value into the column value.
Or you can create a measure to calculate the difference between the actual value and the target value.
Or you can manually add a constant line in Analytics, but this line is a fixed value.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
14 Replies
- amitchandak
Super User
RanHo , Based on what I got .
Matrix visual - Month on Column, nothing on rows
Sum of Target as values
If needed use property - Show on row - On
- RanHo
amitchandak
What if I want to use the target per month in Line Chart and want to compare it with the score per team? I think it will not work. Do I need to make a measure?- amitchandak
RanHo , You can take team on rows. and You can use sum of target as measure
- Jihwan_Kim
- RanHo
Jihwan_Kim
Not this Sir, the thing I want to achieve Sir the total of target per Month base on my example data.
Hi RanHo ,
Did you want one of the following results?
You can download the attachment to check.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- RanHo
Anonymous
Not like that Sir, i want to achieve the TOTAL TARGET of TEAM per MONTH and then use it as TARGET IN LINE CHART. I will give an example. I want to show it like this wherein the total Target of Team per Month is the Green so that i can compare it with actual data i have.Hi RanHo ,
The effect that can be achieved is this. Put the actual value and target value into the column value.
Or you can create a measure to calculate the difference between the actual value and the target value.
Or you can manually add a constant line in Analytics, but this line is a fixed value.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
