Amount of hours by month with >350

[fkeuroglian]

Hi Expert

I have  distribuate hours and tickets for parking, as you see in the screen , i have select one MONTH, and one DAY and i see the amount of tickets for this day, this month.

if the amount of tickets is >350, i paint it black

But i want to calculate and see in a char , the number of hours that i have more than 350 in the whole MONTH, not only in the day

for example:

in october , i have only one with more than >350, i wan to see a bar chart, that show Octobre with only 1 item

but if in november i have 5 hours wiht more than 350, i want to see teh bar chart with november and 5 items count

attached  a qvw with example and image to show

thank you a lot expert

Fernando K.

[marcus_sommer]

Maybe a calculated dimension - in chart or listbox - like:

aggr(class(count(Hour), 100 /* or more flexible with a variable like $(vHourCluster) */), Hour)

is a useful approach or a set analysis filter like:

count({< Hour = {"=count(Hour) > 350"} >} Hour)

- Marcus

[eduardo_sommer · Accepted solution]

Hi, Fernando

If you create a bar chart with %MesAño as the Dimension and

    =sum(aggr(if(count(Ticketnumber)>350,1,0),%MesAño,[Dia Mes],FranjaHorarioParking))

as the expression, I thik you'll have what you need

Eduardo