Forum Discussion

LFM's avatar
LFM
Helper III
1 year ago
Solved

Problem with plotting all values on line graph

Hello. I have a dataset with 8760 rows. Im made a duration curve for spot on the y- axis and percent on the x- axis. When Im plotting the values into a line graph, it only shows the first listed valu...
Need Help
Show and Tell
  • nandic's avatar
    nandic
    1 year ago

    LFM is your field Percentage of numeric or text data type?
    If it is numeric, it should give you option to choose continuos x axis type. If it is text, it will not show you this option.
    If it needs to be text, i would go with adding additional column where you would group values.
    But i suggest to change data type to numeric and then format it as percentage. It will be cleaner.

nandic's avatar
nandic
Resident Rockstar
1 year ago

LFM if percent value is to be shown on x axis and you would like to see all at once (without scrolling), select visual > go to formatting options > select X-axis > select Type = Continuos.

 


Alternative, add new column where you will create custom groups and then show these groups instead of each value.
Example, if percentage < 0.10, 10, if less then 0.20 then 20..

Cheers,
Nemanja