Highlighted
Contributor

Dashboarding issue

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

 

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

Re: Dashboarding issue

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

 

Highlighted
Contributor

Re: Dashboarding issue

Thanks for the solution, worked very well.

 

Regards 

Sai Bharadwaj

Highlighted
Frequent Contributor

Re: Dashboarding issue

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

Highlighted
Contributor

Re: Dashboarding issue

Hey Harsh,
Thanks for the solution
Regards
Sai Bharadwaj