Hi,
Currently, I have the data below broken up by a game_id column so get each game_id's individual running total of a calculated field called Rev Impact but ideally, I'd like to have one column with the sum of each individual game_id's running sum of Rev Impact.
Currently, this is not possible because Rev Impact is a calculated field that is dependent on an aggregated field (Pre ARPDAU) and if I remove the column dim game_id then the Pre ARPDAU is an aggregate of all game_id's Pre ARPDAU which gives an inaccurate running sum total.
I want to get the sum of each of these columns (537+1201+1186+6781+382) = 10,037 as ONE column but if I remove the column dimension it's not accurate because it goes off the new AGG(Pre ARPDAU). Please take a look at photo 2 as well as my attached worksheet in the comments below. Where it says $17,953 I want it to say $10,037 because that is the correct sum of the individual running sums.
Photo 1
Photo 2
Thank you!
Hi, here is a sample dashboard with sample numbers.
Essentially, "Rev Impact Running Sum" is (Pre ARPDAU * DAU) - ilrd
In sheet 1, for 4/26 the sum of all 4 games is $5,149. The first issue is why does the Grand Total not calculate the total for this metric?
Ultimately, I don't want all 4 games split by column but just one total. In sheet 2 for "Rev Impact Running Sum" on 4/26, I'd like it to say $5,149 but it currently says $4,448 because it's using the AGG(ARPDAU) of all 4 games which isn't accurate.
Is there a way to get the sum of each games' "Rev Impact Running Sum" ideally under a single column?
Please let me know if you need more elaboration. Thank you.
