MichelleH Coach

@Aaron_w_SMG Do your cards already have a timeframe set in the Date Range settings (i.e. Year to Date)?

@Aaron_w_SMG Is the Year filter based on the IncidentDateTime or is it derived from a different date field? Is it possible that there are conflicting date filters in your cards that result in all the data being filtered out?

I agree with this. Generally we give social logins because there is a reason we don't want them to have full access. If someone needs a full license that request is handled through other channels, so we don't have a need for this button.

@Vineeth I don't think there is a way to make those Domostats datasets update more than once a day on a schedule. You can check with your CSM whether there is a way to make those datasets update more frequently if you need them to be more real time.

@dkonig It depends on the connector. The ones that support partitioning will have a "merge" method which uses partitions. If the connector you have been using does not have the merge method, there may be another version of the connector that does. When paired with MagicETL subset processing (which I assume is the beta you…

@Aaron_Zheng What if you used an Overlay Bar Chart with a beast mode for each series/color? Assuming you are currently using a single Y axis value with a dimension in the chart series, you can actually break each color bar into its own beast mode field. For example, the blue bar could be something like this: sum(case when…

@marcel_luthi You're right, it does seem like there should be a setting for that. It sounds like a good candidate for the ideas exchange.

@UncleLeoTheDad I believe you can set it to show one dashboard layout at a time, but not necessarily the entire dashboard.

@UncleLeoTheDad Have you tried making a Slideshow of your dashboards? They're really handy for cycling through multiple cards on large screens and making it easier to read

@marcel_luthi What if you used the Unpivot ETL tile to collapse the "Name" field so that you can use a single value field and add Name as the first column field?

@Vineeth You can monitor the licenses used using the People DomoStats Dataset (filtering out the Social Role). As for the datasets the DomoStats dataset should give you the information you need, but it's possible that it doesn't match exactly because that dataset usually only refreshes once a day.

@Aaron_Zheng Are there additional metrics in addition to 1, 2, and 3? If not, you could just remove Metric 3 since the grey bar will show the sum of Metric 1 and Metric 2

@Aaron_Zheng Have you considered the Nested Bar chart type?

@Chris_Wolman The 4/15/2023 row would be excluded with those filters in all of these scenarios. I guess I'm still not clear on what questions you are trying to answer with this data.

I agree with @marcel_luthi I think a flex table or some other time series chart would be better for visualizing this.

@Chris_Wolman Can you provide some more information about the business case for why the starting inventory for an item that wasn't available until 5/5 would not be 0 for the period between 5/1 and 5/15?

@Chris_Wolman Typically, aggregation functions should be outside of the entire case statement in order to return a single row. However in this case the min date is also causing an issue because you would have an aggregate inside an aggregate (min inside a sum). Based on your use case, I would suggest setting up two date…

@user029082 In that case I would recommend reaching out directly to Andrea or the beta team to help you with the your specific use cases.

@user03163 You can create a beast mode like the one below that you can use a as a filter. Using the LIKE operator with the % wildcard will allow you to exclude any records that contain the specified text. In this case searching for "Dup" will also return "Duplicate". case when `Closed Description` like '%SPAM%' then…

@user029082 I suggest checking out this recording from one of the previous Lunch & Learn streams. There are some great examples and use cases for partitioning!

@MayaU_01 Can you please share some more information about your data and what the beast mode calculation represents?

@muahmmad_zaidi You can set up your % Change beast mode to calculate based off of the sums of your two fields like this: (sum(`Field1`) - sum(`Field2`))/sum(`Field2`)

I agree with @MarkSnodgrass's suggestion for the single value card. If you want to show the First Week and Second Week in the same card, then I would suggest adding the week 2 filtering inside each sum using case statements: ((sum(Case WHEN `Survey Type` = '2 Week Survey' THEN `Promoter Count` end) - sum(Case WHEN `Survey…

@MThebeau Can you please share your beast mode code so we can look into it further?

@user17188 It sounds like you're describing Smart Text. Is there something you're not able to do with this?

I agree. It would be helpful to be able to see "Direct Impact" vs "Total Impact" as separate columns in the DomoStats/Governance datasets. In our case we could use this information to more quickly prioritize dataset cleanup/migration projects.

@mroker It depends on how you are pulling the data, but most connectors should have an option to change the update method from "Replace" to "Append" so it simply adds new rows to the existing data.

@Josh_Godec123 It looks like "CARL BEAN MEN'S WELLNESS CENTER" is not specified in your case statement, so it would fall into your ELSE 0 bucket. I second @MarkSnodgrass's suggestion of using the LIKE operator to capture patterns rather than exact values.

@ccc123 Try using filter cards instead since they will adjust based off of other filters

@ccc123 Are you using a filter card or the dashboard filters on the top panel (near filter views)? Filter cards react to other filters, whereas the dashboard filters do not.