Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Card showing current week value (text) only

I have a table that contains five columns shown below:

 

WeekCodeDescriptionSummary of IssueContact
07-Nov-22HH1Complaint received regarding service issuesSummary goes hereJohn
14-Nov-22HH2Complaint received regarding billing issueSummary goes hereMary

 

I want to have a card on my dashboard that displays the description of the issue for the given week. So this week, the description is "complaint received regarding service issues". I don't want to use slicers, I just want the card to show according to description for that week. 

2 Replies

  • The card will only show 1 item at a time unless you do concat.
    So if you add Description Column to the card it will either pick the 1st or the last (you can select that on the visulization pane).

    Do you have a filter for the current or given week?
    Maybe you can create column that says "isCurrentWeek" and
    put those filter in the filterpane so it will be hidden.

     

    Thanks

    Christian

    • Anonymous's avatar
      Anonymous
      Not applicable

      ChristianDGreat  Yes, I am only looking for the description to show. I can add another card to show the other info if needed. If adding a column as you suggested should work I am okay to do that as well. How would I do that