Best Of
Re: Graphing multiple metrics in one chart by rank
This may not work for you depending on what your series looks like, but in the Chart Properties → General, change Sort on Totals to Descending and see if that does it for you.
Re: Scorecard First and Last shows same value..
@faisalnjit What if you used a Comparative Change chart instead so it's easier for the people interacting with the scorecard to see when there is no previous value? You can set up two beast modes for your current and previous value:
sum(case when `Period Comparison` = 'Previous' then `Visits/TimePeriod` else 0 end)
sum(case when `Period Comparison` = 'Current' then `Visits/TimePeriod` else 0 end)
April's Community Event Recording is Live!
April’s Virtual Meet-up, How to Create Composite Measures using Data Reduction Techniques" recording is now LIVE! Thanks to everyone who attended.
Re: Case statement
@domoexpert Can you please share some more context on how you are using this beast mode in your card(s)? How do you want the cards to react when the value of "Toggle" is changed?
Re: How to deactivate a user
A solution that was recommended to me was to change the person's role to Social and reset their password. This puts them in a viewer type role and resetting their password obviously keeps them from logging in with their original password. You might also need to change the e-mail listed in Domo to keep them from resetting the password again if they still have access to that e-mail address.
Re: Dataflow creation best practice and recommendation
You might consider appending rather than joining. Choose the Include All Columns option when appending so that you don't lose any columns and then you have a single dataset that you can build all your cards off of.
Re: Datasets that are added in the Drill path are not shared with the Dashboard groups
To clarify, if a drill level is added to a card that goes to a different dataset after the dashboard was shared with Group A, the drill will result in an error for Group A. In other words, Group A does not have access to the different dataset used in the drill even though the dashboard was already shared with them.
LAFligg
Re: Remove Inherited Color Rules from Drill
I completely agree and fully supportive of this. For example I have a bar chart card with say 3-4 series of different colour rules being applied, but our drill down is a table card which can be hundreds and thousands of rows, but the inherit colour rules means when it is drilled down, the colours applied to each rows of the table which is way to much on the eyes.
I will give the below recommendation a try.
Re: Remove Inherited Color Rules from Drill
It is especially hard on the eyes when a chart card with color rules drills down to a table where colors are applied to all the rows. My work-around is to write a beast mode to rename the impacted fields. As a result, I have a lot of "no color" beast modes across my datasets whose sole purpose is to make drilling down to a table card visually pleasing.
LAFligg



