Answered

Show columns without data in barchart

(0) Share

Report

Posted on by Afkael

Hi.. im not a programmer and dont speak english, sorry, but looking for help because need create a weekly barchart and want to show each day's bar (or empty space).

I know what's is wrong (the missing days group do not exist) and i created a collection called "Semana" with all days, but.. i don't know how combine it with de main data (Ticket Soporte) for my purpouse

this is my code:

AddColumns(GroupBy(AddColumns(Filter('Ticket Soporte'; (Created >= DatePicker1.SelectedDate) && (Created <= DatePicker1_1.SelectedDate));"Día_Semana";Switch(Weekday(Created);1;"Dom";2;"Lun";3;"Mar";4;"Mie";5;"Jue";6;"Vie";7;"Sab"));"Día_Semana";"Día");"Casos";CountRows(Día))

if you can explain me or recommend a tutorial relatively specifics i appreciate so much

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Afkael ,

Can you try the below:

With( {_PeriodTickets: Filter( 'Ticket Soporte'; Created >= DatePicker1.SelectedDate; Created <= DatePicker1_1.SelectedDate ) }, AddColumns( Sequence( 7; 1 ) As Days; "Día_Semana"; Switch(Days.Value;1;"Dom";2;"Lun";3;"Mar";4;"Mie";5;"Jue";6;"Vie";7;"Sab"); "TicketCount", CountRows( Filter( _PeriodTickets; Weekday(Created) = Days.Value ) ) ) )

Basically it creates a sequence from 1-7 and then adds a column for "Día_Semana" and a column that has the count of tickets for that day within the selected time period.

Was this reply helpful? Yes No
Afkael 7 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi.. the code have some mistakes because my regional configuration (i used ";") but it working!!.. Now, i studing you resolution for i incorpotare in my knows. Thank you!!

With( {_PeriodTickets: Filter( 'Ticket Soporte'; Created >= DatePicker1.SelectedDate; Created <= DatePicker1_1.SelectedDate ) }; AddColumns( Sequence( 7; 1 ) As Days; "Día_Semana"; Switch(Days.Value;1;"Dom";2;"Lun";3;"Mar";4;"Mie";5;"Jue";6;"Vie";7;"Sab"); "TicketCount"; CountRows( Filter( _PeriodTickets; Weekday(Created) = Days.Value ) ) ) )

Was this reply helpful? Yes No