1 Reply Latest reply on Aug 14, 2019 4:32 AM by Diego Parker

    Assigning Ids to Measure Names

    Grishma Achrekar
    Grishma Achrekar Aug 14, 2019 3:41 AM

      Hi Community,

      My visualization should look like below

      ID
      		Measure NameCode
      		Measure Value
      1# of Accounts 28
      2Total Inventory54
      3Total Bill13
      4Daily Inventory9
      5Daily Bill35

       

      In this, Measure Names are calculated fields each having some logic. I have to add ID which will be a sequential number and Code which will be some identifier for the fields.

      Measure Value is the result of each measure name.

      Both ID and Code are not present in the datasource, which is a SQL table. I don't have rights to add anything in SQL table.

       

      Could you please suggest how can i add both these fields to my datasource.

       

      Thanks,

      Grishma