Forum Discussion
Grouping Field Parameter
- 1 year ago
Hello Anonymous ,
the grouping will be after the last parameter shich is the sorting one as the follows
time_field = {
("etl_update_time", NAMEOF('mvpmonitoring'[update_time_hour_ts]), 0, "group 1"),
("etl_update_time_month", NAMEOF('mvpmonitoring'[update_time_Year-Month]), 0, "group 1"),
("etl_update_time_day", NAMEOF('mvpmonitoring'[update_time_Year-Month-Day]), 0, "group 1"),
("etl_update_time_hour", NAMEOF('mvpmonitoring'[update_time_hours]), 0, "group 1"),
("etl_insert_time", NAMEOF('mvpmonitoring'[insert_time_hour_ts]), 1, "group 2"),
("etl_insert_time_month", NAMEOF('mvpmonitoring'[insert_time_Year-Month]), 1, "group 2"),
("etl_insert_time_day", NAMEOF('mvpmonitoring'[insert_time_Year-Month-Day]), 1, "group 2"),
("etl_insert_time_hour", NAMEOF('mvpmonitoring'[insert_time_hours]), 1, "group 2"),
("etl_source_time", NAMEOF('mvpmonitoring'[source_time_hour_ts]), 2, "group 3"),
("etl_source_time_month", NAMEOF('mvpmonitoring'[source_time_Year-Month]), 2, "group 3"),
("etl_source_time_day", NAMEOF('mvpmonitoring'[source_time_Year-Month-Day]), 2, "group 3"),
("etl_source_time_hour", NAMEOF('mvpmonitoring'[source_time_hours]), 2, "group 3")
}
Hello Anonymous ,
the grouping will be after the last parameter shich is the sorting one as the follows
time_field = {
("etl_update_time", NAMEOF('mvpmonitoring'[update_time_hour_ts]), 0, "group 1"),
("etl_update_time_month", NAMEOF('mvpmonitoring'[update_time_Year-Month]), 0, "group 1"),
("etl_update_time_day", NAMEOF('mvpmonitoring'[update_time_Year-Month-Day]), 0, "group 1"),
("etl_update_time_hour", NAMEOF('mvpmonitoring'[update_time_hours]), 0, "group 1"),
("etl_insert_time", NAMEOF('mvpmonitoring'[insert_time_hour_ts]), 1, "group 2"),
("etl_insert_time_month", NAMEOF('mvpmonitoring'[insert_time_Year-Month]), 1, "group 2"),
("etl_insert_time_day", NAMEOF('mvpmonitoring'[insert_time_Year-Month-Day]), 1, "group 2"),
("etl_insert_time_hour", NAMEOF('mvpmonitoring'[insert_time_hours]), 1, "group 2"),
("etl_source_time", NAMEOF('mvpmonitoring'[source_time_hour_ts]), 2, "group 3"),
("etl_source_time_month", NAMEOF('mvpmonitoring'[source_time_Year-Month]), 2, "group 3"),
("etl_source_time_day", NAMEOF('mvpmonitoring'[source_time_Year-Month-Day]), 2, "group 3"),
("etl_source_time_hour", NAMEOF('mvpmonitoring'[source_time_hours]), 2, "group 3")
}
- Anonymous1 year agoNot applicable
Idrissshatila thank you so much! It works!