Query ifelse syntax error

Question & Answer
,
1

ifelse(

{Risk Rating.Grade} = 'BLACK', 

rankOver(sum(ifelse({Risk Rating.Grade} = 'BLACK', 1, 0)), [{Site}], ASC, [{Publication Date Time}]) - 

rankOver(sum(ifelse({Risk Rating.Grade} = 'BLACK', 1, 0)), [{Site}, {Publication Date Time}], ASC), 

NULL

) using this but says syntax error in aws quicksight. why?

2

Hi @Bushra_BV ,

Are you trying this in QS ? , we don’t have rankover function in QS yet. Please could you send me a screenshot of the screenshot.

Thanks,
Pradeep S

1 Like
3

Hi @Pradeep_Subramanian
Basically what I want is that - we have multiple sites, each has their audits stored in {Publication Date Time}. I want the name of those sites that have consecutively got 3 {Risk Rating.Grade} as BLACK lately.

image
image1225×706 54.2 KB

This pivot doesnt seem to work or even filter or even do any conditional formatting.
We have 3 ratings - BLACK, AMBER and RED. I even created separate columns where i wrote 1 if it is black, and the same for other ratings

4

Hi @Bushra_BV,
It’s been awhile since we last heard from you, did you have any additional questions or were you able to find a work around for your solution?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

1 Like
5

Hi @Brett, No… @Pradeep_Subramanian asked for the screenshot, i have share it but there’s no response yet. Please help

6

Hi @Bushra_BV,
You mentioned conditional formatting, so are you trying to color the value boxes (or the font)?

Since there is no rankover in QuickSight, what are you trying to achieve?

7

Basically what I want is that - we have multiple sites, each has their audits stored in {Publication Date Time}. I want the name of those sites that have consecutively got 3 {Risk Rating.Grade} as BLACK lately.

8

Hi @Bushra_BV,
Yes, I read your earlier response where you mentioned that, but when you say that you ‘want the name of those sites’…what do you envision the outcome looking like? Are the sites listed under a different field or are they the ‘descriptions’ that are in your screenshot above?

I asked about conditional formatting because you mentioned that the pivot table was not doing any conditional formatting, what type of formatting are your trying to do?

Please provide a bit more explanation on what you’re working to achieve and how you’d like it to look so that we can try and assist further.
Additionally, it may be easier to assist if you were to create a sample of your analysis with anonymized data in the QuickSight Arena view.

Thank you!

1 Like
9

Hi @Bushra_BV,
It’s been awhile since we last heard from you, if you have any additional questions, please refer to my last post for additional information.

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!