Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Constant Line loses its format

Hi,

I'm using a constant line that is dynamically calculated to represent the average state performance across all entities. As per the screenshot below, the measure uses a custom format to display duration in Days/Hours format and all works well until one of the quadrants doesn't have an entity to display in it and then the constant line displays but without its custom format.

 

Any ideas on why it loses its format? Also, given there's no entity to report on based upon the selection why is the constant line displaying? If I convert the 4 visuals to a single visual with the region as a small multiple, the constant line behaves that way.

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks for your help on this. I eventually opted for displaying the constant line when the Countrows(HubTable) > 0.  

7 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion

    Can I ask what it is you are expecting it to do when there is no data?  to be blank?  A little unsure of what you are asking can you explain what you expect to happen in the problematic quadrant.

    • Anonymous's avatar
      Anonymous
      Not applicable

      My preference would be for it to be blank as this is the behaviour when using small multiples.

      • vanessafvg's avatar
        vanessafvg
        Community Champion

        can you not filter the blank  section out? its actually really hard to answer this question with the limited information you have given, i do not know how your data is modelled, i also do not know what your objective with the data is.   If you need a more detailed response you will need to give more information like

        what your data looks like the sample data ie the model and a sample to understand why it is being displayed if no data is showing

        what requirement you are trying to solve

        assuming you are using the y axis constant line?