Forum Discussion
Dynamic goal line in visualization
I am trying to create visualizations for our shipping department which show the summed value of our shipments each month or each week over any given timeline, but want to have the annual plan for eac...
Greg_Deckler
Community Champion
Community ChampionI would use a Line and clustered column chart visualization with your goals as the line or column and the actuals as the other.
- Thanks for the reply! What I’m stuck with is that my actuals table is linked to an OBDC that updates itself, and I don’t know how to connect a table I created with the plan in it, and I don’t know how to create a visual that uses more than one unrelated table. Kind of like in excel how I could reference a completely separate set of info on the same chart by using a secondary axis? Can you help me with how I could do that?
- Can you recommend an alternate solution? Or can you help me understand how to connect a new table with the static numbers to the ODBC connected table? How would I establish a relationship? Would I have to build a calculated field in the connected table to calculate the month of the dated field and then link those?
