Forum Discussion

Crav888's avatar
Crav888
Frequent Visitor
8 years ago
Solved

Build custom list for table

Hi,

 

I want to change the names in the Legend to some custom names. How do I do that? The data is not available in the PPI-DCL spreadsheet.

 

Furthermore, the data will be refreshed every month, so the solution needs to take that into account.

 

I look forward to read your response.

 

Thank you in advance, much appreciated.

 

 

Need Help
  • tjd's avatar
    tjd
    8 years ago

    If your data is being imported via spreadsheets, you can do it by transforming ("Replace Values") in the Query Editor.  It will persist throughout your data refreshes as long as the original names in the spreadsheet do not change.

2 Replies

  • tjd's avatar
    tjd
    Impactful Individual
    8 years ago

    If your data is being imported via spreadsheets, you can do it by transforming ("Replace Values") in the Query Editor.  It will persist throughout your data refreshes as long as the original names in the spreadsheet do not change.

    • Crav888's avatar
      Crav888
      Frequent Visitor
      8 years ago

      Hi tjd,

       

      Thank you so much for your help. It was way easier than I expected.

       

      Have a nice day!