Dashboarding issue

vsbwofficial
vsbwofficial
in User Experience

Hello everyone,

I need help in Dashboarding

I'm working for a manufacturing firm, where i'm having 6 machines that belong to 2 sections.

The End user wants to see daily production in terms of graphs/ charts

 Production (units)Production (units)Production (units)
 15-01-202016-01-202017-01-2020
M1506545
M2704550
M3808070
Section 1200190165
M5657045
M6458065
M8508045
Section 2160230155

 

End users want graph like this; If they change to section 2 it will show section 2 Machines data

 

Charts-1.PNG

 

But when i'm trying to do charting i'm getting the graph like this

 

Chart-2.PNG

 

So i used synchronize section's in the dashboard design part, as a result of this synchronizing process i'm getting chart like this

 

Chart-3.PNG 

 

But Endusers doesn't want to see section1 or section2 data in the graph, so what should i need to do in order to remove section's in the graph

 

Tagged:

Answers

  • anirudh
    anirudh

    Hi vsbwofficial!

     

    Create a boolean formatted line item in your module with the dimension of only the machines list. Set the summary method to None and the formula is TRUE and now apply this boolean as a filter (Data -> Filter) to your module and create a saved view (View -> Save As...)

     

    Publish the chart using this saved view and that should work!

     

    Also, ideally you should be having a properties/filter module dimensioned by the Machines list and the filter line item mentioned above should be parked there so as to centralise the filters used across the model.

     

    Regards,

    Anirudh

     

  • Harsha
    Harsha

    Hi,

     

    Hope this helps.

    Step 1:

    Harsha_D_0-1579238764540.png 

    add this filter and create saved view

    Harsha_D_4-1579238959717.png

     

     

    Step 2:

    Harsha_D_1-1579238764545.png

     

    Step 3:

    Harsha_D_3-1579238892736.png

     

     

    Thanks,

    Harsha

  • vsbwofficial
    vsbwofficial

    Thanks for the solution, worked very well.

     

    Regards 

    Sai Bharadwaj

  • vsbwofficial
    vsbwofficial
    Hey Harsh,
    Thanks for the solution
    Regards
    Sai Bharadwaj

Categories