Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 2 tables namely: Masterlist and Production
Masterlist Fields: Country, Zone, FuelType, Name, OtherDetails
Production Fields: Date, Hr, Minute, Name, Production
How can I graph using sum or average the production per Month per Country?
Filters used: Year
I Tried using the following formulas but no graph was displayed because of undefined source
Dimension: Month(Date)
Measure: Avg({<Country = Country>} Production)
Any help please
If Name is the common field, it should be the association between the two tables, so just Avg(Production) with Dimension1 as Month(Date) and dimension2 as Country
If Name is the common field, it should be the association between the two tables, so just Avg(Production) with Dimension1 as Month(Date) and dimension2 as Country
Got it... Thanks for the idea.
Now I create 2 charts, Piechart and bar chart
How can I make the Piechart (slice:zone) as sort of filter of the bar chart? Where if I click a specific slice of the pie the bar chart will display the values for the zone selected in the piechart?
How can I make connection of the 2charts?
1. Pie chart as filter
2. if bar chart is clicked, pie chart will not be affected. Only piechart selection will affect the other graph like some sort of filter