Hello everyone,
I have a question about how to filter specific points on a given graph. I would like to filter the last six results for each of the rows that are present in the example below.
For example:
In the dark blue line I want to filter the results that are between 0.83 and 0.65 including both mentioned results;
In the orange line I want to filter the results that are between 0.77 and 0.71 including both mentioned results.
Hello @JoaoCarvalho, how are you building out your y-axis value and your color by values now? You can likely do this with a calculated field where you check for values above 0.65 and below 0.83 and return those.
ifelse({colorby} = 'blue' AND {value} >= 0.65 AND {value} <= 0.83, {value}, NULL)
Using a calculated field like this for your field well should help provide you with the expected output. Let me know if this helps!
Hi @JoaoCarvalho, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community!
Hey guys.
Thank you for your help.
The values presented in the graphs above are generated from the mobile media calculation.
I would like to leave only the last six values for each of the lines on the graph. I believe that if I do as suggested, I will have a static graph and not dynamic as I want. It is important that it is dynamic, as new data is included every week on the “x” and “y” axes.
Hello @JoaoCarvalho, are you able to set the comparison values to a parameter? That would likely be the best way to ensure it is dynamic depending on the mobile media calculation. If you have a field you could link to that would update with the dataset, that would work as well. Otherwise it would have to be based on a user input and the parameter can become the comparison value in the ifelse statement. That will be the best way to achieve this.