Dashboards & Analytics Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Average value for Quarter - Dynamic

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...

image.png

Resolved! Changing Stacked Bar Chart Colors

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" ...

IM3N_0-1701587971945.png
IM3N by Rocketeer
  • 557 Views
  • 1 replies
  • 0 kudos

Force Null Value for Date

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...

hsattuwa by Rocketeer
  • 399 Views
  • 2 replies
  • 0 kudos