Not working "show all" at row settings

川上 まりえ
川上 まりえ Active Partner
Second Anniversary Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board First Comment
edited November 2022 in Platform

Hi there,

I'm wondering if we can't use data view settings "detail by" and row settings "show all" at the same time.
If I set "detail by",  it shows all data(zero) although setting "show all" .
I want to hide row  having zero. Could anyone help me solve this?


Kind regards,
Marie

image

image

------------------------------
Marie Kawakami
Developer
MRI VALUE CONSULTING AND SOLUTIONS CO., LTD.
Japan
------------------------------

Answers

  • Samir Jones
    Samir Jones Active Partner, Community Captain
    Third Anniversary 100 Up Votes 25 Likes 10 Comments
    edited January 2023
    Hi,

    If you haven't solved it, here's a workaround to hide empty rows.

    1. Create an algorithm block (block 'b' in screenshot) that checks if the source cube (block 'a' in screenshot) has values. Algorithm can look like this "if(a<>0,1,0)". This should give you '1' in the block's column for all the rows that has values.
    2. Go to Filter and set filtering on that block with min '1' and max '1'.
    3. If it seems to work, you can hide the algorithm block.


    image


    image

    ------------------------------
    Samir Jones
    Developer
    Attollo AB
    Sweden
    ------------------------------
    -------------------------------------------
  • Etienne CAUSSE
    Etienne CAUSSE Customer
    Fourth Anniversary 250 Up Votes 100 Comments 100 Likes
    edited January 2023
    As "Detail by" works on column, you might need to remove "show all" from the column properties to hide zeroes and not from rows properties.-------------------------------------------

Categories