Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
3 months ago

Dynamically Filter Line Chart with Formula Queries (or open to better ideas to do this)

Hi everyone, I had a user request a line chart that is filterable by contact showing the Total Opportunities Created as one line and another line showing the total revenue generated. The idea is the ...
formula query
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 months ago

Well, I gather from your question that your chart is simply a report of opportunities. So it's just filtering which opportunities will show.

  • IvanWeiss's avatar
    IvanWeiss
    Qrew Captain
    3 months ago

    No its a cumulative line chart.  So I want to show one line as total opportunities and another line as total invoices.  Cumulative by each month comparative to prior years