I have a dashboard that contains snapshot dates (what our data looked like at a certain time) in order to look at change from one date to another. We recently brought in Goals data. I want to use a sum(if statement to link the goals to the territories they belong to. However the statement seems to be aggregating the goal data accross all snapshot dates . If I select one snapshot date, I get the aggregation of every date before it. Is there any way to stop this if statment from agrregating?
Sorry, I can't open your file, what is the format / origin of this? If it's a not too complicated data model, a screenshot of the table viewer might already do the job. At best, you could try building a small sample QV app and upload it.