Best Of

Agree, things like date grain ,date range start and date range end should be available to be used in BeastModes just like variables, as often you'd need to adjust calculations based on these values.

marcel_luthi

1

Re: Has anyone worked with the Shopify connector. What exactly is the difference between the Date Filter

If you are filtering on created date, all orders created on that date (10/18) should show up regardless of updates.

Domo and Shopify may have different time zones. If Shopify are in UTC and Domo uses local time zone, some orders may fall outside the range. You may also encounter issues due to delayed order updates. The duration of the connector, if it runs a long time, might also affect things.

ArborRose

1

Re: Make readily accessible a "Has Input" filter for Dataflows in the DataCenter

I'd love to have a filter for 0 outputs, too. sometimes dead dataflows sit around and it would be nice to filter and quickly clean them up.

RobynLinden

1

Re: Sorting Day of Week on the X-Axis

You’d need to create another beast mode with a case statement to return a numerical value for the day and order you want

CASE WHEN DAYNAME(`date`) = 'Sunday' then 8 ELSE DAYOFWEEK(`date`) end

DAYOFWEEK returns 1-7 for Sunday-Saturday the case statement just shifts Sunday to 8 so it’s last

Put this beast mode in your sorting section on your card to then order your days

GrantSmith

4

Re: Highlight Filter Functionality

Highlighting doesn't work on all card types unfortunately. You can see in my screenshot below when I hover over "Friday" in my upper left table card, it highlights the Friday bar on the bar chart but not on the other table card.

Another approach would be to use a variable, where the variable selection would highlight a row in a table via a beast mode and color rules. Essentially, your beast mode would be: CASE WHEN Sub-Category = varSubCategory THEN 1 END

Then you would set a up color rule to highlight where your beast mode =1

ggenovese

1

Re: Extra 0 bar in bar chart with beast mode

Hi @Manasi_Panov , the suggested solution worked for this problem, thanks you so much.

rupinderkaur87

1