Forum Discussion

aburling1989's avatar
aburling1989
Frequent Visitor
3 years ago
Solved

Continuous Categorical Line Chart

Hi,

 

I was wondering if it's possible to set a continuous categorical value on a line chart? As you can see in the below screenshot the data points are disjointed.

 

I'm aware this can be set to 'Date' which would solve this, however, I need the date specifically in "QQ YYYY" format and everytime I try and conert the date to this format it automatically switches it back to the category variable.

 

I've tried some custom visuals which sort of worked however each had their own limitations (such as not being able to include markers). Maybe there's a much simpler solution that I'm completely overlooking. Appreciate any help anyone can offer here.

 

 

Thanks!

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hello aburling1989 ,
    it's very strange, I tested my reports and the continuous axis worked on all types of fields, including texts.

    Try to create a hierarchical X-axis, first, put a year, and then place the quarters underneath it in the required format.

     

    Please provide an example if it doesn't work.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly 

5 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

    Hello aburling1989 ,
    it's very strange, I tested my reports and the continuous axis worked on all types of fields, including texts.

    Try to create a hierarchical X-axis, first, put a year, and then place the quarters underneath it in the required format.

     

    Please provide an example if it doesn't work.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly 

  • aburling1989's avatar
    aburling1989
    Frequent Visitor
    3 years ago

    Hi Rita,

     

    Many thanks for the response. Unfortunately this option doesn't work. If I just add the year, I get the option to set the type as 'Continuous', however as soon as I add quarter into the hierarchy this option is no longer available and it auto sets to categorical.

     

    The closest I've been able to get is by using the 'Line Chart by Akvelon 2.0.1' custom visual, which supports a continuous line on categorical information (example below). However, for some strange reason this visual does not update if there is only 1 selection available in the legend (no idea why) so I'm trying to find a way to stick to the standard line chart.

     

    Thanks,

    Ashley