Arthur Tomassen Posted May 13, 2022 Share Posted May 13, 2022 I have multiple KPI's in a dashboard connected to multiple data tables. When I mark an item in an master visualization werefore no data is available in the underlying data tables, the connected KPI shows all availble data. In the attachted examples, I have selected an location code in the mastervisualization. For this location there exits no data in the underlying VNB data table. As shown in the attachted example, the KPI shows "15 k" however. Instead of showing all data, I would like the KPI to show "0" or "empty", as there is no data connected to the marked item. Can anyone explain how to do this Link to comment Share on other sites More sharing options...
Gaia Paolini Posted May 20, 2022 Share Posted May 20, 2022 Testing it on two mocked up data tables, one with columns [A] and , the second with columns [A] and [C], where a table relationship exists between columns [A] in the two tables. I create a KPI that shows e.g. sum([C]) for the marked values of [A] in the master table, tiled by [A]. I have three options, depending on what I specify for (in the Data tab of the KPI settings); if I select if no items are marked in the master data visualization, show: empty visualization the KPI will be totally empty, showing just the title on top. If there is no data corresponding to the marked item, there is no data for the KPI to show, so I cannot think of a way to show a zero. Effectively it behaves as if no data were marked. If you do not tile by [A], then you would indeed get a KPI showing (Empty) when you select a value of [A] with no data in the second table, but then you lose the distinction between different values of [A] if more than one is selected (i.e. you get sum[C] over all selected values of [A]). Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now