topic Set analysis for a bar chart in App Development

Set analysis for a bar chart

maarcus_smith — Thu, 25 Nov 2021 15:32:45 GMT

hi experts,

i have a formula that i need to include another set analysis expression in it for 2 types of roles.

this is the current expression:

sum({<Flag={"1"}>} [Total Hours])
/
sum({<[Type]=,Flag={"1"}>} total <Week,Year> [SumOfSch Hrs])

i want to update the expression for both sums so that it only takes in values from a field named "Stream" and a value within that field named "new".

i will then put in the same expression again but this time look for a value named "old" in the field "Stream" .

my aim here is to have 2 separate bar charts in for each of my x axis months.

is this possible?

thanks

Re: Set analysis for a bar chart

Or — Thu, 25 Nov 2021 16:01:21 GMT

I'm not sure what you mean by "my aim here is to have 2 separate bar charts in for each of my x axis months.", but there should be no problem adding an extra set analysis into your existing formulas (just add , Stream = {"new"} at the end of the set analysis and likewise for old) and creating one formula each for new and old.

Re: Set analysis for a bar chart

maarcus_smith — Thu, 25 Nov 2021 20:47:35 GMT

hi @Or

sorry i should have said that when i put it in the expression editor, it says expression ok but no data is coming up.

i know data is there as when i would select a value in the "stream" field, it changes the chart.

my expression =

sum({<Flag={"1"} ,[Stream]={'Old'}>} [Total Hours])
/
sum({<[Type]=,Flag={"1"}, [Type]={'Old'}>} total <Week,Year> [SumOfSch Hrs])

any idea where im going wrong?

Re: Set analysis for a bar chart

maarcus_smith — Fri, 26 Nov 2021 08:52:26 GMT

sorry i should have said that when i put it in the expression editor, it says expression ok but no data is coming up.

i know data is there as when i would select a value in the "stream" field, it changes the chart.

my expression =

sum({<Flag={"1"} ,[Stream]={'Old'}>} [Total Hours])
/
sum({<[Type]=,Flag={"1"}, [Type]={'Old'}>} total <Week,Year> [SumOfSch Hrs])

any idea where im going wrong?

Re: Set analysis for a bar chart

maarcus_smith — Fri, 26 Nov 2021 08:55:17 GMT

hi @Or

sorry i should have said that when i put it in the expression editor, it says expression ok but no data is coming up.

i know data is there as when i would select a value in the "stream" field, it changes the chart.

my expression =

sum({<Flag={"1"} ,[Stream]={'Old'}>} [Total Hours])
/
sum({<[Type]=,Flag={"1"}, [Type]={'Old'}>} total <Week,Year> [SumOfSch Hrs])

any idea where im going wrong?B

Re: Set analysis for a bar chart

Or — Fri, 26 Nov 2021 19:03:47 GMT

Check each part of the formula individually. At the very least, having Type = and Type = {Old} is redundant in the bottom sum. Shouldn't it be Stream = Old rather than Type = Old?