Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am creating a bar chart which displays the occupants ratio of total employees percentage by the year.
I used the field "Year" as a dimension, and the expression is the calculated percentage already done in the data base.
As you can see below, the chart displays the year with lot of zeros:
How can i set the Year as integer??
Thanks
in number tab
or in the load script
floor(Year) as Year
or a dimension like
=Num(Year,'0')
or try
Subfield(Year,'.',1)
or
mid(Year,1,4)
or
left(Year,4)
regards
Deara Rodrigo,
Kindly find attached file, I hope you are looking for that one solution.
Kind regards,
Ishfaque Ahmed