MichelleH Coach

@chetan_cricut The Include/Exclude filter should not be a slicer, you would need to save it to every card on the dashboard so each card is filtered to ‘Include’.

@chetan_cricut Based on your originial question, my understanding is that you wanted the users to be able to select a single “All” option to filter to all 7 values of the combination field. Is that not the case?

@chetan_cricut I recommend creating a variable with the Pills control type and values for all 7 options, plus an “All” option. Then you can create a beast mode filter based on the value selected: case when Variable = ‘All’ then ‘Include’ when Variable = combination then ‘Include’ else ‘Exclude’ end

Hi @tmerchant in that case you would want to remove Unique ID from your Group By fields. Then you can join back to previous tile on the year/month field.

HI @tmerchant You will need to first create a calculated field using a Formula tile that extracts the month and year of your timestamp column: concat(YEAR(`Timestamp`),'-',MONTH(`Timestamp`)) Then use a Group By tile to group by the Month/Year and Unique ID, counting the Unique ID field.

@Stucker The formula should already account for both of those criteria. This checks whether the Session_Date_c field has the same month and year as today's date: case when MONTH(Session_Date_c) = MONTH(CURRENT_DATE()) and YEAR(Session_Date_c) = YEAR(CURRENT_DATE()) For each row that meets the above condition (having a…

@camila What user role do you have? If you are not an admin, then I suggest reaching out to somebody who is an admin for your instance to verify your permissions. If you are an admin, then you should reach out to Domo suppor to troubleshoot.

@jdorsch2 You can do this by opening the dataset in Views Explorer. When you export a View, it will only include the rows and columns you choose. Also note that you don't have to save the View to download it, but you can if needed.

@camila Does it give you this option?

@camila What happens when you try to edit it?

@Stucker If they are both date fields, then we would need to set up the logic criteria to compare to the month and year of today's date. As it was written before, it would only count the X12_Month_Scheduled_Review__c field if the Session_Date_c field contains the words “THIS MONTH”. Here is how you can rewrite it:…

@Stucker Domo does not have an IF function like in Excel, instead it uses CASE statements for logical operations (see this list of supported beast mode functions: https://domo-support.domo.com/s/article/360043429933?language=en_US). Also when aggregating data using a sum or count, it is generally better to put those…

@GlenW I don't believe there is a way to force value labels, but you may be able to save some space by hiding the legends in your cards. Since most of your cards appear to have the same series and color rules, you likely don't need to repeat the legend in every card.

Hi @user058901 does this give you what you need? case when total weight in lb's / Contract Weights > 1 then 1 else total weight in lb's / Contract Weights end

@DataLawton I'd suggest using a Pivot Table card with State in the rows, YesOrNo in the columns, and count of YesOrNo (or any other populated field) in the values.

@Vishz14 I would suggest creating two separate branches of your MagicETL: one filtered to rows where Transaction ID is null, and the other where Transaction ID is not null. You can use Remove Duplicates tile on the branch that contains Transaction ID, then merge it back with the rows without a Transaction ID using an…

@NateBI I'm glad it worked! Would you please accept my answer as a solution to help others find the solution more quickly?

@NateBI Does it still return an error if you put single quotes around TRUE? It may be reading that as a field name instead of a value.

@G_Grey To clarify, unchecking the box I highlighted in my screenshot hides the description so it does not take up so much space on the page. The functionality you are describing already exists. When viewing the card from the Card Details page, users can still access the description (with line breaks) by clicking the Card…

@NathanDorsch Here are some settings you can use to get the formatting closer to your screenshot: Apply color rules to subtotals under Chart Properties > General > Apply Color Rules to Total and Subtotals Make subtotals bold under Chart Properties > Subtotal Rows > Subtotal Font Style Remove the “Count x/y” under Chart…

@Stucker Based on your description, you do not need the MOD() function. Will you see if the calculation works as expected when you remove it?

@louiswatson Apologies, I forgot to complete the last case statement: count(case when `Status` in ('Application Consented','Appeal Allowed') then `Status` end)

@louiswatson It sounds like you're almost there already. How about this: (count(case when `Status` in ('Application Consented','Application Refused','Waiting for Decision') then `Status` end) + count(`Appeal Determination Date`)) / count(case when `Status` in ('Application Consented','Appeal Allowed'))

@gump Can you please provide some more information your dataset and why posts might be counted more than once? Any context you can share would be helpful for the community to give the best answer

@NathanDorsch You would need to enable a second axis under Chart Properties > Value Scale (Right) > Show Right Scale. Then you will be able to set a different value format for anything on the right scale.

@Utz That makes sense. The reason your formula is not returning as expected is because it's only calculating using the total cost per seasonal value, not the grand total. You will need use a window function or a fixed function in your denominator in order to include rows for all seasonal values. For example: sum(`Cost of…

Hi @louiswatson try this: count(case when `Status` = 'Application Granted' then `Status` end)/count(`Determination Date`)

@Utz Are you trying to calculate the percentage based on the grand total cost or the total of each "Seasonal" value?

@G_Grey You can do this using the card description! If you don't want the description visible all the time, just uncheck the box that says "Show description on Card Details" (this checkbox is only visible when editing from within Analyzer). When the box is unchecked, you can only see descriptions when you hover on the card…

@Cintia Both of them MIN. Changing the aggregation to MIN ensures that your data is sorted based on the value that you assigned in the beast modes (1, 2, 3, etc.), whereas COUNT only considers whether there is a value but does not care what the value is.