Trying to create a dashboard, but running into an error while using the “Do a search for” function. Basically I have 3 cells within the same table that I need to search for, match values, and do a basic count.
Right now, I’m using the below function to accomplish this.
Where DPS1, changes to DPS2 and DPS3 for the following Search functions, but value is always Frost. Is there a better way to accomplish this using a merge or join or some other function I’m just not familiar with? Reason being is A) I think this is super inefficient in terms of loading speed for the app, and B) I want to run more complex formulas, for example, an average representation of that specific DPS (Frost) compared to the whole data set. And this just won’t work.
I suggest that you create a repeating group and set its content to “History” [the repeating group doesn’t need to be visible, you can even place it in a popup that won’t be shown] and then set the data source to “Do a search for history”.If your current searches for the class-count share some similar constraints, you can add the constraints to the ‘do search for’ on the repeating group. The reason we are doing this is so that this repeating group element can contain all the required “list of historys” and when you are creating the class-count expression, you just need to reference the repeating group’s list of historys instead of doing searches three times.
I hope that makes sense.
Without context, I can’t really understand what “DPS” or “Frost” means
