Hello Team ,
I have 2 graph
1st : displaying rule hit count and rule name
2nd : I want to display the hourly distribution because of the rule name with highest hit
How can i do it
please help
@ErikG - Please help on this one sorry to bother
Hi @deepa.singh
what exactly is the issue?
What time granularity do you have? Do you have some sample data?
BR
| Transaction date and time | Rule Name | Execution status |
|---|---|---|
| 4/4/2024 15:59 | ABC | FALSE |
| 4/5/2024 15:59 | DBA | TRUE |
| 4/6/2024 15:59 | GHT | TRUE |
| 4/7/2024 15:59 | ABC | FALSE |
| 4/8/2024 15:59 | DBA | TRUE |
| 4/9/2024 15:59 | DBA | FALSE |
So rule name for which execution status is True , thats a rule hit .
I want the case where rule hit has the highest count that rule hit hourly distribution is shown on other graph which has hourly data
@ErikG - Here is the sample data
I didn’t understand what you want to display.
Could you please tell me how the charts will look like for the given data? So we can find how it can be achievable in QS
So 1st chart will display rule name and count where there enhanced rule status is true for top 10 values okay
And in second chart i want out of those top 10 top 1 rule name data and how many times it was true in each hour window . The hour window can be calculated using date and time field .
@deepa.singh still not sure if I understand. Can you draw it or share screenshot.
@neelay – Please review the screenshot attached already when question was asked . 1st one has the count of rule name and count
2nd one is the hourly distribution
countIf({RULE_NAME},{RULE_EXECUTION_STATUS} = ‘TRUE’)
this is how i get rule hit count
@ErikG – Please review the above comments
Hi @deepa.singh
what you are missing is the top10 and the hour windows?
BR
We have hour window i just want data for top 1 Rule hit . and how to ensure that it is the Number is not restricted to top 1
Hello @deepa.singh, I have a thought on this to return the values related to the top 1 Rule name. You will need to make a few calculations. We can build a calculated field to get the count of TRUE execution statuses per Rule, then we can retrieve the max of those values and return the rule name where it matches. That will help filter out the values you do not want to see.
True Executions by Rule = countOver(ifelse({Execution status} = 'TRUE', {Execution status}, NULL), [{Rule Name}], PRE_AGG)
Top Rule = ifelse(countOver(ifelse({Execution status} = 'TRUE', {Execution status}, NULL), [{Rule Name}], PRE_AGG) = maxOver({True Executions by Rule}, [], PRE_AGG), {Rule Name}, NULL)
The first function will return the count of TRUE executions per rule, then the 2nd will check if the count of TRUE executions for a specific rule is equal to the highest value across Rules. That will return the top rule. Then you can build a visual and calculation fields off the return value of the 2nd function.
I will mark this as the solution, but please let me know if you have any remaining questions. Thank you!