Hi, I'm trying to calculate avg value for each quarter based on the current Month completed.I have the below table and I'm trying to calculate the Avg value for each Quarter.Avg Revenue for Quarter Q1 = (1+2+3)/3Avg Revenue for Quarter Q2 = (4+5+6)/3...
Hi,I am new to Incorta and excited to learn and build. I would like to see if anyone has built a dashboard to see the overall job details, total count, total runtime, and mainly jobs with success and failed states. I would like to create a dashboard ...
Hello everyone,I'm currently dealing with multiple result sets on the dashboard, and I find it peculiar that they aren't interacting with each other. Specifically, when I click on one result set, I expect it to have a corresponding impact on the othe...
I am facing an issue with changing the colors of the Stacked Bar Chart. Currently, the colors appear in reverse, where the "Low" category is shown in red instead of blue.I need guidance on how to properly change these colors to ensure that the "Low" ...
Hi All,What function could be used to Force Null value in a if() condition for data type as DATE/TIMESTAMP. I tried with NULL() and '' in the Argument 3 but it tells that data type is not same.Here is the eg:if(and(Inbound_Orders_SCO.Inbound_Orders.E...
.svg "Captain"){kind=icon}