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

    Assigning Ids to Measure Names

    Grishma Achrekar

      Hi Community,

      My visualization should look like below

      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.