MichelleH Coach

@NathanDorsch Can you share a little bit more about what you want to do with the data once it's pivoted? In cases like this, I generally find the most success in leaving the dataset as-is and doing the actual pivoting in the cards.

@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)…

@NateBI You would likely need to set up a variable control for this and replace the date dimension each card with this beast mode: case when `Date Grouping (Var)` = 'Week' then concat(date_format(`Date`,'%m/%d/%y')) when `Date Grouping (Var)` = 'Month' then concat(date_format(`Date`,'%M %Y')) … end

@NateBI Yes, you can use the "Choose Date" drop down on the top right corner of the dashboard to change the date range and groupings. As long as your cards are grouped by a date dimension and the "Hide Date Range" box is unchecked in analyzer, the "Graph by" setting will apply to those cards.

@andresperezfc How do you current have your card set up in analyzer (i.e. chart type, filters, etc)

@andresperezfc Can you please send a screenshot of the available aggregation types for this field?

@NIKKI You do not need the extra perenthasis after "WHEN". It should look like this: count(distinct case when `Enrolled/Dropped` = 'enrolled' then `ChildPlus ID` end)

@Jbrorby If you wrap a FLOOR() function around your entire formula, it will return the closest whole number without going over

@RTM Try this beast mode to include data from 3 days ago if today is Monday or yesterday if today is not Monday. If your users need to look at the data over the weekend, then you will need to add an additional line to subtract 2 days if today is Sunday. case when DAYNAME(CURRENT_DATE()) = 'Monday' and `Date` =…

@jakebutterfield Domo's PoP charts are generally pretty rigid as far a customization goes, unfortunately. What have you tried in the bar + line charts?

@froghunter Domo Everywhere should allow you to publish content to other instances, though I haven't personally used it. Here is an article about how that works:

@froghunter I'd recommend using the Dataset Copy Connector to push any existing datasets to the second instance:

@NathanDorsch I'd suggest using the Dataset via Email connector with the File Type set to "Email Body as HTML", then add the corresponding Domo email address to the distribution list for these emails. Based on the format of the tables, you may want to add the email dataset as an input for MagicETL to pivot the data so that…

@cynthial Domo Everywhere allows you to embed Domo content on other sites. Here is an article about how that works: EDIT: I realize I misread the portion or your question about sharing on social media. I don't know of a simple way to do this but others might.

@kav_100 Yes, you can change the display mode to "Auto width" to automatically fit the width of your screen.

@Chintan The Graph by setting only controls the way the data is grouped in the chart itself. For example, if you are using a bar graph with the date on the X-axis the Graph by controls how many bars are used to group the data but it does not change the number of data rows included in the chart and summary number. So for…

@domoexpert You are likely getting an error because of the second "case when" in your forumla. Case statements must follow this format: case when ___ then ___ when ___ then ___ … else ___ — this is optional end I also recommend putting the case inside the sum and formatting functions. Here is what that should look like:…

@COYirenkyi I second @Charles_Fike's recommendation using FIXED functions since they provide a higher level of flexibility when aggregating data. If you are interested in the average age by asset, start by creating a card that displays the Asset as a dimension so that your data is grouped by Asset. Then you can use this…

Maybe these details could be added in a second tab of the Excel sheet so that the data tab is easier to import back into Domo with the same original header row

@gandreou I agree that this can be confusing. If you change the datatype of this field from numeric to text in the dataset, that will prevent it from displaying that way

@alliu @JuanMiguel I just ran into the same thing but was able to resolve it by adding an optional group by field in the filter card

Commenting for more visibility

Good to know. I'm interested to hear what feedback you get from Support

@alliu Are you saving it on a dashboard that already has a Filter View applied? Or is it part of a drill path?

@Jbrorby You can achieve this using a Stacked Bar + Line chart without the Trellis Settings. In order to stack the bars, you will need to create two separate beast modes for True and False values: For true: sum(case when test = 'True' then lte_ibd_transaction.net_shipment_count else 0 end) For false: sum(case when test =…

@alliu Do you have a date range selected (Last week, today, etc)? That's the most common issue that I run into. Also if you have any PDP policies enabled on the dataset that could be impacting it as well, though it doesn't sound like that's the case if you're able to see all 60 values.

@alliu The filter values available to select are dependent on the other filters that are applied to the card/dashboard. For example if, you have filters for Region and Country, if you filter the region to North America then the Country filter will only show options for Canada, USA, and Mexico. If the values you want to see…

@ST_-Superman-_ This is great, I love this!

+1 to adding the Card ID column!

@mroker Yes, you can do this with a beast mode. To clarify, if you select the Jan01 filter do you want it to only include data for January 1 (i.e. 20 based on your example) or rows for all of January?