2.3.11.2 Create Line Chart Saved View

AyushT22
AyushT22
in Modeling

Hi, I can create a filter here in terms of months but I am not getting data for the line chart, where am I going wrong? Please help me on this.

Screenshot 2024-06-25 112905.png

Answers

  • jagadishdash
    jagadishdash

    @AyushT22 Hey, As per your screenshot, change the page selector from ALL products to a child item and it'll visible.

  • AyushT22
    AyushT22

    Hi @jagadishdash I did try with that but then also I am not able to get any data

    Screenshot 2024-06-25 113418.png

  • Ashutosh
    Ashutosh

    Make summary as sum . u will get data

  • PulkitChawla
    PulkitChawla

    @AyushT22 - Make sure to keep the summary as sum to see the data at the Top/Parent level.

  • jagadishdash
    jagadishdash

    @AyushT22 In blueprint view, toggle the summary from None to SUM.

  • Anurag0911
    Anurag0911

    @AyushT22 The formula is at week level,

    image.png

    And you are using Months. Can you take a look at that and if not working share the Blueprint view. Thanks.

  • AyushT22
    AyushT22

    Thank you everyone for your suggestions it worked.

  • Leticiaynn
    Leticiaynn

    I thought a formula would be necessary to display this data properly.

    geometry dash breeze

  • arvelgeraldmalabanan
    arvelgeraldmalabanan

    Hi,

    Anyone can assist me on how to Add a filter to this module to display Months only?

    image.png

    Thanks in advance

  • seymatas1
    seymatas1

    Create a system module with month dimension.

    Create a Boolean line item with a formula TRUE.

    Turn off summaries.

    image.png
    image.png

    Use this line item as a filter for your module.

    I hope this helps.

    Seyma 🌷🙂

  • arvelgeraldmalabanan
    arvelgeraldmalabanan
    edited December 5

    @seymatas1 Thank you for inputs, however, I'm not able to proceed to display Months only.

    Any ide what will be the selection to display months only? Weeks are still display in my modules.

    image.png
    image.png

    I'm looking at below output in a per month.

    image.png

  • seymatas1
    seymatas1
    1. Weekly module without filter:
    image.png

    2. Create a system module with month dimension.

    image.png

    image.png

    3. Apply the filter to the time dimension of your weekly module:

    image.png

    4. Filter is working.

    image.png

  • seymatas1
    seymatas1

    You can also consider creating a monthly module instead of applying a filter. A new module will increase your cell count but a filter will affect performance. There is a tradeoff and I usually prefer to increase size instead of affecting performance.

Categories