Forum Discussion

aledaros's avatar
aledaros
Frequent Visitor
4 years ago

Display only one data according to the view filter

Hi guys,

I need to display a data on the "card" view from an SQL database, I have already created the query and as a result I will have N rows, which for now are two (data in the table on the screen), how can I display a data on the card using object filters?

 

Need Help

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi aledaros 

     

    What is the data expected to be displayed in the card visual? You already expanded the filter field in the Filter pane. You can select either value to filter the card visual. 

     

    If you want to display the total of values in this column, you need to convert this column to Number type first, then select the card visual, in Fields box below visualizations, change its aggregation type to Sum. There are other aggregation types available there. 

     

    If this is not what you want, please explain the expected result with an example. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.