Forum Discussion

maibacherstr's avatar
maibacherstr
Icon for Helper III rankHelper III
3 years ago

Set the Default View of a Visual

Hello, trying to solve the following problem, trying to think outside the box and welcome all suggestions...

 

On my report page, I have a line graph that's easy to misinterpret *until* the user selects another visualization on the screen first (it's a table, so the user would click a row). Once the table visual is selected, then the graph adjusts to a realistic range of values, and only then do the results actually make sense. My customer is unhappy about this, but I don't have any great suggestions on how to set some kind of default view on the graph. I will say I'm pretty good with bookmarks but can't solve the puzzle in my head using bookmarks alone. Bottom line: I need to publish the report in such a way that the user either (1) won't be able to view the line graph until a table row is selected, or (2) the table is selected by default when the page loads.

 

Or (3) another suggestion...

 

Many thanks if you can share any ideas.

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • vicky_'s avatar
    vicky_
    Icon for Super User rankSuper User
    3 years ago

    Is there some way you can make the measure in the line graph not show anything until a row in the table is selected with the HASONEVALUE()?

    I think something like this could work:

    LineGraphMeasure = IF(HASONEVALUE([Table Column]), 
    // calculations here, 
   BLANK()
)

    And you can probably change the line graph title to a measure like: 

    LineGraphTitle = IF(HASONEVALUE([Table Column]), 
    "Showing Details for " & SELECTEDVALUE([Table Column]), 
   "Please select a row from Table Name"
)

    in case they get confused on why the line graph isn't showing.

     

    The other way is to publish the report with a default selection in the table, and then uncheck the persisten filters in the report settings. 

     

    • maibacherstr's avatar
      maibacherstr
      Icon for Helper III rankHelper III
      3 years ago

      Thanks! This is obviously a great start, I just haven't been able to translate it yet. Sorry I just need to pin this down more specifically...

      LineGraphMeasure = IF(HASONEVALUE([Table Column]), 
    // calculations here, 
   BLANK()
)

      Between my line graph and table visual, I think [Table Column] would basically be the title column used in the table visual -- is that correct?

      As for the 'calculation' I'm even more lost.

      At the end I'll add this measure as a filter on the line graph.

       

      I would tremendously appreciate a little more detail, thanks again.

  • maibacherstr's avatar
    maibacherstr
    Icon for Helper III rankHelper III
    3 years ago

    Are there any further suggestions on how to accomplish this? Deadline is right around the corner.

     

    Thank you.