Filter on an line chart

Question & Answer
, ,
1

Hi,

So I have this calculated field where its formula is True Positive Ratio = True Positives/(True Positives + False Positives). And in my dashboard I m updating a line chart where the X- Axis is create_date and in the value is True Positive Ratio .

So my doubt is I want to update the True Positive Ratio in the value of line chart twice as I have setup Customer and Date Range as Controls where i want the one line of True Positive Ratio to be selected based on the Customer selected at the top and I want the another line to be constant and it should not be changed based on the control at the top. So may I know is there an way to arrive at the solution?

2

Hi @samytar97

I doubt whether it is possible with a single calculated field. However, the following may work:

  1. Remove filter if any on the line chart visual
  2. Create one True Positive Ratio the way you have currently which applies to all customers
  3. Create another True Positive Ratio calculated fields that computes if Customer matches your parameter
  4. You can include these two measures to the values section.
3

Hi,

I understand using one calculated field its not possible. However, if I remove filters I wont be able use controls based on the parameter created for Customer?

4

You still select the customer(s) on the parameter. The filtering happens in the calculated field and not applied directly on the visual.

1 Like