Drill down on metric counts

[Deleted User]

I have several tables that are counting the presence of a date in a given field. Our end users are able to click on the grouping to see all loans in that group with one of the date fields present, but when they click on one of the count cells it returns nothing. I think conceptually I understand why this happens (there are no values in the data where a date field equals the value being selected, i.e. Date Y = 22 in the attachment below), but is there any way to give users the ability to select just the particular population they want to see?  In the aforementioned example, can the cards be built so that a user could click on, for example, "33" and only see the 33 loans in Group C with a Date Y value?

Jarvis

Hey Edward, 

 

You should be able to accomplish this by using case statements via Beast Mode. If something is not working as it should, then I would advise for you to reach out to your Domo account team. Unfortunately, I was not able to view your attachment, however, case statements should give you what you're looking for. 

 

It may also be useful to check out the below article:

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/02Beast_Mode_Functions_Reference_Guide#Logical_functions

 

- Jarvis