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 much appreciated..

6 Replies

  • CahabaData's avatar
    CahabaData
    Memorable Member

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

    • EnochS's avatar
      EnochS
      Advocate II

      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

        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.....