Forum Discussion

EdgarasR1's avatar
EdgarasR1
Frequent Visitor
4 years ago

Is it possible to connect visuals without formulas?

Hi, community,    Need some help and for you guys I think it's going to be an easy one: So, I have two table visuals and I want them to merge into one. In the future it's going to more tables whic...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

EdgarasR1 , You should be able to put data together from common together. If employees and all these measures coming same data table, you can show them together. If they are from different tables, then you need need to create common dimension like employee two view things together

EdgarasR1's avatar
EdgarasR1
Frequent Visitor
4 years ago

Okey, then the second question would be how to create 2 different measures by these criteria:

  • Measure1DebtStagesActive = IF Debt stage = "Pre trial" or "To law" then SUM (Active debts amount)
  • Measure2DebtStagesSelected = IF Debt stage = "Recovery" or "Pre-trial" or "To law" then SUM (Inflows)

Then I will put them in one table's visual and information will be correct?

 

Hope I have asked clearly.