Forum Discussion

Nelson_Marquez's avatar
Nelson_Marquez
Regular Visitor
5 years ago

Streamline visualization table

Hi community.   I) I have a visualization table built with two tables/queries. It's about the flow of some products, showing the possible origins or load locations for a given destination or unloa...
Need Help
LP2803's avatar
LP2803
Responsive Resident
5 years ago

Hi,

 

for your first question, I see that the "R2 Volume total (m3)" is what making the table to repeat the values.

 

you may need to aggregate (sum/average) this column to not to get the repeatations.

 

for the second question, could you please elaborate more what are you trying to compare?

Nelson_Marquez's avatar
Nelson_Marquez
Regular Visitor
5 years ago

LP2803 thanks for your response.

 

Even if I remove that field I still have the same issue.

 

I'd like the source fields to be subjacent just to the destination field, not to the other source field.

 

Thanks and regards

  • LP2803's avatar
    LP2803
    Responsive Resident
    5 years ago

    For your second query,  the below is what you are trying to achieve?

     

    • Nelson_Marquez's avatar
      Nelson_Marquez
      Regular Visitor
      5 years ago

      That would be the ideal, however I'm building my bisualization table with two different source tables. I guess we can't create measures in the visualization tables (Report tab), right?

      • LP2803's avatar
        LP2803
        Responsive Resident
        5 years ago

        You can create measures in Report Tab by clicking on the ... eclipses next to the table name and clicking on "New Measure" or by selecting "New Measure" from Home tab.

    • LP2803's avatar
      LP2803
      Responsive Resident
      5 years ago

      Ok. I created a measure to see if the Source1 and 2 are similar and then applied that as a filter as below.

       

      Let me know if this answers your requirement.