QuickSight Conditional Formatting and Multi-Column Sorting

0

Hi,

i am developing a QuickSight "table" visual. Two questions here

  1. Conditional Formatting I'd like to display the number (i.e. Error Rate) in different colour based on its value. When defining the format condition, is it possible to use parameter instead of hard coding the value?

  2. Multi-column sorting Let's say the "table" visual has 3 columns. Is it possible to sort on column A first and then column B? I can do single column sorting right now, but not sure how to do multi-column sorting.

Thank you.

AWS
質問済み 4年前3793ビュー
2回答
1

Did you find the answer to the second part of your question about multi column sorting?

回答済み 2年前
0
承認された回答
  1. Create two parameters - thresholdGreen and thresholdRed.

  2. Create Controls for these two parameters as slider type - Threshold_Green and Threshold_Red with Min = 0, Max = 100, Step =1.

  3. Create calculated field "threshold" like this

    ifelse(test <= ${thresholdGreen},0,test >= ${thresholdRed},2,1)

  4. On "error" field, right click and create conditional formatting like follows:

    Format field based on = "threshold"
    
    Aggregation = "No aggregation"
    

    Condition #1 Equals 0 ; Color = green

    Condition #2 Equals 1; Color = amber

    Condition #3 Equals 2; Color = red

  5. Apply.

Now you can change conditional formatting dynamically with the controls you created.

Hopefully, you can achieve what you described.

AWS
回答済み 4年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ