Displaying a series of charts

[fvarlet]

Hello all,

I'm creating a dashboard with a series of barcharts, each barchart showing the weekly evolution of a value for a specific project (i.e. one barchart per project).

These charts should only be displayed for the projects selected by the user (all projects are displayed if no project is filtered)

For my data, I have 3 fields : [ProjectName], [Week], and [MyValue].

I've tried the following formula :

=Sum({<ProjectName={$(=SubField(Concat(DISTINCT ProjectName, '|'), '|', 1))}>} MyValue)

But it doesn't work

I know that SubField(Concat(DISTINCT ProjectName, '|'), '|', 1) give me the first project and that I have data for this project: my barchart displays data if I change this formula by Sum({<ProjectName={'Name of the project'}>} [MyValue]))

How could I change my formula to make it work?

[sunny_talwar · Accepted solution]

Try this

=Sum({<ProjectName = {"$(=SubField(Concat(DISTINCT ProjectName, '|'), '|', 1))"}>} MyValue)

[fvarlet]

That works

Thanks a lot!

[sunny_talwar]

Awesome, but I wonder how is your response (saying that my response worked) constitute as a solution? 🙂

[fvarlet]

Oups, wrong button

[sunny_talwar]

🙂 Thanks for fixing it