Hi,
We use a BI query in our model which gives us an overview of activity status within a campaign. So, we give a campaign_id as variable and we receive a list of status with the number of activities that have that status.
For example:
We give campaign_id=TEST as variable and receive this list:
Status No. of activities Open 4 Closed 32
Question 1: How can I make some sort of calculation of the total number of activities(so like sum up the cloumn No. of activities in the output table?
Question 2: How can make the following calculation
(No_of_activities_with_status_open / No_of_activities_total) * 100%
?
So actually I want to calculate the percentage of a certain status and display that in a table. Any suggestions?
thanks in advance and best regards,
Jan Laros