Dashboards & Analytics Discussions

Sum of latest six months

Hi,I want to create a formula in business view to calculate last six months sum.Please let me know how to write formula.

Resolved! Rolling 3 month sum in business schema

Hi, is it possible to define a rolling sum formula in a business schema? I would like to sum up totals from 2 preceding rows and 'current row' for each row, and based on the dimensions added to the insight, I want this total to update.This is what I ...

Resolved! display no.of days in a month dynamically

Is there a calendar function available to display number of days in every month of a specified year

Logic for Calculating LFYTD (Last Fiscal Year to Date)

Hi Team, can anyone help me with the formula for calculating growth of previous FYTD. Fiscal year starts on April 1st and ends on Aug 31st.

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