MichelleH Coach

@Domomon It sounds like you could use variables for this, though that likely depends on the details of your specific use case.

@domoexpert I'd suggest using a Variance Trendline card under the Period Over Period chart types, though note that these types of charts do not offer much customization

@dkonig If you are using MagicETL you can use the Split Column tile to separate a column based on a particular delimiter, in this case the pipe character. You can also do this using the SPLIT_PART function in a formula tile. Edit: @colemenwilson beat me to it!

@SayyedHussain If you want to only include months to date you can add a beast mode filter like the one below: case when MONTH(`Date`) <= MONTH(CURRENT_DATE()) then 'Include' else 'Exclude' end

@SayyedHussain You can accomplish this with a pivot table card with MONTHNAME(`Date`) and YEAR(`Date`) as your columns and rows, respectively, and `Metric` as your values. You can also use MONTH(`Date`) to sort your months chronologically

You could use a beast mode like the one below to sum the file collected if the date field is one or two days before today: sum(case when DATE(`local_collect_date_time`) = CURRENT_DATE() - 1 then `FilesCollected` else 0 end) - sum(case when DATE(`local_collect_date_time`) = CURRENT_DATE() - 2 then `FilesCollected` else 0…

@Zel Can you please share some example data to demonstrate the behavior you want to see?

@MThebeau I would recommend restructuring your formula so that @colemenwilson's case statement resides within the denominator sum to ensure that all your conditions have the same granularity. Also MagicETL actually has a function in formula editor called DATE_WORKING_DIFF that calculates number of working days between two…

@Zel Start with this KB Article to point you in the right direction!

@Zel It sounds like you will need to set up a variable control for Customer (instead of a filter card) so that you can add conditions to your case statement based on the selected value.

@Zel Yes, you can create a beast mode filter to exclude the current day like this: case when `Date` = CURRENT_DATE() then 'Exclude' else 'Include' end

@Stucker Does it still have the same behavior if you remove the sorting?

@Stucker Can you please share your beast modes and sorting?

@Stucker Does your table have subtotals or any aggregated columns?

@Jordantm Have the credentials for the account changed? If so, can you confirm that that Box account has the same access as the previous one?

@Aaron_w_SMG Have you validated that all there are records in your data that meet the criteria for all the filters?

@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.