The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

ryannelissa's avatar
ryannelissa
New Contributor III
2 years ago

BI Viewer

I am using the BI Viewer to display bars for actual data and a line for the budget/target. My issue is when I split the values into two groups the items in my legend are doubling. So I see each one ...
BI Viewer
dashboards
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

Calculated Fields are not filters. What you are doing there is just setting values to zero, but the data points (the records) are still there, hence they show up in legend.

What you want is to go in the Data tab on the ribbon, click "Edit filter", and set a filter to exclude the stuff you don't need. If that doesn't work, your filter is not set properly or you have records that match the filter and you don't realize it (or we have a bug, which is always possible, but the point is: what you want is filters, not calculated fields).

Can you try that and then post your filters if it doesn't work?

ryannelissa's avatar
ryannelissa
New Contributor III
2 years ago

That was what I tried initially but that didn't work so tried doing as the calculated field. Here is with the filters on the values, you can see below the 'hoover' legend looks good but the legend at the top still is including two of each. 

 

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    Can you show us the actual filter?

    If we can't see any problem there, then it becomes something you should file with Support.

    • ryannelissa's avatar
      ryannelissa
      New Contributor III
      2 years ago

       

       

      • JackLacava's avatar
        JackLacava
        Icon for OneStream Employee rankOneStream Employee
        2 years ago

        I would try to use

         

        Not Contains([UD3], 'Top')

         

        Just to check that it isn't an issue with hidden spaces or bugged equality.

        Also, right-click on the chart and select Inspect Data, making sure that there is no line for Top.

        If you do all of that and it still shows up, it could well be a defect you have to speak about with Support. I'm testing on v.7.4.1 and don't see that behavior.