Skip to main content

Hi Tableau Community! I am looking to create a License Matrix for my org. We are currently going through a merger and acquisition, and we want to do an inventory of both environments.  

I have data prepped through Tableau Prep. Attached Excel file is the dummy data of the Output. 

I have also attached the Tableau .twbx of a WIP file.

 

Below is the License Matrix we want to create (numbers are not accurate. This is just a mock of what we want to recreate).

How to Create a Matrix?

 

Much appreciate the help! Any tips would be great. Please note I can use Tableau Prep to massage the data if required. 

 

#Tableau Desktop & Web Authoring  #Flow  #Reports & Dashboards

5 件の回答
  1. 10月2日 21:35

    I'm glad you're figuring this out. Your data and/or LOD calc needs to be cleaned up as it is not returning a single value per user (see image below). But to fix your user counts you need to change the CNT(User) on the License Matrix sheet to CNTD(User) to count distinct users.I'm glad you're figuring this out. Your data and/or LOD calc needs to be cleaned up as it is not returning a single value per user (see image below).

     

    image.png

     

     

0/9000