Help please!

[Marco_Bonucci]

Hi, how could I filter chart datas by a column on another table?

[shahappsheet]

Please be specific and clearly explain the issues. It sounds simple but need to understand the problem first.

[Marco_Bonucci]

Hi, I have a chart based on a VC that counts how may times a certain term appears in a table. In this table every row has a Date and I need to Filter chart datas by the dates associated to the terms. For example, I have to count how many times a term appears in a mont

[shahappsheet]

Still I am not really clear. However, so far I could understand, you have to use an additional table to contain the filtering condition data then the main table can be sliced to draw the Chart. It is one of the ways.

[Marco_Bonucci]

I think I didn’t understand

[Cale_QREW · Accepted solution]

Hey Marco_Bounucci,

I might not be fully understanding what you are asking, but it kind of sounds like you are looking for a dynamic dashboard where you can filter based on certain terms?

Take a look at the link to a YouTube webinar I have below.

Link: Dynamic Dashboards - AppSheet - YouTube

I started the video at 46:05 to show the end product to see if that is what you are looking for. If it is, feel free to watch the whole video to learn how to do it. If not, let me know and I’ll do my best to respond!

Have a good one!

[mateo]

QREW_Cale:

Dynamic Dashboards - AppSheet - YouTube

THIS IS AWESOME! I have been looking for that quite a long time but didn’t know how to call it in english in order to find some information. Thank you for this message @QREW_Cale !

[Marco_Bonucci]

That’s really hard!

I think I could just add something here. This is in the second sheet. How could I make it count JUST IF terms are in the current month?

[Aurelien]

You may need to add a condition in the FILTER part.
So that could be something like:

COUNT(
  FILTER("PRIMA NOTA",
    AND(
      IN([_THISROW],[Intervento],
      MONTH(TODAY())=MONTH([dateColumn])
    )
  )
)