domoexpert Member

I cant use the window function with datediff

Since its the same date column

What would be the syntax with datediff?

@Ashleigh Still waiting to hear back

I am trying to combine two values within a field so the name of the beast mode wont work. Its showing up in the legend as the Value1 value 2 Reference : Concat(value1, value2) I want to use something like concat(value1,value2) as 'abc'

Sum of sales increases by 1 or more. The criteria was met. But the alert was not triggered. The same alert was triggered when i tried the data on an excel file but it doesnt get triggered through a federated connection @Ashleigh

I did set up an alert and the data changed as well but i did not get any notification

Dataset @Ashleigh

@Ashleigh I dont see the option of any row is added in the tab. Any particular reason?

Cant i just set up an alert for when the max of my date column changes?

The real question is that why isnt the above calculation working?

I am trying to build a simple table calculation.

((CASE WHEN YEAR(`Date`) = MAX(YEAR(`Date`)) and MONTH(`Date`) = MAX(MONTH(`Date`)) THEN SUM(`Value`) END) - (CASE WHEN YEAR(`Date`) = MAX(YEAR(`Date`))-1 and MONTH(`Date`) = MAX(MONTH(`Date`)) THEN SUM(`Value`) END)) / (CASE WHEN YEAR(`Date`) = MAX(YEAR(`Date`))-1 and MONTH(`Date`) = MAX(MONTH(`Date`)) THEN SUM(`Value`)…

Can that not be done in beast mode?

Is there a way to do it other than current date since the data is lagged and might not be up to current date. Any way to do it for max month thats available

Still not letting me save the card