Reply
Anonymous
Posts: 0
Accepted Solution

When dragging a field in card it is populating as "first <Field name>" automatically.

Hi, 

I have a column as below:

UW_New_Cond = IF(OR((COUNT(Encompass_Loan[Submitted_UW_Date]) <= 3 && Encompass_Loan[Submitted_UW_Date]= Encompass_Loan[Last_Weekday]-1), (COUNT(Encompass_Loan[Submitted_UW_Date]) >= 1 && Encompass_Loan[Submitted_UW_Date]= Encompass_Loan[Last_Weekday])), 1,0)

 

and this column is used in below column

UW_New_Cond_Final = IF(AND(Encompass_Loan[Cond_Approval_Date] <> BLANK(), Encompass_Loan[UW_New_Cond]=1), "1 Day", "2 Day")

 

My problem is when I am dragging field "UW_New_Cond_Final" is showing as "First UW_New_Cond_Final".

Although in Default Summarization, Don't summarize is selected.

ANd due to this problem I am getting Blank as the value instead of getting "1 day".

Please see below snapshot:

Capture.JPG

Please help.

 

 


Accepted Solutions
Community Support Team
Posts: 7,441
Registered: ‎08-14-2016

Re: When dragging a field in card it is populating as "first <Field name>" automatic

Hi @Anonymous,

 

AFAIK, card visual not support display item list from one field, it will try to summarize your field, if you want to display all value from data filed, please use multi-row card visual to instead.

 

In addition, you can also create a table visual with category column and 'UW_New_Cond_Final' column.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post


All Replies
Community Support Team
Posts: 7,441
Registered: ‎08-14-2016

Re: When dragging a field in card it is populating as "first <Field name>" automatic

Hi @Anonymous,

 

AFAIK, card visual not support display item list from one field, it will try to summarize your field, if you want to display all value from data filed, please use multi-row card visual to instead.

 

In addition, you can also create a table visual with category column and 'UW_New_Cond_Final' column.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |