Dashboarding issue

vsbwofficial

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-2020	16-01-2020	17-01-2020
M1	50	65	45
M2	70	45	50
M3	80	80	70
Section 1	200	190	165
M5	65	70	45
M6	45	80	65
M8	50	80	45
Section 2	160	230	155

 

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

 

 

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

 

 

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

 

 

 

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

 

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