Calculation Structure Question

Question & Answer
, , ,
1

I was wondering if it’s possible to remove specific items from a calculation filter.
image

I have a table of prices and I’m trying to see how far below the market average one specific company is. For example, it would be a visual that shows a phone sold at Company A for $500. While 3 other companies are also selling the phone but at a higher rate. The visual would then show something along the lines of “Company A (200)”, indicating that Company A is under the market average by 200 dollars.

2

Hello @ScottP !

For your calculation above to exclude that company, you could try something like this:

ifelse({company} <> "Blue Company", avg({advertised_rate}, [{management}]), Null)

Let me know if this is what you are looking for!