Forum Discussion

EnochS's avatar
EnochS
Advocate II
9 years ago
Solved

Line Chart Glitch

Hello,   For some reason my report is glitching out i'm not sure what to do about it.. One of the random dates is out of place..    If you can help me figure this one out, it would be muc...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    EnochS

    Hi, maybe change Week to Type Number instead of Text

CahabaData's avatar
CahabaData
Memorable Member
9 years ago

I see the data in the (CC) column/field becomes blank....  I think that may be your issue

EnochS's avatar
EnochS
Advocate II
9 years ago

CahabaData,

 

Thanks for the post. Unfortunately, I need this to be a null value since there is nothing written yet. The thing is, it was working fine earlier. Before, the "Date" field would not allow me to switch to a hierarchy field until i saved it and restarted the application. But then this happened.. 

 

When I press "Sort By Goal" it is fixed, but only works properly when the graph is in reverse order..

 

 

 

 

 

 

 

  • CahabaData's avatar
    CahabaData
    Memorable Member
    9 years ago

    if 0, rather than null, would result in the correct visual - - you don't have to make the change permanent to the original column.  You can create a measure or a new calculated column just for the purpose to use it in the visual without contaminating the actual column/field itself.....

     

    this is working at the data level

     

    since you note that it worked before but not currently - -check out the visual level design options - as I don't have desktop opened at the moment I'm not sure - but in your visual design pane on right side - check the options for that field - possibly there is an ability at the visual level to deal with nulls differently.....

    • EnochS's avatar
      EnochS
      Advocate II
      9 years ago

      Its working now.. for some reason...

       

      I just added an index number to it, which i've done before already with the same issue, and then this time it decided to work..

       

      Seems like either bad design on my part or a software glitch...

       

       

       

      BUT.. now the bottom X-Axis Labels do not concatinate the year like before.. It's not really as much of an issue if the graph is correct... although it would be nice to have this glitched resolved..