Best Of

Re: Case Statement Help - Condition not being passed

Some suggestions:

Could there be trailing spaces in transaction_type? You could try `transaction_type` like 'Actuals%'. Also verify the case of transaction_type.

cwolman

1

Case Statement Help - Condition not being passed

Hi All,

I've been struggling with this absurd problem when creating a beast mode calculation using case statement. Basically I'm trying to pass 2 conditions into my case statement but for some reason, even after validating the formula, only 1 condition is passing. My calculation is:

(CASE WHEN YEAR(`transaction_date`) = YEAR(CURRENT_DATE()) AND `transaction_type` = 'Actuals' THEN
(CASE WHEN MONTH(`transaction_date`) < 7 THEN SUM(`net`) ELSE 0 END)
WHEN YEAR(`transaction_date`) = YEAR(CURRENT_DATE())-1 AND `transaction_type` = 'Actuals' THEN
(CASE WHEN MONTH(`transaction_date`) >= 7 THEN SUM(`net`) ELSE 0 END)
ELSE 0 END)

There's results from this calculation are filtering on the dates but not on the transaction_type. I've tried positioning the transaction_type condition all around the case statement but it keeps failing. Examples:

(CASE WHEN YEAR(`transaction_date`) = YEAR(CURRENT_DATE()) THEN
(CASE WHEN MONTH(`transaction_date`) < 7 AND `transaction_type` = 'Actuals' THEN SUM(`net`) ELSE 0 END)
WHEN YEAR(`transaction_date`) = YEAR(CURRENT_DATE())-1 THEN
(CASE WHEN MONTH(`transaction_date`) >= 7 AND `transaction_type` = 'Actuals' THEN SUM(`net`) ELSE 0 END)
ELSE 0 END)

---------------------------

(CASE when `transaction_type` in ('Actuals') then

(CASE WHEN YEAR(`transaction_date`) = YEAR(CURRENT_DATE()) THEN
(CASE WHEN MONTH(`transaction_date`) < 7 THEN SUM(`net`) ELSE 0 END)
WHEN YEAR(`transaction_date`) = YEAR(CURRENT_DATE())-1 THEN
(CASE WHEN MONTH(`transaction_date`) >= 7 THEN SUM(`net`) ELSE 0 END)
ELSE 0 END)

end )

---------------------------

I can't figure out what I'm doing wrong in this case statement and why the condition isn't passing. Please if anyone can help or advise on the solution, I appreciate it.

Thanks

mamedu

1

Re: How to Add a 45 degree line in a bubble chart with the line starting at (0,0)

Hey,

I am not sure what you mean by a 45 degree line. If you mean horizontal line you can do so by going to the quadrant lines option and setting a value on the y axis scale.

This will give you a horizontal fixed line based on the values you are using on your y axis.

Hope this helps. ?

rahul93

1

Re: Disabling In-App Dark Mode for iOS

I completely agree @erikjamesmason the only option right now is to add colors to the individual cards in the dashboard (as they default to clear background) but we have like hundreds of dashboards and thousands and thousands of cards, so doing this for each card is not possible.

EdgarChieng247

1

Re: Report Schedule Management

Completely agree! It would also be helpful to filter by expiration date or whether the report is enabled to better manage expired reports.

MichelleH

2

Re: Highlighting "current" on slicer

You could do something with an HTML table and use the color rules but it would be a table with a column header, then, provided the field is in the data on the page, have the table card impact the rest of your cards so when that row/cell in the table was clicked on it it would filter the rest of the cards on that page.

Otherwise anything else is DDX bricks or developing an app with coding to create colored buttons that function as filters and I don't believe anything is packaged with that deliverable.

Jessica

1

Re: Using admin to add owners to multiple cards at once

@louisshh Can you confirm that you actually have the admin role?

MichelleH

1