Forum Discussion

Qualube's avatar
Qualube
Helper II
7 years ago
Solved

why does value in visualisation prefix first

Hi   This might be a strange and easy question to answer but I have looked extensively on the community and the web and can't seem to find a solution to why the values in a visualisation prefic wit...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Qualube,

     

    You need to create a calculated measure not a column, then when you add it to your table visual you will not have this options.

     

    Check the image below and a simple file attach with the example.

     

    Regards,

    MFelix

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

What visualization are you trying to use here?

 

It seems that you want to get the data for the earliest date, which is just one value. And the CUSTACCOUNT values or data have several values relative to the earliest date, but you could only display one value, based on what I got from the information you provided. With that, by default, the aggregation for the CUSTACCOUNT data and other data with several values is FIRST. If you want to show all the CUSTACCOUNT data for the earliest date, try using different visuals or charts.

 

I hope this helps.